I am not sure of the difference between a Null and a DBNull or how this applies to ConvertNullToDBNull. One of the reasons I am asking the question is that my code seems to work fine regardless of if ConvertNullToDBNull is set to true or false. So I am a bit confused. I am not sure whether (or why) I should set ConvertNullToDBNull to True.
Some background as to why I am asking the question might help. I have an ObjectDataSource that performs all CRUD operations using custom business classes. All Insert, Update and Deletes pass a business object to my DAL. My DAL then passes properties from the business object (some of which are nullable) to my stored procedures which can accept nulls (SalesOrder_INS( @TypeCode int = Null)). All of the Select commands from my DAL return a Null if the DataReader dr.IsDBNull is true.
With all that being said I am not sure what the difference is between a Null and a D ...
Go to the complete details ...