AspNet Core MVC + Class Library (.Net Standard) with Entity Framework

Question

I'm using Visual Studio 2017 and I'm building my first Asp.Net Core MVC site and I want to create also a Class Library (.Net Standard) as My Data Access Layer. In this last library I want to use Entity Framework to connect to my database. I tried to use Entity Framework Core but I don't know how to create an EDMX file to map my database. Is there another way to do this with Entity Framework Core?

Thanks in advance for your help :)

Also, If your web app is going to be single paged then I strongly recommend checking out AngularJS too, the models for development are quite different, but it is super powerful. Google is your best friend with MVC, but its about knowing where to look. — Travis Tubbs

Travis Tubbs Travis Tubbs · Accepted Answer · 2017-07-25T14:46:44

Entity framework has the power to the point that you may consider not explicitly mapping any of your database at first. Entity framework does most of the mapping for you.

I was in the same boat as you about a year ago and I got a lot of help from this example. It is the Contoso University Example: https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

AspNet Core MVC + Class Library (.Net Standard) with Entity Framework

1 Answers