Entity Framework

Entity Framework :-  Entity Framework is a open source ORM framework for .Net applications.
 It offers automated mechanism for storing and accessing the data from database.

• It is a microsoft tool and it is developed as an Open source product.
• SQL command generation from LINQ to Entities.
• It allows update , insert and delete command generation.
• Creating data model from your existing database.
• Testability improvements.
• Code based Configuration.
• CRUD operation using SP(Stored Procedures).
• Database command logging.
• Database command interception.

Create Entity Data Model:-

1:- Open Solution Explorer > Add > New Item . In Shown Popup Select Ado Entity Model:

2:- You have shown four different option in image . Here we use EF designer  form database.

3:- In this step we create a new connection for fetch database table , views and stored procedures,

After create successful connection you can show the connection string , shown above image in right section.

4:- In this step you can show the all tables , views and SP . you can all tables , views and SP as your wish also if you want to change model namespace.

After selection you can click on finish and in folder successfully edmx added. Open databse diagram and show the all table and there dependencies.