3 ms·
If you use a modern IDE and extract your SQL into separate files you can get syntax checking, and even the ability to run the query on-server directly and get a
by CuriouslyC 8y ago
If you use a modern IDE and extract your SQL into separate files you can get syntax checking, and even the ability to run the query on-server directly and get a table of results in a table-formatted tab with a single click. How much do you have to do to get your ORM to run your query, and are the results as easy to work with?
- scarface74 8y agoWith LINQ (I hate most other ORMs) you get objects back and you use the same query syntax for working with RDMS’s, NoSql data stores, REST APIs, in memory collections, etc. If you had an in memory list you would write: var seniors = from c in customers where c.Age > 65 If you were using an RDMS you would write: var customers = context.Customers var seniors = from c in customers where c.Age > 65 If you were using Mongo you would write: var customers = database.GetCollection<Customers>(“Customers”) var seniors = from c in customers where c.Age > 65 In each case, the query would be translated appropriately - as in memory code, SQL, or MongoQuery respectively.