MembershipUser constructor expects dateTime fields that might be null

Question

The MemberShipUser constructor expects dateTime fields like lastLoginDate, which may be null in the data store.

However, when I retrieve data from the store and pass null in for the parameter, I get an error that it cannot be null.

How can I work around this?

Answer 1

Update your query to return a date for nulls - maybe current date or '1900-01-01'

ISNULL(DateField, '1900-01-01') AS DateField

Answer 2

I believe the expectation with the ASP.NET standard Membership provider is that the user has registered on your site and as a result has effectively logged in at the same time as their user record was created.

If you are bulk loading the memberships then I'd suggest setting the lastLoginDate to DateTime.Now, better than leaving it null.