4 ms·
> "Yes, EF queries are more readable to many developers who know C# well but don't want to get used to SQL." My main field is databases. Been working with SQL
by alexvoda 7y ago
> "Yes, EF queries are more readable to many developers who know C# well but don't want to get used to SQL."
My main field is databases. Been working with SQL for ~15 years. My knowledge of LINQ is much less than SQL (partly also because I was writing plenty of SQL before LINQ existed).
I also think SQL is a big big mess full of leaky abstractions that forces you to do things in unituitive ways. And yet it is incredibly powerful. But don't listen to me. Read any book by C.J.Date (especially this one http://www.thethirdmanifesto.com/ http://www.thethirdmanifesto.com/), for all the reasons SQL is poorly designed.
> "But the problem with that is DB apathy.....leads to some real performance problems....."
I completely agree. Databases are very powerful and more people should know how to properly use them so that the rest of us would have fewer headaches.
> " It's a DSL designed for the job, you really can't get much better"
The problem is that due to many reasons it is the only such DSL in wide spread use. Any alternatives are just footnotes.