Steps:
– Install EF:
Install-Package Microsoft.EntityFrameworkCore.SqlServer Install-Package Microsoft.EntityFrameworkCore.Tools –Pre Install-Package Microsoft.EntityFrameworkCore.Design Install-Package Microsoft.EntityFrameworkCore.SqlServer.Design
– Add to project.json
"tools": { "Microsoft.EntityFrameworkCore.Tools.DotNet": "1.0.0-preview3-final", "Microsoft.AspNetCore.Razor.Tools": "1.0.0-preview2-final", "Microsoft.AspNetCore.Server.IISIntegration.Tools": "1.0.0-preview2-final" },
– From “NuGet Package Manager” then “Package Manager Console”
Scaffold-DbContext "Server=;Database= ;user id= ;password= ;Trusted_Connection=True;MultipleActiveResultSets=true;Integrated Security=False" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
– Update appsettings.json to include the connection string..
"Data": { "DefaultConnection": { "ConnectionString": "Server=devsql01;Database=nasr_scratch;user id=dev;password=Automation15;Trusted_Connection=True;MultipleActiveResultSets=true;Integrated Security=False;" } },
– Add the DbContext to the Startup.cs using the connection string..
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { // Add framework services. services.AddMvc(); services.AddDbContext( o => o.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"))); }
Update the Context:
public class MyContext : DbContext { public MyContext(DbContextOptionsoptions) :base(options) { } }
– Create your controller. For Instance; BulkTagCreationController. You can now reference the context using DI.
[Route("api/configuration/[controller]")] public class BulkTagCreationController : Controller { public readonly nasr_scratchContext _context; public BulkTagCreationController(nasr_scratchContext context) { _context = context; }