tags:

views:

108

answers:

1
Q: 

Entity Framework 4.0 & null fields in Views

We're adding some views to our entity framework model. Some fields in these views are nullable datetime2 datatypes in our sql server 2k8 db and the edmx is incorrectly showing these fields as being not null. Is this a known issue?

When I try to change them to not null it still throws the same error - because it appears as if the ssdl is defining it differently?

Has anyone run into this problem?

Edit: My exact error is:

The 'dateTimeAffected' property on 'V_myView' could not be set to a 'null' value. You must set this property to a non-null value of type 'DateTime'

Removing the view and adding it back in does not fix it as well... still marks the field as not nullable.

A: 

Sorry for this silly answer but you did delete the tables and add them again...for some reason ef4 does not refresh them properly...but ya not a known problem with ef4 it should show them as nullable...btw what error are you getting?

Misnomer  2010-06-28 21:00:35
Yes, I tried this multiple times... still shows it as being nullable = false.... and marking it as an entity key. I also tried removing the entity that references the db table that the view is built upon
Chris Klepeis  2010-06-28 21:09:57
The exact error is: The 'dateTimeAffected' property on 'V_myView' could not be set to a 'null' value. You must set this property to a non-null value of type 'DateTime'.
Chris Klepeis  2010-06-28 21:11:01
hmm..sorry no idea..found this -http://forums.asp.net/t/1393277.aspx
Misnomer  2010-06-28 21:17:46
and this -http://www.eggheadcafe.com/software/aspnet/29728971/nullable-object-must-have.aspx
Misnomer  2010-06-28 21:25:56

related questions

A SQL query that replaces null values.
Why does Oracle 9i treat an empty string as NULL?
Get null == null in SQL
Is there a Java standard "both null or equal" static method?
I'm getting a NULL output in a SQL Function when concatting fields
Why is "null" present in C# and java?
What is the best way to convert an int or null to boolean value in an SQL query?
Do you use NULL or 0 (zero) for pointers in C++?
Return 'null' or throw exception
Either OR non-null constraints in MySQL
How do you construct a std::string with an embedded null?
Are nulls in a relational database okay?
Anyone have issues going from ColdFusion's serializeJSON method to PHP's json_decode?
C# object is not null but (myObject != null) still return false
Possible causes of Java VM EXCEPTION_ACCESS_VIOLATION?
Null vs. False vs. 0
SQL NOT IN constraint and NULL values
What to do with null fields in compare() ?
Indexing nulls for fast searching on DB2
(any == System.DBNull.Value) vs (any is System.DBNull)
How do you deal with NULL values in columns of type boolean in MS Access?
IsNull function in DB2 SQL?
Passing null to a method
C# Database Access: DBNull vs null
IllegalArgumentException or NullPointerException for a null parameter?