Before going further, we need to add EF so that our service can interact with the actual product database. Until now, we did not add any method to our repository that could interact with the database.
To add EF core support, we need to add EF's core sqlserver package (we are adding the sqlserrver package because we are using SQL Server as our DB server). Open the project.json file and add the following package under dependencies:
"Microsoft.EntityFrameworkCore.SqlServer": "1.1.0"
Otherwise, the same package can be added using NuGet Package Manager. Just open NuGet package and search for Microsoft.EntityFrameworkCore.SqlServer: