public static void ExecuteBulkCopy <T>(IEnumerable <T> records, string tableName)
{
OpenConnection();
using (var connection = _sqlConnection)
{
var bc = new SqlBulkCopy(connection)
{
DestinationTableName = tableName
};
var dataReader = new MyDataReader <T> {
Records = records.ToList()
};
try
{
bc.WriteToServer(dataReader);
}
catch (Exception ex)
{
}
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 e)
{
Console.WriteLine(e);
throw;
}
finally{ CloseConnection(); }
}
}