title: LInq to Sql Insert DateTime problem
body: <p>I’m getting started on Linq to sql. I am trying to insert a record. Here is my code.</p>
  
  <pre><code>FMCSA_USER_LOG _MyUserLog = new FMCSA_USER_LOG();
  
  _MyUserLog.USER_ID = model.UserID;
  
  _MyUserLog.ACTIVITY_TYPE_ID = model.ActivityTypeID;
  _MyUserLog.ACTIVITY_TARGET =  model.ActivityTarget;
  _MyUserLog.DESCRIPTION = model.Description;
  _MyUserLog.ACTIVITY_TIME = DateTime.Today;
  _MyUserLog.ACTIVITY_TYPE_ID = null;
  _MyUserLog.DESCRIPTION = null;
  db.FMCSA_USER_LOGs.InsertOnSubmit(_MyUserLog);
  
  db.SubmitChanges();
  </code></pre>
  
  <p>I received this exception on the SubmitChanges: </p>
  
  <blockquote>
    <p>SqlDateTime overflow. Must be between
    1/1/1753 12:00:00 AM and 12/31/9999
    11:59:59 PM.</p>
  </blockquote>
  
  <p>From my reading of this problem, it occurs when you have a date field and it is set to too low a value. Yet the only date field in the table I set to today’s date. </p>
  
  <p>Here is the record; I don’t see what I’m doing wrong.</p>
  
  <pre><code>CREATE TABLE [dbo].[FMCSA_USER_LOG](
   [ID] [int] IDENTITY(1,1) NOT NULL,
   [USER_ID] [int] NULL,
   [ACTIVITY_TIME] [datetime2](7) NOT NULL,
   [ACTIVITY_TYPE_ID] [int] NULL,
   [ACTIVITY_TARGET] [varchar](50) NULL,
   [DESCRIPTION] [varchar](8000) NULL,
   CONSTRAINT [PK_FMCSA_USER_LOG] PRIMARY KEY CLUSTERED 
   ([ID] ASC)
  )
  </code></pre>