How to create Web Api Application with Sql Db connection using entity framework

Hello Friends,

         Now I am going to describe this article  how to create Web Api Application with Sql Db connection using entity framework.Before go to this concept ,we should know basic approach about entity framework and which approach has used in this application,Next Session i'll describe briefly about entity framework,Please go through this article .I hope it will be  very enjoy full for all of my friends.

Entity Framework : It is a open source ORM(Object Relational Mapping) framework for dot net application by Microsoft.This framework is very user friendly and helpful for dot net developer,Basically It has three approaches

1.Model First:

                  In Model First approach after creation of entity model then the database will be create by the option of "Generate database from Model" in entity model design screen.

2.Code First:

                 In Code First Approach first we will create the class then the database will create based on that class.

3.Schema First or Database First:

                 In this approach we will create the entity framework means the ".edmx" file and class file etc based on the existing database.
In this application i am using  "Schema First or Database First" approach

Please the follow below steps to create web api application:

Create a Simple asp dot net core application in 10 Steps

Hello Friends,

         Now I am going to describe how to Create a Simple asp dot net core application in Ten Steps.Next Session will be discuss the web api application with db connection using entity framework .I hope it will be  helpful for all of my friends.

Step-1:Open Visual Studio ->Create New Project and select "Asp.net Core Web Application" ->Click on OK