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
facebook.com/cottageindustriesbuild/
jaryd remillard : instagram: @distant_admiration
bugreplay.com
@kyleaisho
@thetwistedhat
vjFaLk
jaryd remillard :
Nguồn:https://wijstaanvooronzegrondrechten.org/
Xem Thêm Bài Viết Khác:https://wijstaanvooronzegrondrechten.org/cong-nghe
C# version of sql?
You are the best best best. 🙂
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 🙁
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.
Thank you for your video. It is helpful. It may be more perfect if introducing group join with more details
Helped a LOT, thanks man.
Did you just call Shrek an Animal 😮
RIP performance.
I felt like a kid finding a candy when it compiled correctly :')
I like your style. Sub'd
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…
https://stackoverflow.com/questions/56783297/linq-join-does-not-seem-to-have-data-of-the-complete-join
Class structure a bit confusing….
AnimalId doesn't uniquely identify the animal, as one might think….
Still, a good video.
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
5:11 wow wow wow take it easy there felllllah 😀
That was very helpful. I like the bite size format
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
4:10 rofl
I thought I was listening to Bill Belichick.
LINQ Rules
(Thank you for this video)
"whhhheeelllloooo innnnet…" I get excited now when I hear it, like the intro to a netflix series…
Nice example! Thank you.
LINQ Rules
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
};"
"So pretty cool stuff"
Brilliant as usual 🙂
No face no trust,
In the last example you really should name the ownerGroup as ownedAnimals, makes it more understandable:)
Who else came here to know how "linq" was pronounced?
Anyone aware of how to test a set that has two or more adjacent and equal elements?
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]
});
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.
Absolutely Brilliant! Keep up the good work.
Loving this….thank you so much! This is a great refresher for me.
Big dog!
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
Great tutorial!
Wow, I've been wrestling with this pretty much all day. I'm trying to expand it by designating breeds to Breed. 🙂
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.
simple and direct 🙂 nice video
Very good stuff. Thanks for posting.
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 🙁
4 hours in class i didn t get it, see this video, it s actually not that hard atleast this part :p thx men!
I really don't like the way you type the code.