Why Linq2Sql still more robust than Linq2E? RRS feed

  • Question

  • Just wondering if there is a reason why Linq2Sql is still more robust than linq to entities (Linq2E)?

    EF has been out for years and it still can't support some of the things that were easy in Linq2Sql.

    Easiest example is SqlMethods that let you convert types are missing in Linq to Entites (you can't convert from string to double for example in Linq2E even though such operations are available in T.Sql).  And using views in complex queries was a breeze in Linq2Sql but in Linq to Entities you get errors like: 

    'The specified type member 'SomeFieldFromAView' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.'

    I was under the impression that EF was the Microsoft recommended way to do ORM.  How is it that it is still behind Linq2Sql as far as usability?

    Wednesday, May 3, 2017 12:36 AM