3 ms·
This isn't about ORMs or database performance. It's just a comparison of query languages, with LINQ being more natural for data models with lots of joins and ne
by manigandham 7y ago
This isn't about ORMs or database performance. It's just a comparison of query languages, with LINQ being more natural for data models with lots of joins and nested records that are common today (especially since that's how people work with objects inside their programming language).
SQL is far from perfect. It would be nice to see some modern SQL dialects that follow the LINQ syntax and are natively supported by RDBMS.
- taeric 7y agoWith a lot of nested joins, both options suck. You are best abstracting. So, likely a view.
- scarface74 7y agoLinq is horrible for outer joins, the syntax is completely unintuitive to the point that I’ll just use raw sql.