A new record is created by calling Resultset.Append() or Resultset.NewRecord()


The columns of the new record are initialized with default values:


  • If a column allows a null value, then the initial value is set to null
  • A boolean (bit) column is set to false (zero)
  • A DateTime column is set to "new DateTime(1900, 1, 1)"
  • A Numeric column is set to 0
  • A TimeSpan column is set to "new TimeSpan(0)"
  • A DateTimeOffset column is set to "new DateTimeOffset()"
  • An Object type column is set to "new object()"