{"id":89,"date":"2018-04-10T00:03:00","date_gmt":"2018-04-09T22:03:00","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/2018\/04\/10\/restful-web-services-tutorial-8-using-entity-framework-with-mvc-database-first\/"},"modified":"2020-08-22T08:55:55","modified_gmt":"2020-08-22T06:55:55","slug":"restful-web-services-tutorial-8-using-entity-framework-with-mvc-database-first","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/restful-web-services-tutorial-8-using-entity-framework-with-mvc-database-first\/","title":{"rendered":"RESTful Web Services Tutorial 8: Using Entity Framework With MVC – Database First"},"content":{"rendered":"

In this lesson we are going to use Entity Framework(EF) with MVC(Model-View-Controller) to carry out select, insert, update and delete operation. We would see the forms and tables generated easily for us, without writing codes.<\/p>\n

<\/div>\n

Believe me, this is would be the easiest lesson so far in this series! I personally could not believe it when I saw it work like magic!<\/p>\n

Let’s do this!<\/p>\n

<\/ins>
\nWe are going to cover the following:<\/b><\/p>\n

    \n
  1. Create an API Web Service using MVC<\/a><\/li>\n
  2. About the MVC Folders <\/a><\/li>\n
  3. Generate the Models<\/a><\/li>\n<\/ol>\n

     <\/p>\n

    1. Create an Web Application Using Web API Template.<\/h3>\n

    This is similar to the steps we followed in Tutorial 8 except that if you get to the dialog box in Figure 1, you make sure that Web API is selected
    \nAlso make sure that the boxes for Web API and MVC is selected as shown<\/p>\n

    \u00a0<\/a><\/div>\n
    Figure 1: MVC Web API<\/div>\n

     <\/p>\n

    After a few seconds,\u00a0 the solution is generated as shown in Figure 2<\/p>\n

    <\/a><\/div>\n
    Figure 2: Home Page of MVC Application<\/div>\n

     <\/p>\n

    2. Learn about the folder structure<\/h3>\n

    The folder structure for an MVC application always contains the folders: Model, View and Controller<\/p>\n

    Model<\/i>: This folder contains the classes for your entities – which corresponds to tables in your database.<\/p>\n

    View<\/i>: This Folder would contain subfolders which contains pages for each of entity for your application. For each of the table, there would be a folder. For each folder there would be five cshtml pages:<\/p>\n