In this course we look in detail at a set of technologies named LINQ (Language Integrated Query) using the C# language. LINQ is a Microsoft .NET technology that adds querying capability to .NET. LINQ can be likened to SQL but the functionality is executed at a higher level of abstraction. It supports data retrieval from heterogeneous data sources, where queries can be executed directly on for e.g. data collections from within your .NET code. This is a very powerful technology that in my opinion every .NET developer should learn. A special thank you to FreeCodeCamp for sharing this course on the FreeCodeCamp community TH-cam channel. I hope you enjoy this course and benefit from it.
2:31:41 The Enumerable.Empty() method returns an empty sequence of type TResult. It is useful when you need to return an empty sequence of a specific type without creating an instance of a collection. Instantiating an empty list using the List constructor creates an instance of the List class in memory. If you are dealing with a high throughput application, this could have a noticeable impact on performance. Using Enumerable.Empty() does not create an object per call and therefore puts less load on the garbage collector.
Excellent resource, The guy is literally breaking examples from Microsoft docs in a much simpler way. Everything you need to know about LINQ is here and that goes for partial entity framework core as well as it heavily uses LINQ about 80% of the time when you are done creating entities and are just working with retrieving them
Excellent course! Few months back I had watched his advanced generics series, truly was something I haven't seen on TH-cam before. Thanks free code camp and Gavin for this masterpiece 🙏
I'm only in the first lesson, but I'm a bit confused as to why we are adding Employees inside of the GetEmployees function (same with Departments). Wouldn't it be better practice to do that somewhere else in the code so it doesn't run every time we call the function?
I guess it's to simulate a real-life experience where you wouldn't hardcode the list of employees directly into your application but you would keep them in some kind of file or database and make a call to fill the temporary list in your app. Although, essentially, we are actually still hardcoding it here like you noticed ;)
Code readability is a matter of preference and is context specific. In your example, I could argue either way for LINQ syntax vs Query syntax. Readability is context specific because it depends on the complexity of your data queries. If you want to do simple one line filter, the Query syntax is too verbose where Method syntax is simple and concise. I would be curious who said that Query syntax over Method syntax is preferable ... Because it is a bad recommendation.
This guy's jagged narration style is very difficult to follow. Bleh. His coding style also lacks functions, a coding pattern that would be really helpful when dealing with different functionalities in the language.
In this course we look in detail at a set of technologies named LINQ (Language Integrated Query) using the C# language. LINQ is a Microsoft .NET technology that adds querying capability to .NET. LINQ can be likened to SQL but the functionality is executed at a higher level of abstraction. It supports data retrieval from heterogeneous data sources, where queries can be executed directly on for e.g. data collections from within your .NET code. This is a very powerful technology that in my opinion every .NET developer should learn. A special thank you to FreeCodeCamp for sharing this course on the FreeCodeCamp community TH-cam channel. I hope you enjoy this course and benefit from it.
You’re a legend Gavin, thank you
one of the best tutorials for LINQ. Even as a senior softawre engineer it helped me to recall the concepts.
2:31:41 The Enumerable.Empty() method returns an empty sequence of type TResult. It is useful when you need to return an empty sequence of a specific type without creating an instance of a collection.
Instantiating an empty list using the List constructor creates an instance of the List class in memory. If you are dealing with a high throughput application, this could have a noticeable impact on performance. Using Enumerable.Empty() does not create an object per call and therefore puts less load on the garbage collector.
Beautiful explaination. I use LINQ statements every day for work and this was not explained nearly as in depth during my bachelor's. Thank you
same here
Excellent resource, The guy is literally breaking examples from Microsoft docs in a much simpler way. Everything you need to know about LINQ is here and that goes for partial entity framework core as well as it heavily uses LINQ about 80% of the time when you are done creating entities and are just working with retrieving them
Excellent course!
Few months back I had watched his advanced generics series, truly was something I haven't seen on TH-cam before.
Thanks free code camp and Gavin for this masterpiece 🙏
I am so excited to be part of this class, thanks
Inner join query: 1:06:28 left outer join query: 1:16:44
Perfect! Just perfect! Was worth all the 3 hours of it (although I spent only 2 using INTED))))
I appreciate this course , a very good effort and clear explanation , a treasure in youtube
Enjoyed whole tutorial 💡🎉
This is really a great tutorial on LINQ! ❤❤❤
Nice! It was a very useful walkthrough code session
Roland never disappoints!
best linq tutorial 😌
All you need to know about this framework DataTable , DataRow , DataColumn , DataRelation , and Linq
no, u need to know also, authorization attribs, regex, files manipulation, encoding, cqrs approach, ddd, translated enumerations
Big thanks for useful tutorial.
Amazing content
best linq content
Absolute legend!
great
That's Just Great❤
Could you please put in a playlist
Could you please do a advanced tutorial video on android application development using KOTLIN
Thanks for the video, i guess your success..
Could you please do a full PHP / Laravel course under 2 hours for beginners?
I'm only in the first lesson, but I'm a bit confused as to why we are adding Employees inside of the GetEmployees function (same with Departments). Wouldn't it be better practice to do that somewhere else in the code so it doesn't run every time we call the function?
I guess it's to simulate a real-life experience where you wouldn't hardcode the list of employees directly into your application but you would keep them in some kind of file or database and make a call to fill the temporary list in your app. Although, essentially, we are actually still hardcoding it here like you noticed ;)
Code readability is a matter of preference and is context specific. In your example, I could argue either way for LINQ syntax vs Query syntax. Readability is context specific because it depends on the complexity of your data queries. If you want to do simple one line filter, the Query syntax is too verbose where Method syntax is simple and concise. I would be curious who said that Query syntax over Method syntax is preferable ... Because it is a bad recommendation.
Is there anyone who watch this video with normal speed?
Of course. Plenty of time to take notes and appreciate this excellent, free content.
@@bojohannesen4352 i confirm this is a treasure even though it is a lil bit fast to beginners
Sir plz upload tutorials and some Projects in React Native from basic to advance
Visual Studio for mac looks more like a text editor than an actual IDE.
He speaks very clearly but the echoing is very disruptive lol
Thanks!
please do a video bout TCL?
Can u make video on Extension method linq query approach .
It would be helpful
great!
Make video in Adobe Photoshop plzz.
This was much needed Lmao
10:00
Great!
❤
Hahah every time he says Func... Definitely sounds like something more obscene
👍👍👍
Jan Isle
Datepart() in linq anyone?
Why are you obliged to have a cap and be middle aged to programm in c#?
lmao
☝️
Wild, .NET peeps still using ORM? Good video though.
This guy's jagged narration style is very difficult to follow. Bleh. His coding style also lacks functions, a coding pattern that would be really helpful when dealing with different functionalities in the language.
First to watch and comment
Hello, i send you a e-mail
First