public static void ExecuteBulkImport <T>(IEnumerable <T> records, String tableName)
{
OpenConnection();
using (SqlConnection conn = _sqlConnection)
{
SqlBulkCopy bc = new SqlBulkCopy(conn)
{
DestinationTableName = tableName
};
var dataReader = new MyDataReader <T>()
{
Records = records.ToList()
};
try
{
bc.WriteToServer(dataReader);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
CloseConnection();
}
}
}
public static void ExecuteBulkImport <T>(IEnumerable <T> records, string TableName)
{
OpenConnection();
using (SqlConnection conn = sqlConn)
{
SqlBulkCopy sqlBulk = new SqlBulkCopy(conn)
{
DestinationTableName = TableName
};
var dataReader = new MyDataReader <T>(records.ToList());
try
{
sqlBulk.WriteToServer(dataReader);
}
catch (Exception)
{
throw;
}
finally
{
CloseConnection();
}
}
}
public void ExecuteBulkImport <T>(IEnumerable <T> records, string tableName)
{
OpenConnection();
SqlBulkCopy sbc = new SqlBulkCopy(connection)
{
DestinationTableName = tableName
};
MyDataReader <T> reader = new MyDataReader <T>(records.ToList());
try {
sbc.WriteToServer(reader);
} catch (Exception ex) {
Console.WriteLine("Error: {0}", ex.Message);
} finally {
CloseConnection();
}
}
public static void ExecuteBulkImport <T>(IEnumerable <T> records, string tableName)
{
OpenConnection();
using (SqlConnection conn = _sqlConnection)
{
SqlBulkCopy bc = new SqlBulkCopy(conn)
{
DestinationTableName = tableName
};
var dataReader = new MyDataReader <T>(records.ToList());
try {
bc.WriteToServer(dataReader);
}
catch (Exception ex) {
// should do something here
WriteLine($"Something bad happened.\n{ex.Message}");
}
finally
{
CloseConnection();
}
}
}