Doesn’t Linq to SQL miss the point? Aren’t ORM-mappers (SubSonic, etc.) sub-optimal solutions?

by

Let me preface this by saying that I am a dyed-in-the-wool database guy.

As a gross over-generalization: Developers don’t know SQL. Developers don’t really want to know SQL. They can write it, they can design tables, but it makes them feel icky. They tend to do stupid things when the necessary query is more than a simple join. Not because the developers are stupid — because they can’t be bothered. They like living in a world where they only have to deal with one concept space; moving from objects to tables and back is a context switch the price for which they don’t like paying.

This doesn’t mean they are bad, or wrong; it means there is an opportunity for improvement. If your customers (in this case, developers using your framework) don’t like SQL and tables — give them a layer of abstraction that lets them get away without dealing with the underlying mess.

It’s the same logic that makes garbage collection / automated memory management a big hit. Yes, developers can deal with it; yes, they can write code that is better optimized without it; but not having to deal with it makes them happier and more productive.

More Related Contents:

  1. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  2. How to store a list in a column of a database table
  3. efficient way to implement paging
  4. Linq version of SQL “IN” statement
  5. How can you handle an IN sub-query with LINQ to SQL?
  6. SQL to Entity Framework Count Group-By
  7. How do I use SQL’s GETDATE() and DATEADD() in a Linq to SQL expression?
  8. Is there a difference between Select * and Select [list each col] [duplicate]
  9. LINQ to SQL query using “NOT IN”
  10. Linq to SQL: How do I stop the auto generated object name from being renamed?
  11. Refactor a PL/pgSQL function to return the output of various SELECT queries
  12. Can I use CASE statement in a JOIN condition?
  13. sql server 2008 management studio not checking the syntax of my query
  14. How do I write a full outer join query in access
  15. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  16. Select count(*) from multiple tables
  17. How to run a SQL query on an Excel table?
  18. When to use SQL Table Alias
  19. LEFT OUTER JOIN in Rails 4
  20. Column ‘mary’ does not exist
  21. GROUP_CONCAT in SQLite
  22. Split comma separated values of a column in row, through Oracle SQL query
  23. oracle — Split multiple comma separated values in oracle table to multiple rows
  24. Pivoting in DB2
  25. How to compare sqlite TIMESTAMP values
  26. How do composite indexes work?
  27. Using django how can I combine two queries from separate models into one query?
  28. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  29. Previous Monday & previous Sunday’s date based on today’s date
  30. SQL add filter only if a variable is not null

Leave a Comment