public void BulkInsertMissingMandatoryField() {
IList<BulkData> source = new List<BulkData>();
int dataCount = 1;
DateTime currentDate = DateTime.UtcNow;
for (int i = 0; i < dataCount; i++) {
BulkData bulkData = new BulkData();
bulkData.Name = string.Format("Name-{0}", i);
if (i % 2 == 0) { bulkData.Value = i.ToString(); }
source.Add(bulkData);
}
using (DatabaseConnector databaseConnector = new DatabaseConnector(connectionString)) {
// Insere os registros.
databaseConnector.BulkInsert("BulkData", source);
}
}
public void BulkInsert() {
IList<BulkData> source = new List<BulkData>();
int dataCount = 100;
DateTime currentDate = DateTime.UtcNow;
for (int i = 0; i < dataCount; i++) {
BulkData bulkData = new BulkData();
bulkData.Name = string.Format("Name-{0}", i);
if (i % 2 == 0) { bulkData.Value = i.ToString(); }
bulkData.CreateDate = currentDate;
source.Add(bulkData);
}
string query = @"DELETE FROM BulkData;";
int actual = 0;
using (DatabaseConnector databaseConnector = new DatabaseConnector(connectionString)) {
// Limpa qualquer informação pré-existente.
databaseConnector.ExecuteNonQuery(query);
// Insere os registros.
databaseConnector.BulkInsert("BulkData", source);
// Exclui os registros e armazena a quantidade excluída.
actual = databaseConnector.ExecuteNonQuery(query);
}
Assert.AreEqual(dataCount, actual);
}
