Search for existing suggestions

Better match to SQL querying power and control over loading data

I believe Linq to SQL and EF need to step forward in terms of giving power to developers to perform object-oriented queries against database. Many developers find it difficult to work with Linq to SQL because it is a world-away from T-SQL, also EF does not provide a way to query individual fields from database which has huge performance drain. I think the SF team needs to check out Salesforce SOQL. It puts a lot of power in developer's hand and yet it is very similar to T-SQL.

This idea is lacking enough information to understand it or to asses its value. SOQL is interesting, mostly because of its simplicity, but it isn’t clear what features are lacking in EF or or in LINQ itself. E.g. I don’t understand what is not possible about querying individual fields in EF.