public void StoredProcedure_WithSqlTransactionCommitted_DoesWriteRecords()
{
// ARRANGE
const int expectedIntermediateCount = 5;
int originalCount;
int intermediateCount;
int finalCount;
string connectionName = Settings.Default.ExampleDatabaseConnection;
var companiesToAdd = new List<CompaniesAdd.CompanyTableType>
{
new CompaniesAdd.CompanyTableType { CompanyName = "Company 1", IsActive = true, TenantId = 2 },
new CompaniesAdd.CompanyTableType { CompanyName = "Company 2", IsActive = false, TenantId = 2 },
new CompaniesAdd.CompanyTableType { CompanyName = "Company 3", IsActive = true, TenantId = 2 }
};
var companiesAddParameters = new CompaniesAdd.CompaniesAddParameters
{
Companies = companiesToAdd
};
var companyAddProcedure = new CompaniesAdd(companiesAddParameters);
var companyCountProcedure = new CompanyCountAll();
var companyDeleteParameters = new TenantIdParameters
{
TenantId = 2
};
var companyDeleteProcedure = new CompanyDeleteForTenantId(companyDeleteParameters);
// ACT
using (var connection = new SqlConnection(connectionName))
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
using (var context = new ApplicationDbContext(connection, false))
{
originalCount = context.ExecuteStoredProcedure(companyCountProcedure, transaction: transaction).First().CountOfCompanies;
context.ExecuteStoredProcedure(companyAddProcedure, transaction: transaction);
transaction.Commit();
}
}
}
using (var context = new ApplicationDbContext(connectionName))
{
intermediateCount = context.ExecuteStoredProcedure(companyCountProcedure).First().CountOfCompanies;
context.ExecuteStoredProcedure(companyDeleteProcedure);
finalCount = context.ExecuteStoredProcedure(companyCountProcedure).First().CountOfCompanies;
}
// ASSERT
Assert.AreEqual(originalCount, finalCount);
Assert.AreEqual(expectedIntermediateCount, intermediateCount);
}
public void CompanyGetAllForTenantId()
{
// ARRANGE
const int expectedCompanyCount = 2;
string connectionName = Settings.Default.ExampleDatabaseConnection;
var parameters = new TenantIdParameters { TenantId = 1 };
var procedure = new CompanyGetAllForTenantID(parameters);
List<CompanyDto> companies;
CompanyDto company1;
// ACT
using (ApplicationDbContext context = new ApplicationDbContext(connectionName))
{
companies = context.ExecuteStoredProcedure(procedure);
company1 = companies.FirstOrDefault();
}
// ASSERT
Assert.AreEqual(expectedCompanyCount, companies.Count);
Assert.IsNotNull(company1);
}
public void StoredProcedure_WithTransactionScopeNotCommited_DoesNotWriteRecords()
{
// ARRANGE
const int expectedIntermediateCount = 5;
int originalCount;
int intermediateCount;
int finalCount;
string connectionName = Settings.Default.ExampleDatabaseConnection;
var companiesToAdd = new List<CompaniesAdd.CompanyTableType>
{
new CompaniesAdd.CompanyTableType { CompanyName = "Company 1", IsActive = true, TenantId = 2 },
new CompaniesAdd.CompanyTableType { CompanyName = "Company 2", IsActive = false, TenantId = 2 },
new CompaniesAdd.CompanyTableType { CompanyName = "Company 3", IsActive = true, TenantId = 2 }
};
var parameters = new CompaniesAdd.CompaniesAddParameters
{
Companies = companiesToAdd
};
var companyAddProcedure = new CompaniesAdd(parameters);
var companyCountProcedure = new CompanyCountAll();
// ACT
using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
using (var context = new ApplicationDbContext(connectionName))
{
originalCount = context.ExecuteStoredProcedure(companyCountProcedure).First().CountOfCompanies;
context.ExecuteStoredProcedure(companyAddProcedure);
intermediateCount = context.ExecuteStoredProcedure(companyCountProcedure).First().CountOfCompanies;
}
}
using (var context = new ApplicationDbContext(connectionName))
{
finalCount = context.ExecuteStoredProcedure(companyCountProcedure).First().CountOfCompanies;
}
// ASSERT
Assert.AreEqual(originalCount, finalCount);
Assert.AreEqual(expectedIntermediateCount, intermediateCount);
}