today I want to show you how to get started with ASP.NET 5 and Entity Framework 6.
If you start with the new templates for ASP.NET 5 you will notice in a short time that examples are going the EF 7 way. But if you want to stay at Entity Framework 6 as long as 7 is not in a final release or just to move from an older version step by step you can follow this instructions here. In this blog post I want to show you how to include a database with a connectionstring saved in a json file with the new ASP.NET Core.
Note: At the time of this post ASP.NET was at RC1 status. There might be changes until its completely an final released. However: If you want to dive into new functionalities: Keep reading.
Get started with ASP.NET Core and Entity Framework 6 :
First of all you need to start an new project with the new ASP.NET like this:
This will create you a new nearly empty solution following the new standards with all configs in *.json files and so on.
This example is only made fot the full version of the .net-Framework. So the core version will not be supported with this example.
The first step we a re going to do is adding the dependency of the Entity Framework to our solution via the project.json file. For this only put the line
at the end of you dependencies section like this:
This will get Visual Studio 2015 to update your dependencies including the Entity Framework.
Now you can create a new class named like your Context. in this case this will be “MyEf6EntityFrameworkContext”.
Be sure to use the “base”-functionality, because we will need it when passing the connectionstring to the context reading it out of the *.json file.
Back in our Startup.cs-File we are including a file called “appsettings.json”. Lets go and add our Connectionstring to this file:
This should look quite familiar because of the connectionstring you knew from the web.config in the previous asp.net-versions.
What we did so far:
At this point we added the connectionstring to the config file we will consume in the startup.cs and we created a databasecontext like we know it which will provide us any data in the future.
Next thing we have to do is getting the config and our databasecontext married :-)
This can be done putting a single line in our “Startup.cs”-File.
in the method “ConfigureServices” in your Startup.cs.
This line will read the configuration and get the connection-string out of it and use it for establishing the connection. pay attention to the scoped adding. This is because the context should be generated for every single request. You can grab an overview of all lifestyles here, even it’s a bit outdated: Dependency Injection in ASP.NET vNext
You can now go ahead and install my Unit of Work via nuget and create a repository like this:
With a model like this (for example):
Meanwhile I also added Automappers and a ViewModel to map between those two:
Now we have to bring it to the build in DI in ASP.NET:
and the automapping:
In the end you only have to build up a controller which gives and takes the values as your API:
Thats it. If you now going to use the DatabaseContext it will create the database for you with the new ASP.NET 5 RC1.
You can now go ahead and add an item with e.g. postman: