public SqlUnitOfWork(IDbConnection connection)
{
_connection = connection;
_transaction = _connection.BeginTransaction();
_context = new FlowDataContext(_connection)
{
Transaction = (DbTransaction)_transaction
};
FlowTemplates = new FlowTemplateRepository(_context);
FlowTemplateSteps = new FlowTemplateStepRepository(_context);
}
public FlowTemplateStepRepositoryTests()
{
_connection = new SqlConnection(LocalConnectionString);
_connection.Open();
_transaction = _connection.BeginTransaction();
_context = new FlowDataContext(_connection)
{
Transaction = _transaction
};
newTemplate = new FlowTemplate
{
Name = "Example Template 1"
};
_context.FlowTemplates.InsertOnSubmit(newTemplate);
_context.SubmitChanges();
startStep = new Library.Data.FlowTemplateStep
{
FlowTemplateId = newTemplate.Id,
Name = "Example StartStep 1",
StepTypeId = 1
};
collectDataStep = new Library.Data.FlowTemplateStep
{
FlowTemplateId = newTemplate.Id,
Name = "Example CollectDataStep 2",
StepTypeId = 3
};
storeDataStep = new Library.Data.FlowTemplateStep
{
FlowTemplateId = newTemplate.Id,
Name = "Example StoreDataStep 3",
StepTypeId = 4
};
stopStep = new Library.Data.FlowTemplateStep
{
FlowTemplateId = newTemplate.Id,
Name = "Example StopStep 4",
StepTypeId = 2
};
_context.FlowTemplateSteps.InsertAllOnSubmit(new[] { startStep, collectDataStep, storeDataStep, stopStep });
_context.SubmitChanges();
_transaction.Save("insert");
_repository = new FlowTemplateStepRepository(_context);
}
public FlowTemplateRepositoryTests()
{
_connection = new SqlConnection(LocalConnectionString);
_connection.Open();
_transaction = _connection.BeginTransaction();
using (var command = new SqlCommand(@"INSERT INTO FlowTemplate (Name) VALUES ('Example Template 1');", _connection, _transaction))
{
command.ExecuteNonQuery();
}
_transaction.Save("insert");
_context = new FlowDataContext(_connection)
{
Transaction = _transaction
};
_repository = new FlowTemplateRepository(_context);
}
public FlowInstanceRepositoryTests()
{
Console.WriteLine("SomeFixture ctor: This should only be run once");
_connection = new SqlConnection(LocalConnectionString);
_connection.Open();
_transaction = _connection.BeginTransaction();
using (var command = new SqlCommand("INSERT INTO FlowInstance (Id) VALUES (1);", _connection, _transaction))
{
command.ExecuteNonQuery();
}
_transaction.Save("insert");
_context = new FlowDataContext(_connection)
{
Transaction = _transaction
};
_flowInstanceRepository = new FlowInstanceRepository(_context);
}
public FlowTemplateStepRepository(FlowDataContext context)
{
_context = context;
}
public FlowInstanceRepository(FlowDataContext context)
{
_context = context;
}
