Entity Framework Core and One-to-One Relation: Duplicate entry

Entity Framework core one to one relationship generate one to many in SQL Server

For one-to-one relationship in Entity Framework core (rc1 or rc2) based on this tutorial ...http://ef.readthedocs.io/en/latest/modeling/relationships.html#one-to-one..., I use this code:...public class MyContext : DbContext { public DbSet<Blog> Blogs { get; set; } public DbSet<BlogImage> BlogImages { get; set; } protected override void...

Two one-to-one relations to the same table on Entity Framework Core

I would like to map something like this:...public class FooPair { public int Id { get; set; } public Foo Foo1 { get; set; } public Foo Foo2 { get; set; } } public class Foo { public int Id { get; set; } public FooPair Parent { get; set; } } ...And my DbContext:...public class FooContext : DbContext { public DbSet<Foo> Foos ...

Configuring one-to-many and one-to-one relationship in Entity Framework Core

I'm quite new to Entity Framework and am picking it up with the Core version. I'm trying to understand how to customise model relationships....My basic model is that I have a Company entity, and a Contact entity. A Company can have many Contacts. A company can a KeyContact, which must be one of the associated contacts, but is not required....Thus t...

Entity Framework Core fluent api One-To-Many and One-To-One produces duplicate foreign key

I'm changing my ASP.NET MVC project to ASP.NET Core MVC with Entity Framework Core and Fluent API. When I try to configure a one-to-one and one-to-many relationship, it generates duplicate foreign key columns in the dependent table. ...For example: I have this in my context's ...OnModelCreating... method:...builder.Entity<Session>() .HasKey...

One-to-one and one-to-many on the same entity in Entity Framework

I tried different ways to map an entity as ...one-to-one... and ...one-to-many... at the same time, but I had no luck....I provided my models here:...public class Office { public virtual Person Manager {get; set;} public virtual List<Person> People {get; set;} } public class Person { public virtual Office Office{get;set;} } ...Could an...

One-to-one relation + on-to-many relation using same entity

I'm trying to create a customer entity that has multiple contact persons, as well as one primary contact person, but I can't seem to add the migration, as I'm getting the following error:...Unable to determine the relationship represented by navigation property 'ContactPerson.Customer' of type 'Customer'. Either manually configure the relationship,...

Entity Framework Core 2 one to one relationship "on one table"

I have an entity that have a one to one relationship with itself:...public class Link { public long Id { get; set; } public long OtherLinkId { get; set; } public Link OtherLink { get; set; } } ...How can I define this relationship with fluent API?...My solution:...modelBuilder.Entity<Link>() .HasOne(x => x.OtherLink) ...

Entity Framework Core zero-or-one to zero-or-one relation

Given these classes:...public class A { public int Id {get; set;} public int? BId {get; set;} public B B {get; set;} } public class B { public int Id {get; set;} public int? AId {get; set;} public A A {get; set;} } ...Then with Fluent API... modelBuilder.Entity<A>() .HasOne(a => a.B) .WithOn...

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

Can't map model with a couple of one to one relations with Entity Framework Core

I'm developing my first API with ASP.NET Core, and using Entity Framework Core to model my data. I can't map 2 nested class objects within the parent one....I've read about one to one, and one to many, but I get nothing when I look for several one to one mappings except some posts that didn't help me....I've seen these:...Entity Framework table wit...