Why use the Entity Framework ?

Entity Framework vs. traditional ADO.Net

  The EF  system will automatically produce objects for you as well as track changes on those objects and simplify the process of updating the database. 
Entity Framework vs. LINQ to SQL
The  big difference between the Entity Framework and LINQ to SQL is that you will be able to use the EF against not only SQL Server and SQL CE but also Oracle, DB2, Informix, MySQL, Postgres, etc.

Next there is the fact that LINQ to SQL provides very limited mapping capabilities.  For the most part L2S classes must be one-to-one with the database .But EF is not limited and one to one and one to many relationships also.

Last one is apart from any other  ORM 's it is an Linq to entities a fastest projection queries like Firstordefault ,singleordefault like wise.And loading compatability like lazy and eager loading otherwise EF had  option selection of mappings  like Database first ,code first and model First . 

Comments