If you are using .NET Core version 1.0.1, you might have
faced some issues to auto-generate database context and Model. There is one
more option available to generate database context using command prompt.
But you have to take care of adding supported/matched DLL reference
from Nuget/Nexus.
Go to “project.json” file and make sure you have added
following references
"dependencies": {
"Microsoft.NETCore.App": {
"version": "1.0.1",
"type": "platform"
},
"Microsoft.AspNetCore.Diagnostics": "1.0.0",
"Microsoft.AspNetCore.Server.IISIntegration": "1.0.0",
"Microsoft.AspNetCore.Server.Kestrel": "1.0.1",
"Microsoft.Extensions.Logging.Console": "1.0.0",
"Microsoft.Entityframeworkcore.Sqlserver": "1.0.0",
"Microsoft.EntityFrameworkCore.SqlServer.Design": "1.0.0",
"Microsoft.EntityFrameworkCore.Design": "1.0.0-preview2-final"
},
"tools": {
"Microsoft.EntityFrameworkCore.Tools": "1.0.0-preview2-final",
"Microsoft.AspNetCore.Server.IISIntegration.Tools": "1.0.0-preview2-final"
},
|
Now go to the folder where “project.json” file exist and
open command prompt.
- Generate database Model for selected table only
C:/Ritesh/EFScafoldingDemo:> dotnet ef dbcontext scaffold “Server={db server name},{port number};Database={db name};Trusted_Connection=True;” Microsoft.Entityframeworkcore.Sqlserver –t “Product”,”Order”
- Generate entire database Model
C:/Ritesh/EFScafoldingDemo:>
dotnet ef dbcontext scaffold “Server={db server name},{port
number};Database= db name};Trusted_Connection=True;” Microsoft.Entityframeworkcore.Sqlserver
There are multiple option available
to generate database model for .NET Core entity framework, you can see from
Microsoft
site for more detail
After above command executed successfully you can see, dbProductContext.db
, Product.cs, Order.cs files.