public void Refresh()
{
Paper paper;
using (IStatelessSession ss = sessions.OpenStatelessSession())
{
using (ITransaction tx = ss.BeginTransaction())
{
paper = new Paper {Color = "whtie"};
ss.Insert(paper);
tx.Commit();
}
}
using (IStatelessSession ss = sessions.OpenStatelessSession())
{
using (ITransaction tx = ss.BeginTransaction())
{
var p2 = ss.Get<Paper>(paper.Id);
p2.Color = "White";
ss.Update(p2);
tx.Commit();
}
}
using (IStatelessSession ss = sessions.OpenStatelessSession())
{
using (ITransaction tx = ss.BeginTransaction())
{
Assert.AreEqual("whtie", paper.Color);
ss.Refresh(paper);
Assert.AreEqual("White", paper.Color);
ss.Delete(paper);
tx.Commit();
}
}
}
public void HqlBulk()
{
IStatelessSession ss = sessions.OpenStatelessSession();
ITransaction tx = ss.BeginTransaction();
var doc = new Document("blah blah blah", "Blahs");
ss.Insert(doc);
var paper = new Paper {Color = "White"};
ss.Insert(paper);
tx.Commit();
tx = ss.BeginTransaction();
int count =
ss.CreateQuery("update Document set Name = :newName where Name = :oldName").SetString("newName", "Foos").SetString(
"oldName", "Blahs").ExecuteUpdate();
Assert.AreEqual(1, count, "hql-delete on stateless session");
count = ss.CreateQuery("update Paper set Color = :newColor").SetString("newColor", "Goldenrod").ExecuteUpdate();
Assert.AreEqual(1, count, "hql-delete on stateless session");
tx.Commit();
tx = ss.BeginTransaction();
count = ss.CreateQuery("delete Document").ExecuteUpdate();
Assert.AreEqual(1, count, "hql-delete on stateless session");
count = ss.CreateQuery("delete Paper").ExecuteUpdate();
Assert.AreEqual(1, count, "hql-delete on stateless session");
tx.Commit();
ss.Close();
}
public void InitId()
{
Paper paper;
using (IStatelessSession ss = sessions.OpenStatelessSession())
{
ITransaction tx;
using (tx = ss.BeginTransaction())
{
paper = new Paper {Color = "White"};
ss.Insert(paper);
Assert.IsTrue(paper.Id != 0);
tx.Commit();
}
using (tx = ss.BeginTransaction())
{
ss.Delete(ss.Get<Paper>(paper.Id));
tx.Commit();
}
}
}
