The ADO.NET Entity Framework and Visual Studio, make it possible to create a data entity model, based on a database, in a few simple steps.
Step 1: In the solution explorer of Visual Studio, right click on a project, and select add new item from the menu. This will present the add new item dialogue box. Click on data templates, and select the ADO.NET Entity Data Model, as illustrated below.
Step 2: Next, the Entity Data Model Wizard launches, and asks you to select what the model should contain. Take the option to generate from database and click next.
Step 3: The Entity Data Model Wizard will ask you to configure the database connection.
Step 4: Select the tables from the database to be included in the data entity model. Click finish, and the data entity model, with supporting diagram and source code files, are automatically generated and added to the project solution.