The "X" property on "Y" could not be set to a 'null' value. You must set this property to a non-null value of type 'Int32'

entity-framework sql visual-studio-2010

Question

When I run my application and I click a specific button I get the error:

"The "X" property on "Y" could not be set to a 'null' value. You must set this property to a non-null value of type 'Int32'."

Cool so I go to my Entity project, go to Y table, find X column, right-click and go to X's properties and find that Nullable is set to False.

I verify in SQL that in Y table, X is set to allow nulls, and it is.

I then go back to my Entity project, set Nullable to True, save and build and I receive:

Error 3031: Problem in mapping fragments starting at line 4049:Non-nullable column "X" in table "Y" is mapped to a nullable entity property.

I've heard that deleting the table from the .edmx file and then re-adding it is a possibility but have never done that and don't understand the implications enough to feel comfortable in doing that.

I've heard that it could be in the view, could be in the stored procedure...

Also have heard that this is a bug.

Has anyone come across this and found an "across the board" fix or somewhat of a road map of sorts on where to look for this error?

Thanks!

1
27
11/16/2012 3:56:41 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

 "The "X" property on "Y" could not be set to a 'null' value. You must set this property to a non-null value of type 'Int32'."

In your EDMX, if you go under your Y table and click on X column, right-click, click on Properties, scroll down to Nullable and change from False to True.

If you get a "mapping fragment" error, you'll have to delete the table from the EDMX and re-add it, because in the Model Browser it stores the table properties and the only way to refresh that (that I know of) is to delete the table from the Model Browser under <database>.Store then retrieving it using Update Model from Database.. command.

29
11/16/2012 6:23:08 PM

Popular Answer

I just replace data type int to int32? 

public Int32 Field{ get; set; }

to

public Int32? Field{ get; set; }

and the problem is solved

Yasir Antaal

Related Questions

"non-null value of type 'DateTime'" in EF 4.1 Code First. Issue

Is this telling me that all rows in the date must have a date and not be null? What do I do if I dont want to set a date on specific row?...It looks like the DB you point at have null values for ...Date1.... If you do indeed not want to set a date for all rows, just make your ...Date1... property nullable:...public DateTime? Date1{get;set;} ....
asp.net-mvc asp.net-mvc-3 code-first ef-code-first entity-framework
asked by BrokenGlass

Because the materialized value is null, the cast to value type 'Int32' failed.

A linq-to-sql query isn't executed as code, but rather translated into SQL. Sometimes this is a "leaky abstraction" that yields unexpected behaviour. ...One such case is null handling, where there can be unexpected nulls in different places. ......DefaultIfEmpty(0).Sum(0)... can help in this (quite simple) case, where there might be no elements and...
.net c# entity-framework linq-to-entities
asked by Anders Abel

The cast to value type 'Double' failed because the materialized value is null

Best Solution...double cafeSales = db.InvoiceLines .Where(x => x.UserId == user.UserId && x.DateCharged >= dateStart && x.DateCharged <= dateEnd) .Sum(x => (double?)(x.Quantity * x.Price)) ?? 0;
c# entity-framework
asked by Jitendra Pancholi

Entity Framework will only set related entity property to "null" if I first get the property

As a workaround, the easiest way I've found to mitigate this issue is to have the setter call the getter ...before... setting the backing field to null, e.g....public class Foo { public int? Id { get; set; } private Bar _bar; public virtual Bar { get { return _bar; } set { var entityFrameworkH...
c# entity-framework entity-framework-6
asked by Nathan

Trying to set a non-null string to type 'System.Int32'

Just for anyone else having issues with this. Set a breakpoint in ...DatabaseContext... and make sure it's connecting to the correct database. Mine was being overwritten from a web.config file I forgot about.
c# ef-code-first ef-migrations entity-framework
asked by Alexander Forbes-Reed

Automapper not setting navigation property values from stored procedure

Your referring to what's called ...flattening.... But it's the other way around. AutoMapper can map ...Customer.Address.City... to a property ...Target.AddressCity..., but not the reverse. It would have to create an ...Address... object and only set its ...City... property, and then keep in mind that for the second mapping the same ...Address... sh...
automapper c# entity-framework entity-framework-6
asked by Gert Arnold

Error: The cast to value type 'System.Int32' failed because the materialized value is null

Modify it using ...DefaultIfEmpty()..., check ...here...Modified Query...var lastTransactionId = db.Transactions.Where(w => w.AccountId == accountInstance.Id && w.IsCancelled == false && w.TransactionTypeId == 2 && w.Date.Year >= 2015) .Select(t=>t.Id) .DefaultIfEmpty(-1)...
asp.net-mvc c# entity-framework linq
asked by Mrinal Kamboj

The cast to value type failed because the materialized value is null

.NET 4.0, Nullable has a "GetValueOrDefault()" method. So if you cast the query to Nullable, then you can end up with the correct Type when complete. This method will also generate the correct single SQL SELECT SUM query and is faster than other solutions that return the entire recordset to later sum via linq...decimal result = ((decimal?)query.Whe...
automapper c# entity-framework-6
asked by Mike

EF - pass null value to SQL column so default value gets inserted

Thanks to squillman's ...reference to another SO post..., I was able to find the answer. ...Go to EDMX diagram, and you can set the StoreGeneratedPattern property to achieve what I am trying to do....There are three Database Generated Options...Computed : The database generates a value when a row is inserted or updated. Identity : The database gene...
entity-framework-6 sql-server
asked by nanonerd

Entity framework error ... property could not be set to 'System.Int16' value

I don't understand much but I think you should change PayTermExternalKey's type in class PayTerm from int to short. Because System.Int16 is short type.
c# entity-framework-6
asked by IFZR

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