The Microsoft Entity Framework is an Object Relational Mapping (O/RM) tool that enables you to generate a data access layer from a database automatically. The Entity Framework enables you to avoid the tedious work of building your data access classes by hand.
** Alternatives to Entity Framework – Microsoft LINQ to SQL, NHibernate, or SubSonic
Sample Project – MVC with Entity Framework
|After Creation MVC project from the Project Template- Create Entity Data Model-from an Exiting Database in SQL- Click Add New Item from Model- Select ADO.NET Entity Data Model.|
|Select the Entity and Verify the Entity Type Name and See if its made Plural, you can change it to Singular|
|Go to the Controller- Verify the Namespaces, Create a Constructor to Initialize The Entity, In the the Corresponding Action,Fetch the Data using Entity and Assign it to Model|