Nullable Foreign Key Error in Entity Framework

entity-framework nullable

Question

I have a table for my website that has a foreign key to a table for my clients. A Website may not always be connected with a Client, yet if I save a Website without naming a client, it fails with the error "Website." ClientID is a nullable int32 with the value 0.

I made an attempt to convert the connection in my EF diagram to an* next to Client and a 0..1 next to Website, however an error is then shown stating that ClientID cannot be nullable and hence cannot be set to 0..1. When I updated Website.ClientID to be nullable, the following problem appeared:

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 create a foreign key connection with a nullable dependant object?

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I neglected to bring thenot null constraint off the database column.

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

Popular Answer

I had the same issue, but I was able to resolve it by deleting the table from my model and bringing it back in.

John

Related Questions

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

Entity Framework 4.1 is giving me this nullable column error notice even though the column is not truly nullable:...Non-nullable column MyView.RunningTotal in table TransactionListView is mapped to a nullable entity property. ...However, as you can see from the screenshots below, neither the entity property nor the column are nullable. So why is t...
c# entity-framework mapping nullable poco
asked by JK.

Foreign Key mapping to composite keys in entity framework

Here, you have two choices....Use the traits you have, such as:...[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; } ...Utilize the model creator (fluent api)...modelBuilder...
c# ef-code-first entity-framework
asked by Not loved

Entity Framework Foreign Key as Primary Key Code First

I decided to try this, and it turned out to work well....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

Foreign key properties can simply be added to the navigation properties and set using the existing ids. By doing this, you will avoid having to search the database for related items only to set the relationship.
entity-framework entity-framework-6 insert
asked by Pawel

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

I experienced the same issue. The solution explorer (in Visual Studio 2013) displays the template file you're looking for as:...YourDataModelName.tt...You can change it to include the...[Key]... the following characteristics to the created code:...The POCO Template T4 Generator's Primary Key is locating a property.
c# code-generation entity-framework-6
asked by srg39

Entity Framework 6.1.3 Mapping Foreign key to non primary key

Entity Framework 7 now makes this feasible (that is, EF Core 1.0)....From ...Unique Restrictions (i.e. Candidate Key) Support... of the.Net Entity Framework User Voice:...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

Something like this ought to function since you already have the question ids to delete:...// 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...
entity-framework entity-framework-6 poco
asked by jjj

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

This response relates to your request for two 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 ...
asp.net c# entity-framework-6
asked by Nithila Shanmugananthan

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

To resolve this issue, you must examine your object....Here is some basic code to describe 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

ZZZ_tmp
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