Nullable Foreign Key Error in Entity Framework

entity-framework nullable

Question

I have a Website table that has a foreign key to a Client table. A Website isn't always going to have an associated Client but when I save a Website without specifying a client then it errors out, as Website.ClientID is an int32 (not nullable) and is set to 0.

I tried changing the relationship in my EF diagram to be an * next to Website and a 0..1 next to Client but then it gives an error saying that it can't do 0..1 for ClientID because it's not nullable. I then changed Website.ClientID to be nullable, however now it gives this error:

TothSolutions.msl(69,10) : error 3031: Problem in mapping fragments starting 
at line 69:Non-nullable column Website.ClientID in table Website is mapped to 
a nullable entity property.

How do I set up a foreign key relationship where the dependent object is nullable?

1
0
4/24/2013 1:52:52 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I forgot to take the not null constraint off the column in the database.

0
4/24/2013 1:54:26 PM

Popular Answer

I got this problem as well but fixed it by removing the table from my model and adding it again.

John

Related Questions

Framework for Entities A nullable entity property is mapped to a non-nullable column.

I am getting this nullable column error message in Entity Framework 4.1 - when the column is not actually nullable: ...Non-nullable column MyView.RunningTotal in table TransactionListView is mapped to a nullable entity property. ...But you can see from the screenshots below that the column is not nullable and that the entity property is not nullab...
c# entity-framework mapping nullable poco
asked by JK.

Foreign Key mapping to composite keys in entity framework

You have 2 options here....Use attributes as you have eg:...[ForeignKey("PatientContact"), Column(Order = 0)] public int Person_ID{ get; set; } [ForeignKey("PatientContact"), Column(Order = 1)] public int Patient_ID{ get; set; } public virtual PatientContact PatientContact { get; set; } ...Use the model builder (fluent api)...modelBuilder.Entity<Ev...
c# ef-code-first entity-framework
asked by Not loved

Entity Framework Foreign Key as Primary Key Code First

I thought I'd give this a shot and it worked nicely....public class FooState { [Required] [Key] [ForeignKey("Foo")] public int FooStateId { get; set; } [Required] public int State { get; set; } public Foo Foo { get; set; } }
c# ef-code-first entity-framework
asked by Neil

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

You can just include foreign key properties in addition to the navigation properties and then set them using the ids you have. If you do this will not have to go to the database to get related entities for just a sake of setting the relationship.
entity-framework entity-framework-6 insert
asked by Pawel

Code Generation : Add primary key / foreign key to Entity Framework

I ran into the same problem. The template file you are looking for appears in the Solution Explorer (in VS2013) as:...YourDataModelName.tt...You can modify it to add the ...[Key]... attributes to the generated code by following:...Finding a property is Primary Key in POCO Template t4 generator
c# code-generation entity-framework-6
asked by srg39

Entity Framework 6.1.3 Mapping Foreign key to non primary key

This is now possible in Entity Framework 7 (that is, EF Core 1.0)....From .Net Entity Framework User Voice ...Unique Constraint (i.e. Candidate Key) Support...:...Support for this feature was added in EF Core 1.0 and we don’t have plans to add it in the EF6 codebase.
c# entity-framework-6
asked by ErikE

Entity Framework Error Deleting Entity with Foreign Key Relationship

Since you already have the question ids to delete, something like this should work:...// assuming db is your DbContext var questions = db.QuizWithQuestions .Where(q => deletedQuestions.Contains(q.Id)) .Include(q => q.QuizUserAnswers); // assuming this is your DbSet db.QuizWithQuestions.RemoveRange(questions); d...
entity-framework entity-framework-6 poco
asked by jjj

Entity Framework code-first set foreign key with primary key in same table

This answer for your requirement of 2 foreign keys ...public class WdUser : SysDomainModelBase, IWdUser { //This is your primary key of WDUser public int UserID{get;set;} //This is for your 1st foreign key mapping public virtual WDUser WDUser{get;set;} public virtual ICollection<WDUser> WDUserList{get;set;} public int fk1{get;set;} //This is for y...
asp.net c# entity-framework-6
asked by Nithila Shanmugananthan

Entity Framework: one or more of the foreign-key properties is non-nullable

You have to analyze your object to solve this problem....Here some simple code to explain your ...Exception...:...static void Main() { using (MyDbContext ctx = new MyDbContext()) { // Build a new object MyClass o = new MyClass() { Id = 1, ChildObject = null }; // Add it to your Context (It's not in the DB yet!) ...
c# entity-framework entity-framework-6 exception sql-server
asked by kara

Using nullable for Foreign Key in Entity Framawork

Adding a dummy record is not right, the correct approach here is to use an ...int?... for the foreign key relation, ...see here...:...If the data type of ...GradeId... is nullable integer, then it will create a null foreign key....public class Student { public int Id { get; set; } public string Name { get; set; } public int? GradeId...
asp.net-mvc c# entity-framework entity-framework-6 sql-server
asked by Hooman Bahreini

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow