Well, all is finally working with this provider now..!

After further reviewing, I noticed that the Birthdate property was set correctly in the web.config, but in SQL it was nvarchar, changing it to datetime fixed the exception.

As for the Newsletter, I changed from nvarchar to an int and this also took care of the 2nd problem.

Thanks for the support!

I just wanted to add..

The whole Newsletter exception bothered me, I couldn't understand why it needed to be an int when after parsing the ProfileProvider "text blob" it inserted <SubscriptionType>None</SubscriptionType>, a String!. It didn't insert the enum of 0,1,2.

But I realized, that the enum.cs outputs an integer. Since the type in web.config is type="MB.TheBeerHouse.BLL.Newsletters.Subscription Type" it's bypassing the code that converts it to a string. Therefore remaining an int datatype.

I thought this comment may prove helpful if creating new classes to add to this SqlTableProfileProvider.

I hope all my mistakes will help others in this topic...

Take Care!