EF Core one-to-many without Foreign Key (FK)

Entity Framework - How to Insert to table with foreign keys without retrieving foreign table rows first

I'm having a hard time finding the exact answer to this question, so my apologies if this is redundant....So I have 3 tables defined such that:...Person :PersonId, FirstName, LastName...Company: CompanyId, CompanyName...Order: OrderId, PersonId, CompanyId...On the Order table, there is a foreign key defined on the PersonId and CompanyId columns, th...

EF 6 - Code first invalid one-to-one foreign key relationship

DESIGN BACKGROUND...:...I'm trying to create code-first EF6 mappings for the following database structure:...The database design is as follow: Instead of having "CustomerID" as foreign key on all related entities (Employment, expenses, income, etc...), we have a CustomerRelationship table, which will contain the CustomerID, and then a "RelatedID" c...

Mapping foreign key to non primary surrogate key column in EF code first

public class A { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Aid { get; set; } public virtual ICollection<B> B { get; set; } } public class B { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Bid { get; set; } [Key] [Column(Order = 0)] ...

EF Core Composite Key, one foreign, one auto incrementing

But, one question I still have is how to make OnModelCreating identity PlayerScoreId as a foreign key - without having navigation properties........You can use the ...HasOne... / ...WithMany... (or ...HasMany... / ...WithOne...) methods w/o specifying the navigation property, combined with ...HasForeignKey... as usual:...modelBuilder.Entity<PlayerS...

EF Core: how to share foreign key properties between several zero/one-to-many relationships

Try this:...public class Commission { public int Id { get; set; } public string Description { get; set; } public double Rate { get; set; } public Party Party { get; set; } // <-- "parent" party link here } public class Agency : Party { public string AgencyCode { get; set; } [InverseProperty("Party")] // <-- link this coll...

EF Core 1.1 generating unique index on FK one-to-one

I'm using EF Core 1.1 and created my one-to-one relationships, an example:...EntityTypeBuilder<Account> .HasOne(a => a.Customer) .WithOne(a => a.Account) .HasForeignKey<Account>(a => a.CustomerId) ...Now using Add-Migration on my DbContext it generates the following:...migrationBuilder.CreateIndex( name: "IX_Accounts_CustomerId", tab...

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

2 Foreign Keys as Primary Key using EF Core 2.0 Code First

I have two tables: ...Comment... and ...Like.......public class Comment { CommentID { get; set; } .... } public class Like { CommentID { get; set; } UserID { get; set; } } ...Using entity framework core 2.0 code first, I want to define my "Like" model as only having the two fields which reference other primary keys (as foreign keys) but al...

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

Load related data without foreign key constraint in ef-core-2.1

I want to load related entities data ...Parent... by using Eager Loading O/RM pattern. But I can't specify a foregin key constraint on ...ParentId... because it creates a cycle which is not allowed. Currently, I'm using an inner join to load Parent data explicitly....Here is my Domain Model that I'm using....[Table("Category")] public class Categor...