C# Tutorial 15 LINQ Tutorial

[@BijouBakson]

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

[@Russellye5man1]

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

[@derekbanas]

Thank you for the compliment :)

[@tuck582]

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

[@derekbanas]

That's funny :) I'm happy you enjoy the videos

[@RP-mp4ow]

Same!

[@StygianStyle]

It's like AOL: yee-ooo gawt may-el!

[@Robber7]

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.

[@derekbanas]

Thank you for the nice compliment :)

[@nullptryt]

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

[@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.

[@derekbanas]

Thank you :) Have fun at your bootcamp

[@ComandanteJ]

Derek Banas Will do!

[@ComandanteJ]

@@derekbanas Hey! I ended up getting hired after the Bootcamp, in part thanks to your vids, so, that's awesome, hehe. In relation to this one, would it be difficult to make some of the properties dynamic? For example, something like: order by dog("some string").

[@hasan4334]

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!

[@derekbanas]

That's great! I'm glad it helped :)

[@lawrencemilne5145]

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

[@derekbanas]

Thank you for the compliment :) I'm happy I can be of help

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

[@derekbanas]

I'm happy I could help :)

[@NoOne-wf6hm]

Loved all the the parts where Derek explains (again and again): Not to Forget to Call the Methods in order to work! xD This is the same as saying: the developer is responsible to clean his mess (Clean the Code and Dispose Resources). Two Hands up! Superb Tutorial!

[@derekbanas]

Thank you very much :) I'm happy you liked it

[@demowarui]

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

[@derekbanas]

I'm very happy to be of help :) I agree. I did that mainly to save time

[@simonkalu]

This is a good reference. Derek is awesome

[@derekbanas]

Thank you :) Happy I could help

[@juanlizle]

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.

[@jnwatts]

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

[@derekbanas]

I'm very happy to be able to help :)

[@darielsubiros3787]

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

[@derekbanas]

Thank you for the compliment :) May God bless you.

[@antalsergiu7649]

Very cool tutorial but pretty confusing in the end with the variable names you used, for example when creating the list with Animals you Used Animals = from owner2 in ownerGroup select owner2, you could use "animal" for the variable and it would have been more clear, something like from animal in ownerGroup select animal. At least for me it took some minutes to figure out what you tried to do there, sometimes bad variable naming is raising more questions than the code itself. That's just my 2cents. Thanks for the tutorial!

[@derekbanas]

Thank you for the input. Sorry about the strange names

[@christianrodier3381]

That was very helpful. I like the bite size format

[@derekbanas]

Thank you :)

[@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.

[@derekbanas]

Thank you very much :) I plan on getting to OpenGL this year. I'll be doing much more with games and graphics soon

[@zaferzafferoglu9520]

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

[@derekbanas]

Thank you for the nice compliment :) I wish I was wealthy enough to travel all over the world. I find other countries extremely interesting. Also I have been offered beer in nearly every country so that would be fun :)

[@zaferzafferoglu9520]

@@derekbanas It is possible to visit in cheap periods. You are a citizen of a country that does not have a visa problem.

[@arclasses1527]

nice explanation. this tutorial has made me understand how to write linq queries easy and simple. thanks for the video. Thanx :)

[@derekbanas]

I'm very happy to be able to help :)

[@The123Augustas]

9 hours until exam ty man

[@maryz6672]

when i comes to code derek is the epitome of the best. i've never seen anyone this good.

[@futuregeneration8348]

Thank you so much. It was great but can you make video about same thing but with c# GUI

[@dawidkowalski7501]

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

[@derekbanas]

Thank you very much :)

[@MatheusSilva-gx8sj]

Nice example! Thank you.

[@derekbanas]

Happy I could help :)

[@jimzoo5254]

Thank you for your video. It is helpful. It may be more perfect if introducing group join with more details

[@derekbanas]

Happy it helped :) I always have ways to improve

[@manoelramon8283]

ArrayList and List are both collections. Just to remind you that.

[@AKTSR444]

6:30 start to get lost

[@BritshBeef1]

Absolutely Brilliant! Keep up the good work.

[@derekbanas]

Thank you very much :)

[@gromstoso]

Helped a LOT, thanks man.

[@derekbanas]

Happy I could help :)

[@ReactionByAI]

Thank you. You explained it so well.

[@derekbanas]

Thank you very much :)

[@tomasoom7423]

I already installed the Linq thing to my Visual Studio 2019 but for no reason at all, the System.Data.Linq is to available. What can i do to fix this error?

[@ThePersBoy]

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

[@derekbanas]

Thank you I'm very happy you liked it :)

[@PixelTB]

How did you declared an array using Array? As far as I know the arrays are declared using a datatype and then the square brackets, for example: int[] numbers = new int[];

[@bartonpaullevenson3427]

Very good stuff. Thanks for posting.

[@derekbanas]

Thank you :)

[@aychtooo3981]

Hey derek: You have, by far, the best tutorials out there! However I did notice one problem from your python tutorial you should fix in your C# tutorial: you did not cover enough libraries. I kind of wish, for C# at least, when you are done teaching the language, and maybe even when you are done making game idk your schedule, you should really spend one video each, no matter how short or long, to not cover the entire library, but at least the useful parts of multiple libraries

[@derekbanas]

I plan on covering C# in massive detail like I did with Java

[@wojtek9395]

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

[@j0nj1]

Hi Derek, I started learning programming through SQL and have been trying to branch out into other interesting stuff. I'm trying to make sure I properly understood LINQ syntaxe. Could the last example you made be translated as follows into SQL ? : SELECT owner.Name Owner, GROUP_CONCAT(animal.name) AS Animals FROM owner o JOIN animal a ON (o.OwnerId = a.AnimalID) GROUP BY owner.Name Thanks !

[@vungocanh4046]

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

[@derekbanas]

Thank you very much :)

[@blyatman635]

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 ?

[@jaatharsh]

just awesomely explained, thanks Sir

[@derekbanas]

Thank you very much :)

[@sandeepvk]

Hi Derek, If you were to build a Pateron style Webapp what stack would you use ? Would a MEAN stack work well as compared to the classical MVC style using Django or flask or PHP ?

[@derekbanas]

I'd use PHP and Laravel because that is what I use every day. Django would also be good for a big site. This opinion is purely based off of what I'm used to using

[@jlitodelcid326]

I felt like a kid finding a candy when it compiled correctly :')

[@derekbanas]

I get that feeling every day :)

[@Hunter-fy1tp]

Sorry for my total off topic question about this video, but do you have a preference on tutorials/book for C# and Unity? I know you plan to do videos (thank you extremely!), but I've also been trying to find some other sources for that too; if you know any that'd be awesome :) Thanks Derek, keep up the good work!

[@derekbanas]

When I was learning Unity I started with the tutorials on the site and then to blogs. There weren't really any good books at the time. I'm investigating now to see if that has changed

[@2271masoud]

This tutorial talks a 500 page book Many thanks Derek

[@derekbanas]

I'm happy you liked it :) Yes I'm basically covering everything you'd learn in a 1000 page book on C#

[@mudzibaba]

@@derekbanas Books 0 : 1 Bananas

[@Brandon-ob9rg]

Why in the world would anyone want to write SQL like syntax in their code?! This is madness!!!

[@judasknox3354]

The Group Join, left me spinning. It was a bit overwhelming, for me. I liked, how you explained the association between keywords and the variable they manipulate, but the naming of the variables, is a bit confusing, and I tend to get the var. names mixed up. Here is the Group Join, of the Animals heading, with the owners listed below them; even though I still don't have this digested intellectually, I managed to get it to work. // the arrays are the same ones as in this tutorial var groupJoin2 = from animal in animals orderby animal.AnimalID join owner in owners on animal.AnimalID equals owner.OwnerID into animalGroup select new { Animal = animal.Name, Owners = from animal2 in animalGroup orderby animal2.Name select animal2 }; foreach (var animalGroup in groupJoin2) { Console.WriteLine(animalGroup.Animal); foreach(var owner in animalGroup.Owners) { Console.WriteLine("* {0}", owner.Name); } } // THANK YOU FOR THE LESSON

[@buffaloSoldier519]

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

[@exzm2580]

Hey Derek. I just have a question, do you need to be extremely good at maths to be a hacker or a programmer? Because that's what some people are posting on the Internet. If yes what exactly and specifically do you require?

[@derekbanas]

Hey, In my opinion no. Math and programming involve logic, but I think it is of a different type. Programming is more about breaking big things down into a series of steps. Math is much more abstract. Get good at problem solving and you'll be a good programmer. Check out my learn to program playlist

[@exzm2580]

+Derek Banas Thanks a lot Derek I appreciate it. I will check the playlist right now.

[@BinaryLizard]

Great tutorial, just a pity you used the non functional SQL-like syntax, the least preferred syntax. The extension methods are way more succinct, composable and aligned with other functional languages.

[@derekbanas]

Thank you :) I covered the extension methods here kzbin.info/www/bejne/Zpq4gX6Qr7SBgMk

[@BinaryLizard]

Oh fantastic, thanks for the link, on my way there now. :-)

[@roberteliassen5020]

Another great one! Thumbs up from me. This is way better than the stuff you pay for, except John Skeets stuff of course. But he's the God of the gods. ;-)

[@derekbanas]

Thank you :) I agree John is a great guy

[@SunnyApples]

Thank you very much for the lesson!

[@derekbanas]

You're very welcome :)

[@hamzaliaqat7192]

I was waiting for it. please also do one tutorial on winform. I already knows it but I always learn new things from you

[@derekbanas]

Windows forms are coming soon :)

[@hamzaliaqat7192]

Derek Banas Okay. thanks :). I'm actually very happy that you replied, i commented once before on your video, I thought you didn't reply me on it but I was wrong.

[@derekbanas]

I reply to every comment KZbin sends me. Just make sure that you always create a new comment thread because KZbin only sends me those for some reason? My #1 purpose on KZbin is to answer questions and to help people.

[@derekbanas]

WPF

[@dosdeviant]

This would be absolutely unreal. I can't wait to see how cover WPF! Thanks for all your efforts.

[@goranivetic3737]

Thanks! found so many useful things watching your videos overall, but c# i like the most out of all prog languages :) Will you do Unity 3d tutorials maybe? Or Selenium + Nunit in c#?

[@derekbanas]

Thank you :) Yes I'll start making Unity games over the next few weeks. I think I'll make PacMan first

[@goranivetic3737]

Awesome! I've used unity to check engine and its features, it is really awesome and i think that people will like it overall :) best of luck and please keep up this great work you do, you can't imagine how many people i know that found your tuts helpful :)

[@derekbanas]

I'm happy you like the Unity idea and I'm always happy to hear that my videos help :)

[@renevillalta27]

simple and direct :) nice video

[@derekbanas]

Thank you :)

[@travislong2810]

Now that I am getting the hang of this stuff but I've never built anything before do you or anyone have any suggestions on where to start? What would be some good first projects to do or recreate or maybe I should copy some projects online?

[@derekbanas]

I'm going to randomly start making games with Unity in about a week and then on and off for a couple months. I think I'll make PacMan first

[@travislong2810]

Cool thanks Mr. Banas! I appreciate the very easy to follow tutorials. Thanks man! I have been practicing on VS with these for about 6 weeks. I spent 3 or 4 days on a video before progressing upward. I went from my first couple of days wondering where my brackets where going and why I had so many red lines LOL to actually being able to test myself and actually write out some code.

[@SunnyApples]

Travis Chris, me too. I've been supplementing Derek's videos with some other ones I found on KZbin and had great results. Can't wait for all the game dev stuff that is to come in this series. Good luck with your C# studies.

[@travislong2810]

I can't wait too. I am also planning to start making games with Unity soon. Hey maybe we can collaborate in the future? :)

[@SunnyApples]

Definitely! Game development, here I come!

[@maryz6672]

Derek, If you had an ubertooth one and had to make it able to sniff packets in monitor mode with packet injection where would you start???? What would it be scripted in if you had to choose? if you had to make it like airodump-ng but for bluetooth where would one start to make something for it?

[@derekbanas]

I haven't done much on the security front since I was a sysadmin quite some time ago. I'll look into it because it looks fun :)

[@maryz6672]

well i'm looking very forward to your opinion...If you are seriously looking into it is there a way you can let me know some how? I have heard it's possible of bluetooth injection but i'm sure that would involve modifying the firmware...and all kinds of stuff. what does it take to take a device made for bluetooth hacks like that , that are just for sniffing in promiscous mode to be able to inject packets ? i hope you can help....you're an amazing coder derek

[@sipiware]

good stuff, can you please do a tutorial on events and delegates, thank you.

[@rostikdyakiv5182]

Thank you very much for your lessons!!

[@derekbanas]

I'm very happy that you like them :)

[@rostikdyakiv5182]

Looking forward to your new C# videos.It's amazing!!!!

[@claudiodias3168]

Hi very tanks for video, you helped a lot to know how this works.

[@derekbanas]

I'm very happy that I could be of help :)

[@maximmemskiy1402]

Hello. Good lesson! But I wonder how to make the last example (groupJoin) with extension methods. I tried : var animJoin = owners .OrderBy(r => r.OwnerID) .Select(r => new { Owner = r.Name, Animal = owners .Join(animals, o => o.OwnerID, i => i.AnimalID, (o, i) => new { Name = i.Name, Height = i.Height }) }) ; But is doesn't work. I cannot create an IEnumerable Animals as in the video. How would u do this with extenstion method?

[@stevefrt9495]

Thanks you so much Derek

[@derekbanas]

I'm happy you liked it :)

[@illiahoncharenko1417]

Thank you!

[@fredyuldashev]

5:11 wow wow wow take it easy there felllllah :D

[@nv7287]

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] });

[@Agersi420]

​could you maybe make a tutorial on how to search multiple tables, where some are connected with many to many tables. And make sure to stream some more the witness :)

[@derekbanas]

I'm happy you liked The Witness! I loved it! Yes I'll cover more complex ways of using LINQ soon

[@Agersi420]

Any chance you could cover it with some php/sql too :)

[@blu12gaming44]

1:55 you missed 'Ein' from Cowboy Bebop (lol).

[@derekbanas]

That's funny :)

[@trinach93]

Great tutorial!

[@derekbanas]

Thank you :)

[@kilogalaxia2035]

very useful tutorial! Thank you for devoting your time! :)

[@derekbanas]

Thank you :) I'm happy you liked it

[@soapyfruit4731]

LINQ rules :) amazing tutorial

[@derekbanas]

Thank you very much :)

[@RP-mp4ow]

LINQ Rules (Thank you for this video)

[@derekbanas]

I'm happy I could help :) Thank you

[@IamAWESOME3980]

C# version of sql?

[@nicklasisaksson6819]

ArrayList dosen't work im using visual studio in mac what can u use instead?

[@nicklasisaksson6819]

i used this instead and it works List famAnimals = new List(); famAnimals.Add(new Animal(name: "Heidi", height: .8, weight: 18)); famAnimals.Add(new Animal(name: "Shrek", height: 4, weight: 130)); famAnimals.Add(new Animal(name: "Congo", height: 3.8, weight: 90));

[@santhoshm3758]

Linq or SQL Which is Best Performance ?

[@derekbanas]

They are both completely different things. Sorry for not explaining that better. I'll cover databases soon

[@MaidenLoaf]

I suggest giving this a read: docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/linq/.

[@henrik3098]

bro why is ur visual studio that zoomed

[@MegaCODDERS]

4 hours in class i didn t get it, see this video, it s actually not that hard atleast this part :p thx men!

[@derekbanas]

I'm happy that it helped :)

[@jasrobsny]

Anyone aware of how to test a set that has two or more adjacent and equal elements?

[@fxnx38]

Font size is perfect please do not change it

[@paulhamacher773]

but a smaller font size would provide you a better overall view over the code

[@vanttildet3069]

cool stuff

[@lolnoob3868]

which ide is best of c programming graphic

[@derekbanas]

I love Visual Studio

[@marcinkuta5174]

Thank you best of the best:)

[@derekbanas]

Thank you :) I'm very happy you liked it

[@ellena1903]

LINQ Rules! :)

[@derekbanas]

Thank you :)

[@brandonmifsud6727]

You are the best best best. :)

[@derekbanas]

Thank you very much :) I'm happy I could help

[@abdullahrafiq3530]

"So pretty cool stuff"

[@StephenWebb1980]

I like your style. Sub'd

[@derekbanas]

Thank you :)

[@dev__adi]

Do React Js in one video please

[@derekbanas]

I'm working on it

[@RohanGakhare]

Do Angular 2 and TypeScript please

[@derekbanas]

Here is TypeScript kzbin.info/www/bejne/Y4G1kIunjJ59gLc and I'm working on Angular

[@RohanGakhare]

Excellent, you are the man..thanks much!!

[@lemos51]

LINQ Rules

[@IQBooks-pub]

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

[@baguett123]

Andy Bernard?

[@pakoti96]

Did you just call Shrek an Animal :o

[@akab211]

Big dog!

[@patwicker1358]

LINQ rules, at least someone sees these comments :-)

[@derekbanas]

I agree it is awesome :)

[@venkatrao100]

good video for me

[@derekbanas]

I'm very happy that it helped :)

[@jackbisson9226]

I thought I was listening to Bill Belichick.

[@saajid6149]

How do you remember so much stuff??😅

[@derekbanas]

I have been doing this stuff for a long time

[@afrasiabhamid7860]

salam please do on xamarin cross platform thanku

[@derekbanas]

It is coming soon

[@AlexTuduran]

RIP performance.

[@xiangli1309]

I really don't like the way you type the code.

[@xiangli1309]

But I have to give you a "like" because I really enjoy the content of this video.

[@achin4140]

i beg you please i am crying tell about Enterprise java beans , statefull Ejb ,Stateless EJB , Message driven bean , CMP thier lifecycle methods:(

[@derekbanas]

I'll see what I can do about JEE after I finish with C#

[@achin4140]

Dear Sir please tell within 20 days please I am crying so much I am not able to understand enterprise Java beans