Ted,
>When an SQL server column is nullable how do I set/update the entity column value to null?
In the upcoming MM .ENT 2.3 We have changed nullable entity properties so this works properly. Here's an example of the new code:
this.Row["OrderDate"] = mmType.SetNullableDbValue(value);
mmType.SetNullableDbValue is a new method that looks like this:
public static object SetNullableDbValue(object value)
{
return (value == null) ? DBNull.Value : value;
}
For now, you can just change the Set() of the entity property to use similar logic as the SetNullableDbValue() method, or you can send me a private e-mail and I will get you a pre-release of the new version.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com