public void TestBaseRepositoryNumbersNullCrud() { // Setup var entity = new NumbersClass { SessionId = Guid.NewGuid(), ColumnBigInt = null, ColumnBit = null, ColumnDecimal = null, ColumnFloat = null, ColumnInt = null, ColumnMoney = null, ColumnNumeric = null, ColumnReal = null, ColumnSmallInt = null, ColumnSmallMoney = null }; using (var repository = new NumbersClassRepository(Database.ConnectionStringForRepoDb)) { // Act Insert var id = repository.Insert(entity); // Act Query var data = repository.Query(e => e.SessionId == (Guid)id).FirstOrDefault(); // Assert Assert.IsNotNull(data); Assert.IsNull(data.ColumnBigInt); Assert.IsNull(data.ColumnBit); Assert.IsNull(data.ColumnDecimal); Assert.IsNull(data.ColumnFloat); Assert.IsNull(data.ColumnInt); Assert.IsNull(data.ColumnMoney); Assert.IsNull(data.ColumnNumeric); Assert.IsNull(data.ColumnReal); Assert.IsNull(data.ColumnSmallInt); Assert.IsNull(data.ColumnSmallMoney); } }