.net Core From DataBase Layer To UI Layer
Here we have created the database.
OK,let's GO!
First:
You need create a new .net core to web application!
And create a .net core library
Then you need to see if EFcore, EFDesign, EFTools have been installed in the project configuration. If not, install the following commands through Nuget
Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 2.2.6 Install-Package Microsoft.EntityFrameworkCore.Design -Version 2.2.6 Install-Package Microsoft.EntityFrameworkCore.Tools -Version 2.2.6 //EFCore self-contained program .You Can Ctrl+/
With these
You can execute the following commands to automatically generate the entity model under the Model folder.
Scaffold-DbContext "Server=.;database=bb;uid=sa;pwd=xxx" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
Ok! Now!
You can see that the physical model is built.
Then.
We need Create conntion string to appsettings.json ,like this!
"ConnectionStrings": {
"BloggingDatabase": "Server=.;database=bb;uid=sa;pwd=xxx"
},Then we need DI To startup.cs（ConfigureServices）
var connection = Configuration.GetConnectionString("BloggingDatabase");
services.AddDbContextPool<INGoodsTrackerDBContext>(option =>
{
if (!option.IsConfigured)
{
option.UseSqlServer(connection);
}
});I'm sure you're curious why I don't use the AddDbContext method here , but the AddDbContextPool method.
You can refer to this article recommended by my colleague Venzent.
https://neelbhatt.com/2018/02/27/use-dbcontextpooling-to-improve-the-performance-net-core-2-1-feature/
I won't say much.
Let's continue.
private LocalDBContext _Context { get; set; }
public TestController(LocalDBContext Context)
{
_Context = Context;
}After these completions ,we can finish it.
Becareful: The OnConfiguring method in the generated content. CS needs to be removed when using dependency injection.
