Posted on: 1/21/2015 5:33:42 PM | Views : 589

I have a column in the database that is integer and allows null values.  In code I need to add a row with a null value.  Setting int type variables to DBNull.value doesn't compile.  System.Data.SqlTypes.SqlInt32.Null does not work.  Right now I'm getting the error "System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values".
The update line is ctx.ApplyCurrentValues(ctx.tblLicenses.EntitySet.Name, licOrg), so I need to set licOrg.numericColumn = System.Data.SqlTypes.SqlInt32.Null in order to update the column to null.  I'm working in VB.

Go to the complete details ...