EF Core 2: Database first with many-to-many (linking table)

asp.net-core ef-core-2.0 ef-database-first entity-framework-core

Question

I have many-to-many relationship between Projects and Models in my database

Relationship diagram

I am using this command to generate the .cs models:

Scaffold-DbContext "my connection string here" Microsoft.EntityFrameworkCore.SqlServer -OutputDir EFModels -Force -Context EFEntities -Tables Projects, Projects_Models, Models

In EF6, this would create Project.Models and Model.Projects properties, without mapping the Projects_Models table into its own class.

But in this case (EF Core), it created a ProjectsModel class, and Project.ProjectsModels and Model.ProjectsModels properties instead.

How can you make it behave like it was in EF6?

1
1
3/23/2018 12:04:49 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

It is not currently possible to do this in EF Core as that feature has not yet been added. From the docs:

Many-to-many relationships without an entity class to represent the join table are not yet supported. However, you can represent a many-to-many relationship by including an entity class for the join table and mapping two separate one-to-many relationships.

3
3/23/2018 12:52:41 AM

Related Questions

How can I add tables in EF Core/database first in the package manager console?

I'm using EF Core and was able to scaffold the initial database and table:...Scaffold-DbContext "connection-string" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Tables TestTable...But I can't seem to find out how to add tables after the initial scaffold.
ef-core-2.0 entity-framework-core
asked by ernest

Entity Framework Core Database First - Multiple Foreign keys to one table

Background Information...I am currently working with EF Core using a database first implementation....Current tables...Fizz { [Id] INT [Category] varchar [Value] varchar } Buzz { [Id] UniqueIdentifier [TypeId1] INT [TypeId2] INT CONSTRAINT [FK_Buzz_Fizz_1] FOREIGN KEY ([TypeId1] REFERENCES [Fizz][Id]) CONSTRAINT [F...
asp.net-core-2.0 c# ef-database-first entity-framework-core
asked by Leustherin

EF Core delete one-to-one relation on same table

A model have optional relation to itself...public class Item { public Guid Id { get; set; } public string Description { get; set; } public Guid StockId { get; set; } // optionally reference to another item from different stock public Guid? OptionalItemId { get; set; } public virtual Item OptionalItem { get; set; } } ...
.net-core c# ef-core-2.1 entity-framework-core sql-server
asked by Basin

one to one multiple foreign key from same table EF Core

Stuck on write code for table relation below :...public class PersonModel { public int ID { get; set; } public string Name{ get; set; } public string Address{ get; set; } public DateTime? DateofBirth{ get; set; } public GenderEnum Gender{ get; set; } public PersonDetailModel PersonDetail { get; set; } public PersonDetai...
asp.net-core entity-framework entity-framework-core
asked by Pandu Wijaya

scaffolding (database first) EF Core table with no primary key

I am using EF core 2.0 and using scaffolding reverse engineering database first to generate models. ...some of tables does not have any primary key and EF Unable to generate entity type for table. ...Any advice how can I do this other then adding manually.
entity-framework-core
asked by itmannz

ef core - how to copy tables from one schema to other with many-to-many relationship?

I have tables and mappings in my master schema, and I need to recreate them when I create another schema. I don't know what is the best approach, but now I do it this way:... var permissions = context.Permissions.ToList();//master context var roles = context.TenantRoles.ToList(); var permRoles = context.RolePermi...
asp.net-core c# ef-code-first entity-framework-core
asked by Jamil

EF Core One to One relationship on many tables allows duplicate entries

I am using EF Core and I tried to create a one-to-one relationship between three tables (Car, ElectricCar and PetrolCar)...public class Car { public int Id { get; set; } public string RegistrationNumber { get; set; } public ElectricCar Company { get; set; } public PetrolCar Trust { get; set; } } public class ElectricCar { publ...
entity-framework entity-framework-core sql-server
asked by pantonis

.net core C# use dynamic property name on EF Core Database first generated model class

I have a user details class...public partial class UserDetails { public int? Level { get; set; } public string Unit { get; set; } public string Bio { get; set; } public bool? Gender { get; set; } public int? Mobile { get; set; } public string Photo { get; set; } } ...I am writing an update met...
.net-core c# entity-framework-core
asked by Franva

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

I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?
asp.net-core ef-code-first ef-database-first entity-framework-core
asked by shade1337

How to connect to two different database in ef core database first

How to create two different database context to use two different database in EF core. i am using database first approach....Currently using the following line to use in my startup.cs...builderModel.Services.AddDbContext<DB1Context>(options => options.UseSqlServer(configuration.GetConnectionString("DB1Context"))); ...Thanks
c# entity-framework-core
asked by Mukil Deepthi

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