public void TestMicrosoftSqlConnectionBaseRepositoryBulkInsertForEntitiesWithReturnIdentity()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
var bulkInsertResult = repository.BulkInsert(tables, isReturnIdentity: true);
// Assert
Assert.AreEqual(tables.Count, bulkInsertResult);
Assert.IsFalse(tables.Any(e => e.Id <= 0));
// Act
var queryResult = repository.QueryAll();
// Assert
Assert.AreEqual(tables.Count, queryResult.Count());
tables.AsList().ForEach(t =>
{
var item = queryResult.FirstOrDefault(e => e.Id == t.Id);
Helper.AssertPropertiesEquality(t, item);
});
}
}
public void TestMicrosoftSqlConnectionBaseRepositoryBulkInsertForEntitiesWithMappings()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
var mappings = new List <BulkInsertMapItem>();
// Add the mappings
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnBit), nameof(BulkOperationIdentityTable.ColumnBit)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDateTime), nameof(BulkOperationIdentityTable.ColumnDateTime)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDateTime2), nameof(BulkOperationIdentityTable.ColumnDateTime2)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDecimal), nameof(BulkOperationIdentityTable.ColumnDecimal)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnFloat), nameof(BulkOperationIdentityTable.ColumnFloat)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnInt), nameof(BulkOperationIdentityTable.ColumnInt)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnNVarChar), nameof(BulkOperationIdentityTable.ColumnNVarChar)));
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
var bulkInsertResult = repository.BulkInsert(tables);
// Assert
Assert.AreEqual(tables.Count, bulkInsertResult);
// Act
var queryResult = repository.QueryAll();
// Assert
Assert.AreEqual(tables.Count, queryResult.Count());
tables.AsList().ForEach(t =>
{
Helper.AssertPropertiesEquality(t, queryResult.ElementAt(tables.IndexOf(t)));
});
}
}
public void TestSystemSqlConnectionDbRepositoryBulkInsertForTableNameEntitiesWithReturnIdentityViaPhysicalPseudoTempTable()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
var bulkInsertResult = repository.BulkInsert(ClassMappedNameCache.Get <BulkOperationIdentityTable>(), tables, isReturnIdentity: true, usePhysicalPseudoTempTable: true);
// Assert
Assert.AreEqual(tables.Count, bulkInsertResult);
Assert.IsFalse(tables.Any(e => e.Id <= 0));
// Act
var queryResult = repository.QueryAll();
// Assert
Assert.AreEqual(tables.Count, queryResult.Count());
tables.AsList().ForEach(t =>
{
var item = queryResult.FirstOrDefault(e => e.Id == t.Id);
Helper.AssertPropertiesEquality(t, item);
});
}
}
public void ThrowExceptionOnMicrosoftSqlConnectionBaseRepositoryBulkInsertForEntitiesIfTheMappingsAreInvalid()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
var mappings = new List <BulkInsertMapItem>();
// Add invalid mappings
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnBit), nameof(BulkOperationIdentityTable.ColumnBit)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDateTime), nameof(BulkOperationIdentityTable.ColumnDateTime)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDateTime2), nameof(BulkOperationIdentityTable.ColumnDateTime2)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDecimal), nameof(BulkOperationIdentityTable.ColumnDecimal)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnFloat), nameof(BulkOperationIdentityTable.ColumnFloat)));
// Switched
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnInt), nameof(BulkOperationIdentityTable.ColumnNVarChar)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnNVarChar), nameof(BulkOperationIdentityTable.ColumnInt)));
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.BulkInsert(tables, mappings);
}
}
public void TestMicrosoftSqlConnectionBaseRepositoryBulkInsertForEntities()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
var bulkInsertResult = repository.BulkInsert(tables);
// Assert
Assert.AreEqual(tables.Count, bulkInsertResult);
// Act
var queryResult = repository.QueryAll();
// Assert
Assert.AreEqual(tables.Count, queryResult.Count());
tables.AsList().ForEach(t =>
{
Helper.AssertPropertiesEquality(t, queryResult.ElementAt(tables.IndexOf(t)));
});
}
}
public void TestSystemSqlConnectionDbRepositoryBulkInsertForTableNameEntities()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
var bulkInsertResult = repository.BulkInsert(ClassMappedNameCache.Get <BulkOperationIdentityTable>(), tables);
// Assert
Assert.AreEqual(tables.Count, bulkInsertResult);
// Act
var queryResult = repository.QueryAll();
// Assert
Assert.AreEqual(tables.Count, queryResult.Count());
tables.AsList().ForEach(t =>
{
Helper.AssertPropertiesEquality(t, queryResult.ElementAt(tables.IndexOf(t)));
});
}
}
