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