Entity Framework 6 - Knowledge Base (KB)

Code-First Reference one-to-many

I have the following two tables:...LOCALIZATION...Id int Text string ...DINER...Id int Name string Description string Name_LocalizationID int Description_LocationID ...

Difference between .WithMany() and .WithOptional()?

Below are two similar fluent API configurations:...WithMany()...modelBuilder.Entity<Country>() .HasRequired(cou => cou.Currency) .WithMany() .WillCascadeOnDelete(false); ...WithOptional()...modelBuilder.Entity<Country>...

EF Code First 4.1 - How to configure one to many relationship with default

I have a Customer entity which references a collection of Addresses. The complication here is that I want to be able to identify a particular address as the default address....If possible I would like to hold the FK of the default address in the Customer...

How do I map a char property using the Entity Framework 4.1 "code only" fluent API?

I have an object that has a char property:...public class Product { public char Code { get; set; } } ...Entity Framework doesn't seem to be able to map chars (this field is missing from the database when I create the database s...

Specifying Foreign Key Entity Framework Code First, Fluent Api

I have a question about defining Foreign Key in EF Code First Fluent API. I have a scenario like this:...Two class Person and Car. In my scenario Car can have assign Person or not (one or zero relationship). Code:... public class Person { public i...

EF Code First prevent property mapping with Fluent API

I have a class ...Product... and a complex type ...AddressDetails...public class Product { public Guid Id { get; set; } public AddressDetails AddressDetails { get; set; } } public class AddressDetails { public string City { get; set; } p...

Mapping 2 tables to single entity in Entity Framework

I hope you can help me....I have 2 tables in the db: Bill and BillItem. These tables are configured with one to one relation in the db where bill is the principle table while BillItem is the dependent one...The structure of table Bill :...Int BillId (PK) ...

How to store double[] array to database with Entity Framework Code-First approach

How can I store an array of doubles to database using Entity Framework Code-First with no impact on the existing code and architecture design?...I've looked at Data Annotation and Fluent API, I've also considered converting the double array to a string of...

The DELETE statement conflicted with the SAME TABLE REFERENCE constraint with Entity Framework

I have a table with a self reference where the ParentId is an FK to the ID (PK).... Using EF (code-first), I've set up my relationship as follows: ...this.HasOptional(t => t.ParentValue) .WithMany(t => t.ChildValues) .HasForeignKey(t => t.ParentId...

EF Code First: Multiplicity constraint violation

HELP! - I am receiving the following error on my navigational model ...ArticleType...:...A relationship multiplicity constraint violation occurred...Here is the existing database schema:...Here is my code:...public class Article { public int ID { get;...

EF6.0 "The relationship could not be changed because one or more of the foreign-key properties is non-nullable"

If I try to delete a "child" row I always get an exception. Here is a snipset:...using (var context = new CompanyContext()) { ItemType itemType = context.ItemTypes.FirstOrDefault(i => i.Name == "ServerType"); ItemTypeItem itemTypeItem = itemType.I...

Unable to determine the principal end of an association - Entity Framework Model First

I have created Entity Data Model in Visual Studio. Now I have file with SQL queries and C# classes generated from Model....Question:...Classes are generated without annotations or code behind (Fluent API). Is it OK? I tried to run my application but excep...

Creating Unique Index with Entity Framework 6.1 fluent API

I have a column "Name" that must be unqiue. No foreign key or anything like that....EF 6.1 finally supports creating such indexes via Annotations. That has been discussed already on SO. But it seems it can only be done via annotations in the classes. How ...

What is the proper usage of HasColumnType and Database generated

I'm migrating a substantial EF model of ~80 entites from EF4 to EF6, and I'm also changing it from a Designer EDMX-generated database, to a Code First database....Right now I'm configuring the entity relationships using EF fluent-api, and I'm not certain ...