C# Tutorial 15 LINQ Tutorial


Get the Code Here :
Best C# Book :
Support me on Patreon :

In this video I’ll cover LINQ. Language Integrated Query (LINQ) provides many tools for working with data. LINQ is similar to SQL, but it can work with data aside from databases. I’ll cover From, Where, Orderby, Select, In, Inner Joins, Group Inner Join, Equals and using LINQ with multiple different collections.

For best results take notes on the cheat sheet provided above as you watch and leave any questions you have.

Thank you to Patreon supporters like the following for helping me make this video

jaryd remillard : instagram: @distant_admiration
jaryd remillard :


Xem Thêm Bài Viết Khác:https://wijstaanvooronzegrondrechten.org/cong-nghe


  1. Thank you very much good sir! I've been struggeling to understand LINQ but I'm getting to understand it way more when you explain it then when my teacher explains it. Still have problems with subqueries in combination with many to many relationships 🙁

  2. Derek, Awesome tutorial!!
    Thank you, at 23:04 The error occurred because you need to have int totalAnimals = 0; in order to use totalAnimals++; in the foreach loop.

  3. I found the last example extremely confusing, though it is a good video. On the link shown, I put a question to stackexchange. Thanks for anybody who might help…

  4. Class structure a bit confusing….
    AnimalId doesn't uniquely identify the animal, as one might think….
    Still, a good video.

  5. You offer better quality content than paid versions.

    Thank you very much for your efforts.

    respects from Turkey, I owe you a beer if you come

  6. Nice tutorial, but I have a question because I am not sure if I understand the last part – it says owner2 while I think it should be animal2, am I wrong? At least my solution seems more intuitive for me

  7. Could you please explain me last query? I am not sure if I got it right..
     "var groupJoin =
    from owner in owners
    orderby owner.OwnerID
    join animal in animals on owner.OwnerID
    equals animal.AnimalID into ownerGroup
    select new
    Owner = owner.Name,
    Animals = from owner2 in ownerGroup
    orderby owner2.Name
    select owner2

  8. great videos! (and voice!)- could you discuss how to use lambdas with it? fror example sorting 3 colmns that have difernt inormation in each col – to be sorted into 3 arrays….

    var sumOfLines = File.ReadLines(myFile)
    .Select(x => x.Split(null))
    .Select(z => new {
    ItemType1 = z[0],
    ItemType2 = z[1],
    ItemType3 = z[2]

  9. I am lucking for collaborations for a open sources project to #America2015Fundamentals future implications . I can't promisse nothing, only Hope , coming from #GoodMorningFuture and #EarthProudDay . See InfinityDivergentConjecture.PDF #InfinityDivergentConjecturePDF at " www.climaticdisorder.com/ " . If inspired Email to : shoetheory@climaticdisorder.com your intentions.

  10. Thank you for the tutorial! As I'm already familiar with SQL, this was super easy for me to follow. Big fonts, clear language and structure, perfect. One point though: joining animals to their owners based on their respective IDs seems wrong to me, I'd expect at least an animal.OwnerID property to join it with owner.OwnerID

  11. This is pretty good! Clear and to the point, with a good rythm. I'm attending a coding bootcamp and tomorrow we'll dedicate the day to LINQ, so this is perfect to jumpstart my knowledge before we dig into it.

  12. Could not find an implementation of the source type?

    Trying to implement LISQ into my project which reads a JSON file contains albums and deserializes it. I have a class for all the album info and another class containing a list of the albums. Problem is a can't use LISQ without adding a list interface but if I do it can't deserialize the JSON file 🙁


Please enter your comment!
Please enter your name here