public void Initialize()
{
commandMock = new Mock <IDbCommand>();
connectionMock = new Mock <IDbConnection>();
transactionMock = new Mock <IDbTransaction>();
connectionMock.Setup(c => c.CreateCommand()).Returns(commandMock.Object);
connectionMock.Setup(c => c.BeginTransaction()).Returns(transactionMock.Object);
ProviderFactory.ConnectionFactory = (provider) => connectionMock.Object;
ProviderFactory.CustomProvider = (provider) => new SqlProvider();
parameterMock = new Mock <IDbDataParameter>();
parameterCollectionMock = new Mock <IDataParameterCollection>();
commandMock.Setup(c => c.CreateParameter()).Returns(parameterMock.Object);
commandMock.Setup(c => c.Parameters).Returns(parameterCollectionMock.Object);
commandMock.Setup(c => c.CommandText).Returns(String.Empty);
target = new Airplane {
Name = "Fokker Dr.I", FirstFlight = 1917
};
anotherTarget = new AnotherAirplaneClass {
Name = "Fokker Dr.I", FirstFlight = 1917
};
command = new DataObjectCommand <Airplane>();
anotherCommand = new DataObjectCommand <AnotherAirplaneClass>(table: "AirplanesTable", primaryKey: "AirplaneCode");
}
public void Initialize()
{
commandMock = new Mock<IDbCommand>();
connectionMock = new Mock<IDbConnection>();
transactionMock = new Mock<IDbTransaction>();
connectionMock.Setup(c => c.CreateCommand()).Returns(commandMock.Object);
connectionMock.Setup(c => c.BeginTransaction()).Returns(transactionMock.Object);
ProviderFactory.ConnectionFactory = (provider) => connectionMock.Object;
ProviderFactory.CustomProvider = (provider) => new SqlProvider();
parameterMock = new Mock<IDbDataParameter>();
parameterCollectionMock = new Mock<IDataParameterCollection>();
commandMock.Setup(c => c.CreateParameter()).Returns(parameterMock.Object);
commandMock.Setup(c => c.Parameters).Returns(parameterCollectionMock.Object);
commandMock.Setup(c => c.CommandText).Returns(String.Empty);
target = new Airplane { Name = "Fokker Dr.I", FirstFlight = 1917 };
anotherTarget = new AnotherAirplaneClass { Name = "Fokker Dr.I", FirstFlight = 1917 };
command = new DataObjectCommand<Airplane>();
anotherCommand = new DataObjectCommand<AnotherAirplaneClass>(table: "AirplanesTable", primaryKey: "AirplaneCode");
}
public void Execute()
{
ProviderResolver.CustomProviderType = typeof(AnotherSqlProvider);
var commandManufacturer = new DataObjectCommand<Manufacturer>(table: "Le_Manufacturer", primaryKey: "TheId");
var commandCar = new DataObjectCommand<Car>();
var selectManufacturer = new DataObjectQuery<Manufacturer>("{0} FROM Le_Manufacturer");
var selectCar = new DataObjectQuery<Car>();
var manufacturerId = 0;
BeginTest.To(new Manufacturer { Name = "Lotus", BuildYear = 1952 }).ThrowExceptions()
.Should("Not has id before insert object on database").Assert(m => m.TheId == 0)
.Should("Be possible insert a manufacturer and bind generated id").Assert(m =>
{
commandManufacturer.Insert(m);
manufacturerId = m.TheId;
return manufacturerId > 0;
})
.Should("Commands and query manufacturers with custom datacontext").Assert(m =>
{
using (var datacontext = new DataContext())
{
var manufacturer = new Manufacturer { Name = "General Motors", BuildYear = 1908 };
commandManufacturer.Insert(manufacturer, datacontext);
var manufacturers = selectManufacturer.With(datacontext).All();
return manufacturers.Count == 2;
// Not Committed!
}
})
.Should("Have used custom provider to insert").Assert(c => AnotherSqlProvider.ThisWasUsed);
BeginTest.To(new Car { Name = "Esprit Turbo", ModelYear = 1981, Mileage = 318, ManufacturerId = manufacturerId })
.Should("Insert car with manufacturer id previously created").Assert(c =>
{
commandCar.Insert(c);
var insertedCar = selectCar.First("WHERE Name = @Name", c);
return insertedCar != null;
})
.Should("Save correct properties on database").Assert(c =>
{
var car = selectCar.First("WHERE Id = @Id", c);
return car.Name == "Esprit Turbo" &&
car.ModelYear == 1981 &&
car.Mileage == 318 &&
car.ManufacturerId == manufacturerId &&
car.Date.Day == DateTime.Today.Day;
})
.Should("Update car informations on database").Assert(c =>
{
c.Name = "Esprit S3";
commandCar.Update(c);
var updatedCar = selectCar.First("WHERE Id = @Id", c);
return updatedCar.Name == "Esprit S3";
})
.Should("Delete created car").Assert(c =>
{
commandCar.Delete(c);
var deletedCar = selectCar.First("WHERE Id = @Id", c);
return deletedCar == null;
});
}
