Default DateTime exception

I was getting the following exception:

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

at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)
at System.Data.SqlTypes.SqlDateTime..ctor(DateTime value)
at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb)
at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Mindscape.LightSpeed.Data.CommandRunner.<>c__DisplayClass7.b__6() in d:\Working\LightSpeed\Trunk\Src\Framework\Data\CommandRunner.cs:line 37
at Mindscape.LightSpeed.Data.CommandRunner.Execute(IDbCommand command, CommandExecHandler handler) in d:\Working\LightSpeed\Trunk\Src\Framework\Data\CommandRunner.cs:line 66
at Mindscape.LightSpeed.Data.CommandRunner.ExecuteNonQuery(IDbCommand command) in d:\Working\LightSpeed\Trunk\Src\Framework\Data\CommandRunner.cs:line 35
at Mindscape.LightSpeed.UnitOfWork.SaveChanges() in d:\Working\LightSpeed\Trunk\Src\Framework\UnitOfWork.cs:line 138
at Mindscape.LightSpeed.Repository.CompleteUnitOfWork(Boolean saveChanges) in d:\Working\LightSpeed\Trunk\Src\Framework\Repository.cs:line 255

Eventually I tracked down the issue to the following property on an entity class not being set (so it is the default 01/01/0001 DateTime value):

public DateTime StartDate
{
  get { return _startDate; }
  set { Set(ref _startDate, value, "StartDate"); }
}

My request is that you make issues like that easier to track down. The exception and stack trace didn't give me any information on what entity and field to search for.

One approach would have been to enable SQL logging.

Cheers,

Andrew.
 

I used SQL profiler when initially trying to figure out what was going wrong but there was no SQL executed. The stack trace also seems to indicate to me that the exception occurred while .NET was preparing the query.

Oh you meant the built in LightSpeed logging. Yes that does show it:

INSERT INTO Session
(
  Id,
  InvalidPackets,
  MissedFlowRecords,
  StartDate,
  EndDate
)
VALUES
(
  'fc1da27b-3a4e-4900-8844-260364ab9665',
  0,
  0,
  '1/01/0001 12:00:00 a.m.',
  NULL
);