public static EducationOrganizationTestDataBuilder Initialize(IDbConnection connection)
{
var builder = new EducationOrganizationTestDataBuilder {
Connection = connection
};
using var command = connection.CreateCommand();
command.CommandText = "SELECT LocalEducationAgencyCategoryDescriptorId FROM edfi.LocalEducationAgencyCategoryDescriptor;";
builder.TestLocalEducationAgencyCategoryDescriptorId = Convert.ToInt32(command.ExecuteScalar());
command.CommandText = "SELECT ProviderStatusDescriptorId FROM edfi.ProviderStatusDescriptor;";
builder.TestProviderStatusDescriptorId = Convert.ToInt32(command.ExecuteScalar());
command.CommandText = "SELECT ProviderCategoryDescriptorId FROM edfi.ProviderCategoryDescriptor;";
builder.TestProviderCategoryDescriptorId = Convert.ToInt32(command.ExecuteScalar());
command.CommandText = "SELECT GradeLevelDescriptorId FROM edfi.GradeLevelDescriptor;";
builder.TestGradeLevelDescriptorId = Convert.ToInt32(command.ExecuteScalar());
command.CommandText = "SELECT EmploymentStatusDescriptorId FROM edfi.EmploymentStatusDescriptor;";
builder.TestEmploymentStatusDescriptorId = Convert.ToInt32(command.ExecuteScalar());
command.CommandText = "SELECT StaffClassificationDescriptorId FROM edfi.StaffClassificationDescriptor;";
builder.TestStaffClassificationDescriptorId = Convert.ToInt32(command.ExecuteScalar());
command.CommandText = "SELECT ResponsibilityDescriptorId FROM edfi.ResponsibilityDescriptor;";
builder.TestResponsibilityDescriptorId = Convert.ToInt32(command.ExecuteScalar());
return(builder);
}
public void Setup()
{
_transaction = new TransactionScope();
Connection = BuildTestConnection();
Builder = EducationOrganizationTestDataBuilder.Initialize(Connection);
}