News for hackers. Stuff that matters.
Re:SQL queries don't start with SELECT by manigandham on Thursday October 03, 2019 @07:39PM (#21153417)
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.

Re:SQL queries don't start with SELECT by scarface74 on Friday October 04, 2019 @08:28AM (#21156940)
Linq is horrible for outer joins, the syntax is completely unintuitive to the point that I’ll just use raw sql.
Re:SQL queries don't start with SELECT by taeric on Thursday October 03, 2019 @10:29PM (#21154324)
With a lot of nested joins, both options suck. You are best abstracting. So, likely a view.