Nullable

The light speed designer could do a better job recognizing nullable types from the database

(Like an option when you click update from source

Change property to nullable)

especially where relations are concerned

I dont think it makes foreign keys nullable at all. Has to be set manully

Hmm, it certainly should be inferring nullability of associations.  I will look into this.

You are right that schema round-tripping does not currently detect changes in nullability.  I have logged a feature request for this.

I was going to write up a new post, but then saw this one, which says everything :-)

The nullable foreign key relationship is not picked up by the designer either from drag-and-drop or update from source.

This is not critical for a small model, but the annoyance level grows as the model grows as the designer doesn't arrange thing nicely and everything is sort of squashed together.

I can't reproduce this.  I've just run a test here, when I drag-and-drop a pair of tables with a nullable FKs between them, I get an association with Is Nullable = True.  If I then change Is Nullable to false in the designer and do an Update From Source, it detects that the association should be nullable and offers to change it accordingly.  (Testing using SQL Server, though that shouldn't make any difference.)

Could you provide us with a CREATE TABLE script and/or specific instructions to reproduce this issue?

Hi Ivan,

Sorry I didn't get back to this posting sooner.  Got caught up in some W2K3 to W2K8 migration madness... (and it's still going on!)

I will get you guys the scripts and repro steps soon.

Cheers

Joseph