Entity Framework 6 - Knowledge Base (KB)

Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API

I have two POCO classes...public class Order { int id; string code; int? quotationId; //it is foreign key public int Id{get;set;} public string Code{get;set;} public int? QuotationId{get;set;} Quotation quotation; public v...

EF Composite key fluent API

I am trying to map a composite key for an entity....public class Customer { public int CustomerId { get; set; } public virtual List<CustomerImage> CustomerImages { get; set; } } ...And its Map:...public class CustomerMap : EntityTypeConfiguration...

Duplicate navigation properties when using Entity Framework 6 and fluent api

I got two models with a relations....public class Customer { public Customer() { CustomerSites = new List<CustomerSite>(); } public IList<CustomerSite> CustomerSites { get; set; } } public class CustomerSite { public Gui...

Entity Framework map struct/complex type without model properties

I have a 'model ...struct...' which is internally a string, but is being used to somewhat similiar to a ...GUID.......public struct Token { private string _value; private Token(Guid uuid) { _value = Token.FromGuid(uuid); } publi...

Schema specified is not valid. Errors: The relationship was not loaded because the type is not available

I wish to reference the ...OrderAddress... model ...twice... in my ...Order... model; once as a ...ShippingAddress... and once as a ...BillingAdress.......On the other side, I want my ...OrderAddress... model to have a list of ...OrderAddresses.......Orde...

Entity Framework 6 NotMapped attributes

Is there a way using the fluentAPI within a DbContext to manually include ICollections that have been [NotMapped] in the model? I know how to manually ignore properties using the fluentAPI ...modelBuilder.Entity<MyEntity>().Ignore(e => e.MyChildCollection...

Entity Framework - get related items without explicit reference using Fluent API configurations

Let's say I have database table A with optional property X. I have table B with a composite key (Y, X). These two tables are not explicitly related in any way....e.g....create table A ( Id uniqueidentifier not null, X uniqueidentifier null ) crea...

How can I set the foreign key name using the Fluent API with Code First Migrations?

I'm trying to set the foreign key name (not the foreign key column) using Code First Migrations on EF6.4....I know that it can be set by updating the generated migration code, like so:....ForeignKey("Documents", Function(t) t.DocumentId, cascadeDelete:=Tr...