Does EF Core 3.1 support DB First approach?

asp.net-core asp.net-mvc entity-framework entity-framework-core porting

Question

We are porting an ASP.NET MVC 4.x application to ASP.NET Core 3.1. The current application is using EF 6.x DB first approach. As a part of this migration we are going to use EF Core 3.1 as an alternative to the current EF 6.x. So the question is:

Does EF Core 3.1 support DB First approach?

If not, what are the options? Are we left with only code first approach?

Appreciate your helps.

1
2
1/23/2020 9:56:36 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Yes. It supports DB First Approach since .NET Core 1.0 until now. You need to download 4 from nugets

1) EntityFrameworkCore

2) EntityFrameworkCore.Design

3) EntityFrameworkCore.Tools

4) EntityFrameworkCore.SqlServer

Open Tools > NuGet Package Manager > Package Manager Console. And enter this below in console.

Scaffold-DbContext "Server=yourserveraddress;Database=yourdatabase;user id=youruser;password=yourpassword;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Context "YourOwnContext"

Saw your comment about "Scaffold-DbContext only creates a Code First model". No, Scaffold-DbContext is Database-First approach.

"Creating entity & context classes for an existing database is called Database-First approach."

4
1/20/2020 1:19:52 AM

Related Questions

Seeding DB made by Code First EF Core DB

I am wondering what is the best way to generate required data right after EF Core has made the database....I see that people make classes in the C# code to do it but how about if you got alot of data? For me I got to import all States from the US in my system. ...I would think it would be better to run some sort of sql script to do this, but I gues...
c# entity-framework-core
asked by chobo2

EF Db First approach - dealing with tables without PK's

1) Like this. Middleman tables that decompose a M:M relationship into two 1:M should have the two foreign key columns as their PK. It's a rookie error to make such tables have a third PK column...2) Because that's how it looks up related data when you ask for it (...employee.Company.Name... might cause company data to be loaded for that employee, s...
.net-core c# entity-framework-core
asked by Caius Jard

Entity framework Core - Ambiguity over choosing Code First Approach and Database First Approach

We can't map them yet, but we can call them:...Public Class Sample Private Sub SpTest() Dim oContext As SchoolContext Dim oStudents As List(Of Student) oContext = New SchoolContext oStudents = oContext.Students.FromSql("GetStudents 'Bill'").ToList End Sub End Class ...There are some limitations:...The Stored Procedure must retu...
ef-code-first ef-database-first entity-framework-core
asked by InteXX

What is the difference between EF Core Database-First and EF Core Code-First approaches?

Database-First...DB-First is that you reverse engineer an existing database to create an Entity Framework model.Instead of designing the EDMX manually and generating the SQL script to create the Database, we build the latter and then generate the former using the Entity Framework Designer tool....Code-First...Code-First uses migrations to create th...
asp.net-core ef-code-first ef-database-first entity-framework-core
asked by Xing Zou

Dotnet Core 3.1 - Updating to 3.1 and setting default values using "HasDefaultValue" doesnt seem to exist

Have you added that ...https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.Relational/... package in your project for the 3.1 core?...I suggest that you install and/or remove/install the package and see how this works....Nothing has changed in EF 3.1 as you can see in the changelog ...here...To this end we have fixed over 150 issues for th...
c# entity-framework-core
asked by Athanasios Kataras

Entity Framework Core 3.1 code first unique constraint not working

Well question is pretty clear. Here is my ...OnModelCreating... method in the ...dbContext... class:...modelBuilder.Entity<States>(entity => { entity.ToTable("States"); modelBuilder.Entity<States>() .HasIndex(p => new { p.State }) .HasFilter("[State] IS NOT NULL") ...
code-first entity-framework-core unique-constraint
asked by Sanjay Kumar

Defining the one to many relationship in OnModelCreating using Entity Framework Core 3.1

You should have have something like this (other properties are omitted):...class Person { [Key] public int Id { get; set; } public List<PersonNote> PersonNotes { get; set; } } class PersonNote { [Key] public int Id { get; set; } public int PersonId { get; set; } } class StackOverflow : DbContext { public DbSet<Person> ...
entity-framework entity-framework-core
asked by JohnyL

EF core 2.2 to EF core 3.1

when I used to use EF 2.2 it rans this code without problems:...var resource = locResRepo.GetWhere(i => i.ForApplication.ToLower() == applicationName.ToLower()) .Where(resourcesConditionExpression) .Select(item => new ResourceKeyObject { Id = item.Id, ResourceKey = item.ResourceKey...
c# ef-core-3.1 entity-framework entity-framework-core
asked by Qhori

Migrate .NET Core 2.2 to .NET Core 3.1 and keep referencing EF Core 2

It is possible to reference EF Core 2.0 from .NET Core 3.1 App?...Yes, totally. Doing the same - and then moving off to Ef 6.4 as it looks as the breaking changes are just not bearable. Spending days trying to get basics working....Isn't there some magic compatibility switch in .NET Core like Microsoft from time to time provides?...No. Breaking ...
.net-core .net-core-3.1 c# entity-framework-core
asked by TomTom

Dotnet Core 3.1, EF1001: internal ef core api usage

The warnings from these analyzers can be really confusing. If I understand this correctly, the issue is not what it seems....The message with the gray warning icon inside the analyzer is normal and indicates what the analyzer is checking. See the ...Analyzers in Solution Explorer documentation... for an explanation....If you are experiencing yellow...
.net-core entity-framework-core
asked by Rafiki

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow