When an entity is mapped onto a view, it can't read the 'NULLABLE' metadata from the view (like it can for a table) so it sets all fields as 'is nullable' = false. This prevents you from setting the value of a field to null. This causes serious issues when the field is a nullable FK. There is no way to remove the relationship! I opened up my project using a custom property editor I built which directly manipulates the project object model; I didn't see a way to set a field to be nullable.

Is their any way to override the 'nullable' value of a field?

Thanks CT

set the field's SourceColumnIsNullable to true.

I'll add this to the 1.0.2005.1 designer. It's an oversight which should be there for entities mapped onto views.

Coo.

Once again, awesome support!

Thanks CT