I use the Stored Procedure Profile Provider in my ASP.NET web Project.
One of the values I need to store on the User Object is called PaymentDate. The datatype need to be DateTime, but since the value can be NULL I need the datatype it to be nullable.
In web.config I do like this:
<add name="PaymentDate" defaultValue="[null]" type="System.DateTime?" customProviderData="PaymentDate;DateTime;8" />
The code compile, and everything seems to work fine. But, when I open the web page I get a web.config error saying "Cannot load type System.DateTime?
If I change "System.DateTime?" to "System.DateTime" it is not possible to set p.PaymentDate = null; (PaymentDate cannot be null).
So, how can I set the PaymentDate Type to be Nullable DateTime in web.config?