Can't insert a DateTime into my database with Linq to sql

chobo2 · August 15th, 2009, 03:46 AM

Hi

I am trying to insert some dateTimes into my database for the aspnet_membership table but every single time I try too. I get this error

Code:

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

I have no clue why or what I am doing wrong

Code:

   DateTime DateFields = new DateTime(1750, 1, 1, 0, 0, 0);

aspnet_Membership membership = new aspnet_Membership();
                membership.ApplicationId = applicationId;
                membership.UserId = userId;
                membership.Password = password;
                membership.PasswordFormat = passwordFormat;
                membership.PasswordSalt = base64Salt;
                membership.MobilePIN = null;
                membership.Email = email;
                membership.LoweredEmail = email.ToLower();
                membership.PasswordQuestion = null;
                membership.PasswordAnswer = null;
                membership.IsApproved = isApproved;
                membership.IsLockedOut = false;
                membership.CreateDate = dateCreated;
                membership.LastLoginDate = DateFields ;
                membership.LastPasswordChangedDate = DateFields ;
                membership.LastLoginDate = DateFields ;
                membership.FailedPasswordAttemptWindowStart = DateFields;
                membership.FailedPasswordAnswerAttemptCount = 0;
                membership.FailedPasswordAnswerAttemptWindowStart = DateFields;
                membership.FailedPasswordAnswerAttemptCount = 0;
                membership.Comment = null;

                Db.aspnet_Memberships.InsertOnSubmit(membership);
                Db.SubmitChanges();

Lee Dumond · August 15th, 2009, 08:28 AM

You are initializing DateFields as 1/1/1750. That is three years too early.

Use a date after 1/1/1753.

chobo2 · August 15th, 2009, 01:53 PM

Quote:

Originally Posted by Lee Dumond

You are initializing DateFields as 1/1/1750. That is three years too early.

Use a date after 1/1/1753.

Sorry I was trying just random things to see if it would work. I have tried some in the range. Like 1/1/1954. I even used Date.Now and still I get that error.

Lee Dumond · August 15th, 2009, 05:55 PM

Try this:

Code:

using System.Data.SqlTypes;
 
SqlDateTime dateFields = new SqlDateTime(new DateTime(1954, 1, 1));

Don't understand what you're trying to do. There is a Membership API that lets you create new members and insert them into the database. There should be no need whatsoever to interact with the aspnet_Membership table directly, unless I am missing something.