DCSIMG
C#,SQL Server - Smallfish

Smallfish

Tips, Tricks, Shticks & Anything That Can Help You Be better Developer

Browse by Tags

All Tags » C# » SQL Server (RSS)
LINQ to SQL Performance loading Hierarchical data
Last week I have trying to load hierarchical data from the same table (Parent/Child). Although I have made it in the past, I was searching the way to accomplish it with LINQ to SQL without SP or at least with the minimum required (in any case, I had a "fallback"). After 4 hours of searching the net without success (there are plenty of articles, nothing met my requirements see here and here ). Then I thought to give LINQ a chance, and I just used it querying the association created by the...