public void TestSequences()
{
//Only MS SQL and Postgres support sequences
switch (Startup.ServerType)
{
case Data.Driver.DbServerType.MsSql:
case Data.Driver.DbServerType.Postgres: break;
default: return;
}
_app = new SequenceTestApp();
Startup.DropSchemaObjects("seq");
Startup.ActivateApp(_app);
var session = _app.OpenSession();
for (int i = 0; i < 10; i++)
{
var intValue = session.GetSequenceNextValue <int>("seq.IntSequence");
var longValue = session.GetSequenceNextValue <long>("seq.LongSequence");
}
var john = session.NewEntity <IPerson>();
john.Name = "Jack M";
var car1 = session.NewEntity <ICar>();
car1.Model = "Beatle";
car1.Owner = john;
var car2 = session.NewEntity <ICar>();
car2.Model = "Legacy";
car2.Owner = john;
//Check that Identity values immediately changed to actual positive values loaded from database
Assert.IsTrue(john.Id > 0, "Invalid person ID - expected positive value.");
Assert.IsTrue(car1.Id > 0, "Invalid car1 ID - expected positive value.");
Assert.IsTrue(car2.Id > 0, "Invalid car2 ID - expected positive value.");
session.SaveChanges();
//Start new session, load all and check that IDs and relationships are correct
session = _app.OpenSession();
var persons = session.GetEntities <IPerson>().ToList();
john = persons[0];
var cars = session.GetEntities <ICar>().ToList();
car1 = cars[0];
car2 = cars[1];
Assert.IsTrue(john.Id > 0 && car1.Id > 0 && car2.Id > 0, "IDs expected to become > 0 after saving.");
Assert.IsTrue(car1.Owner == john, "Owner expected to be John");
Assert.IsTrue(car2.Owner == john, "Owner expected to be John");
} //method
public void TestSequences()
{
//Only MS SQL and Postgres support sequences
switch (SetupHelper.ServerType) {
case Data.Driver.DbServerType.MsSql: case Data.Driver.DbServerType.Postgres: break;
default: return;
}
_app = new SequenceTestApp();
SetupHelper.DropSchemaObjects("seq");
SetupHelper.ActivateApp(_app);
var session = _app.OpenSession();
for(int i = 0; i < 10; i++) {
var intValue = session.GetSequenceNextValue<int>("seq.IntSequence");
var longValue = session.GetSequenceNextValue<long>("seq.LongSequence");
}
var john = session.NewEntity<IPerson>();
john.Name = "Jack M";
var car1 = session.NewEntity<ICar>();
car1.Model = "Beatle";
car1.Owner = john;
var car2 = session.NewEntity<ICar>();
car2.Model = "Legacy";
car2.Owner = john;
//Check that Identity values immediately changed to actual positive values loaded from database
Assert.IsTrue(john.Id > 0, "Invalid person ID - expected positive value.");
Assert.IsTrue(car1.Id > 0, "Invalid car1 ID - expected positive value.");
Assert.IsTrue(car2.Id > 0, "Invalid car2 ID - expected positive value.");
session.SaveChanges();
//Start new session, load all and check that IDs and relationships are correct
session = _app.OpenSession();
var persons = session.GetEntities<IPerson>().ToList();
john = persons[0];
var cars = session.GetEntities<ICar>().ToList();
car1 = cars[0];
car2 = cars[1];
Assert.IsTrue(john.Id > 0 && car1.Id > 0 && car2.Id > 0, "IDs expected to become > 0 after saving.");
Assert.IsTrue(car1.Owner == john, "Owner expected to be John");
Assert.IsTrue(car2.Owner == john, "Owner expected to be John");
}