C# Tutorial 15 LINQ Tutorial

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
@kyleaisho
@thetwistedhat
vjFaLk

[tuck]

"whhhheeelllloooo innnnet..." I get excited now when I hear it, like the intro to a netflix series...

[BijouBakson]

It's literally SQL except you put your select statement in the end. Saves me some time :)

[Robber]

Excellent introduction to LINQ. This is my first time seeing it and I love it already.
Thanks for not havin any bullshit in the video, only good stuff. Thanks bud.

[Russellyeman]

A straight forward, no nonsense tutorial minus the usual ego and padding, in an accent I can listen to - thank you!

[nullptryt]

This is exactly what I needed and you couldn't have explained it any simpler. Thank you sir!!

[hasan]

just Brilliant! I've read a chapter on LINQ, but i couldnt quit figure out the groupJoin. Thanks to your video, i finally get it!

[jnwatts]

Loving this....thank you so much!  This is a great refresher for me.

[ComandanteJ]

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.

[dawidkowalski]

I' m your big fan! Keep doing this great work!

[lawrencemilne]

ty for all your vids. i am a highschool student and its hard to find good free resources on programming. you are always the first place i look for tuts bc you get right to the point and don't waste time

[VoOoLoX]

Great video as always, I've learned a lot in these few videos even tho I already have few years of experience with C#.
I'd like to see a tutorial on OpenGL.

[Rajivrocks-Ltd.]

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 :(

[BritshBeef]

Absolutely Brilliant! Keep up the good work.

[darielsubiros]

Excellent is not a good enough word to describe your skills to produce such a good tutorial! Keep it up!
God bless you!

[buffaloSoldier]

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 :(

[blyatman]

Hi Derek, currently bench watching this. I was wondering why using a Arraylist instead of a generic List, is there any difference in performance speed or memory wise ?

[christianrodier]

That was very helpful. I like the bite size format

[simonkalu]

This is a good reference. Derek is awesome

[vungocanh]

Tks Derek Banas. I very very like your videos. It's great :)

[ThePersBoy]

Thank u very much, everything about this video is great specially(the big font/zoom of the code) ;)