public BulkInsert(SalesRecordDbContext dbContext)
{
try
{
_dbContext = dbContext;
_sqlConnection = new SqlConnection(_dbContext.Database.GetDbConnection().ConnectionString);
_sqlConnection.Open();
_sqlTransaction = _sqlConnection.BeginTransaction();
var salesRecordType = _dbContext.Model.FindRuntimeEntityType(typeof(SalesRecord));
_dataTable.TableName = salesRecordType.Relational().TableName;
_sqlBulkCopy = new SqlBulkCopy(_sqlConnection, SqlBulkCopyOptions.Default, _sqlTransaction);
foreach (var prop in salesRecordType.GetProperties())
{
_dataTable.Columns.Add(prop.Name, prop.PropertyInfo.PropertyType);
_properties.Add(prop.PropertyInfo);
_sqlBulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(prop.PropertyInfo.Name, prop.Name));
}
}
catch
{
_errorOccured = true;
Dispose();
}
}
public SalesRecordsRepository(SalesRecordDbContext dbContext)
{
_dbContext = dbContext;
}
public UnitOfWork(SalesRecordDbContext salesRecordDbContext)
{
_salesRecordDbContext = salesRecordDbContext;
}
public ProfitByYearAndCountryReportGenerator(SalesRecordDbContext salesRecordDbContext)
{
_salesRecordDbContext = salesRecordDbContext;
}
public OrdersCountByYearAndCountryReportGenerator(SalesRecordDbContext dbContext)
{
_dbContext = dbContext;
}
