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

EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship

I'm attempting to do the following:...public class class1 { public int Id {get;set;} [ForeignKey("Class2")] public int Class2Id {get;set;} public virtual Class2 Class2 {get;set;} } public class class2 { public int Id { get; set;} [Required] public virtual int Class1Id {get;set;} [Required] [ForeignKey("Class1Id"...

Solutions with one EF6 model (db first) and one code first

I have a solution that has multiple databases. We are using EF6....We have one Project that is EF6 (code first), and one project that is EF6 DB first....var arkleModelDbFist = new Arkle.DAL.EF.ArkleEntities(); var CustomerOld= new Arkle.DAL.EF.Customer(); arkleModelDbFist.Customers.Add(CustomerOld); // Errors on this line arkleModelDbFist.SaveChang...

Entity Framework Code First Fluent API configuration for one to one identifying relationship

I have the following class structure:...How to configure Fluent API to put identifying relationship in Cards table? ...I mean ...Cards Table PK: Id, CustomerId...Cards Table FK: CustomerId...I would like the previous Card be deleted when I assign a new one to Customer.Card property....So I defined my classes this way:...public class Customer { ...

One-to-One relationships in Entity Framework 7 Code First

How to configure One-to-One or ZeroOrOne-to-One relationships in Entity Framework 7 Code First using Data Annotations or Fluent Api?

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

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

Adding a second one-to-one relationship with the same table in entity framework

I am doing code-first entity framework design....I have a table, Account, which has a property, Supervisor:...public class Account { public int Id { get; set; } public Account Supervisor { get; set; } } ...This works beautifully....However, I wish to add an alternate supervisor to the class:...public class Account { public int Id { get; set; ...

One-way one-to-one relationship with EF Core

What I want to achieve, is have a model ...CommentsThread... that can be attached to any other model that needs comments, be it ...Chapter..., ...BlogPost..., ...UserProfile..., or what have you. Basically, the structure I need is...CommentsThread int ID Chapter int ID int Thread FK(CommentsThread.ID) BlogPost int ID int Thread FK(Comme...