public void CanReadAndSavePersonWithCats()
{
int personid;
using (var session = factory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
// create a couple of Cats each with connected to Person
var person = new Person { Name = new Name { First = "Olo", Last = "Bolus" } };
session.Save(person);
personid = person.Id;
Console.WriteLine(person.Id);
person.AddCat(new Cat { Name = "Filip" });
person.AddCat(new Cat { Name = "Nick" });
session.Save(person);
transaction.Commit();
}
}
using (var session = factory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var dbPerson = session.Get<Person>(personid);
Assert.AreEqual(2, dbPerson.Cats.Count);
}
}
}
public void CanReadAndSavePerson()
{
factory = new SessionProvider().Factory;
int personId;
using (var session = factory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var person = new Person { Name = new Name { First = "Olo", Last = "Bolus" } };
var cat = new Cat { Name = "Filip" };
session.Save(cat);
session.Save(person);
transaction.Commit();
personId = person.Id;
}
}
using (var session = factory.OpenSession())
{
using (session.BeginTransaction())
{
var person = (from p in ((IOrderedQueryable<Person>)session.Linq<Person>()) where p.Id == personId select p).First() ;
Assert.That(person.Name.First,Is.EqualTo("Olo"));
}
}
}
public void CanReadAndSavePerson()
{
int personId;
using (var session = GetSession())
{
using (var transaction = session.BeginTransaction())
{
// create a couple of Stores each with some Products and Employees
var person = new Person { Name = new Name { First = "Olo", Last = "Bolus" } };
session.SaveOrUpdate(person);
transaction.Commit();
personId = person.Id;
session.Evict(person);
//session.Linq<Person>().Where(p=>p.Id==1);
}
using (session.BeginTransaction())
{
var query=(from user in session.Linq<Person>() select user );
var person = query.First<Person>();
//Assert.AreEqual("Olo", person.FirstName);
//Assert.AreEqual("Bolus", person.LastName);
}
}
using (var session = GetSession())
{
using (var transaction = session.BeginTransaction())
{
// create a couple of Stores each with some Products and Employees
var person = new Person { Name = new Name { First = "Olo", Last = "Bolus" } };
session.SaveOrUpdate(person);
transaction.Commit();
personId = person.Id;
session.Evict(person);
//session.Linq<Person>().Where(p=>p.Id==1);
}
using (session.BeginTransaction())
{
var query = (from user in session.Linq<Person>() where user.Name.First == "Bolus1" select user);
var person = query.First<Person>();
Assert.AreEqual("Olo1", person.Name.First);
Assert.AreEqual("Bolus1", person.Name.Last);
}
}
}
public void FuturesTest()
{
int personid;
using (var session = factory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var person = new Person { Name = new Name { First = "Olo", Last = "Bolus" } };
Console.WriteLine(person.Id);
person.AddCat(new Cat { Name = "Filip" });
person.AddCat(new Cat { Name = "Nick" });
session.Save(person);
personid = person.Id;
transaction.Commit();
}
}
using (var session = factory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var dbPerson = session.CreateCriteria<Person>().
Add(Expression.Eq("Id", personid)).
SetFetchMode("Cats", FetchMode.Join).
Future<Person>();
var catscount = session.CreateCriteria<Cat>()
.SetProjection(Projections.Count(Projections.Id()))
.FutureValue<int>();
transaction.Commit();
Assert.AreEqual(2, dbPerson.First<Person>().Cats.Count);
Assert.AreEqual(2, catscount.Value);
}
}
}
public void CanReadAndSavePersonWithTwoSessions()
{
int personid;
Person dbPerson;
using (var session = factory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var person = new Person { Name = new Name { First = "Olo", Last = "Bolus" } };
personid = person.Id;
Console.WriteLine(person.Id);
person.AddCat(new Cat { Name = "Filip" });
person.AddCat(new Cat { Name = "Nick" });
person.AddCat(new Cat { Name = "Cage" });
session.Save(person);
transaction.Commit();
personid = person.Id;
}
dbPerson = session.Get<Person>(personid);
Assert.AreEqual(3, dbPerson.Cats.Count);
}
dbPerson.Name.Last = "New Name";
using (var session = factory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
session.Update(dbPerson);
transaction.Commit();
}
var dbPerson2 = session.Get<Person>(personid);
Assert.AreEqual(3, dbPerson2.Cats.Count);
Assert.That(dbPerson2.Name.Last,Is.EqualTo("New Name"));
}
}
public void Save(Person person)
{
throw new NotImplementedException();
}