.NET Core 1.0.1 Entity Framework – Scaffolding

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.

1. 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”

1. 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.

.NET Core or .NET Framework, What is right for your application?

.NET Framework and .NET Core are two choices for building .NET server-side applications. Both share a lot of the same .NET platform components and you can share code across the two. However, there are fundamental differences between the two and based on what you want to accomplish, your requirement your choice will depend. 

You should use .NET Core for your server application when:

• You have cross-platform needs.
• You are targeting microservices.
• You are using Docker containers.
• You need high performance and scalable systems.
• You need side by side of .NET versions by application.

You should use .NET Framework for your server application when:

• Your application currently uses .NET Framework (recommendation is to extend instead of migrating)
• You need to use third-party .NET libraries or NuGet packages not available for .NET Core.
• You need to use .NET technologies that are not available for .NET Core.
• You need to use a platform that doesn’t support .NET Core.

Ref: https://docs.microsoft.com/en-us/dotnet/standard/choosing-core-framework-server