Simple Login Application using Sessions in ASP.NET MVC

Continuation Form : Creating your first MVC Project

Step 1: Add Entity Data Model
Go to Solution Explorer, Right Click on Project, Add, New Item, then select ADO.NET Entity Data Model.

Give it a meaningful model name and then click on Add.

 Select Generate from database and then click on Next.

 

Click on New Connection,

After clicking on New Connection, we have to provide the required information

Click on the "Test Connection" button to ensure the connection can be established.
Then click OK. 

Select radio button: Yes include the sensitive data in the connection string.

Choose your database objects, as in the following image.

 Click on Finish. At this point UserProfie entity will be created.