We Can Do Better Than SQL

Re:We Can Do Better Than SQL by nightski on Tuesday August 11, 2020 @12:11PM (#24121977)

Yeah I feel like that happens whenever you have a mapping from one language to another. Eventually you learn the intricacies of the transformation. There are very few situations where the Linq I write does not translate into the query I expect any more. But that took time to learn.

The only criticism I have of Linq is that it is a more general language targeting different back-ends including plain old objects. If Linq did not allow things that do not make sense in SQL this would be a little less jarring.

I also wish it supported full outer joins, unions, and window functions.

[ Parent | on HN ]

Re:We Can Do Better Than SQL by scarface74 on Wednesday August 12, 2020 @11:11AM (#24132825)

I was amazed the first time I used the MongoLinq driver. It makes sense intuitively, but the idea that you can use the same Linq expression and it will be translated to either Sql or MongoQuery based on the provider you send it to was amazing.

I was able to hire a four or five contractors who never used Mongo just by requiring Entity Framework/Linq experience and less than 4 hours of training.

[ Parent | on HN ]