Entity Framework With ADO.NET Entity Data Model

In the above image, we can see multiple model options but here, we choose EF Designer from the database model because we have available student records in our database.

Now, press the Next button and open the data connection wizard dialog box as shown in the below image.

In the above image, we can see the New Connection button. Here, create a new data connection string for data access from the database to the application, as shown in the below image.

You can see the connection properties dialog box in the above image. Also here, you can see the ASO.NET data model provides two types of connection and we can use it as per our requirement. Here, I am using SQL Server authentication connection properties and selecting database name and test connection. Now, press the OK button. Now, you can see the created connection string in the above image. Here, check the checkbox for the created connection string and save it into the application's web.config file. Then, press Next and open one more dialog box for Database Object and Setting.

In the above image, we can see the created database object list. Here, you can select the data table. I am selecting only one student table in all available tables and giving the Model Namespace as shown in the above image.

Now, you can see created StudentModel.edmx in project solution explorer.

In this created model, you can see the Model class and diagram. Also, you can see a student class from our database student table with field properties. In this image, you can see the auto-generated student class. In this class, you can see ID, Name, Gender, MailID.

Now, add a web form to the project.

Project Name - Add - New Item - Web Form

Now, add a GridView control for displaying student records and Entity Data source from the Toolbox data tab and you must build a project solution.

Next, configure EntityDataSource.

Press the Next button and open the data selection dialog box.

Then, click the Finish button for configuring the Entity Data Source process.

After building the solution, open the web form on the browser for checking student information.

Here, you can see student information from the data table as per our result from the database using a Database Schema Model in Entity Framework.

In this article, you saw how to use the Database Schema model and auto-create related student class and context class for a data connection.

I hope you liked this article. In the next article, we will see database operations like insert, delete, and edit/update using Entity Framework.