public void Hql()
{
// insert the new objects
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
ClassWithCompositeId theClass = new ClassWithCompositeId(id);
theClass.OneProperty = 5;
ClassWithCompositeId theSecondClass = new ClassWithCompositeId(secondId);
theSecondClass.OneProperty = 10;
s.Save(theClass);
s.Save(theSecondClass);
t.Commit();
}
using (ISession s2 = OpenSession())
{
IQuery hql = s2.CreateQuery("from ClassWithCompositeId as cwid where cwid.Id.KeyString = :keyString");
hql.SetString("keyString", id.KeyString);
IList results = hql.List();
Assert.AreEqual(1, results.Count);
}
}
public void Criteria()
{
Id id = new Id("stringKey", 3, firstDateTime);
ClassWithCompositeId cId = new ClassWithCompositeId(id);
cId.OneProperty = 5;
// add the new instance to the session so I have something to get results
// back for
using (ISession s = OpenSession())
{
s.Save(cId);
s.Flush();
}
using (ISession s = OpenSession())
{
ICriteria c = s.CreateCriteria(typeof(ClassWithCompositeId));
c.Add(Expression.Eq("Id", id));
// right now just want to see if the Criteria is valid
IList results = c.List();
Assert.AreEqual(1, results.Count);
}
}
public void QueryOverOrderByAndWhereWithIdProjectionDoesntThrow()
{
// insert the new objects
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
ClassWithCompositeId theClass = new ClassWithCompositeId(id);
theClass.OneProperty = 5;
ClassWithCompositeId theSecondClass = new ClassWithCompositeId(secondId);
theSecondClass.OneProperty = 10;
s.Save(theClass);
s.Save(theSecondClass);
t.Commit();
}
using (ISession s = OpenSession())
{
var results = s.QueryOver <ClassWithCompositeId>()
.Select(Projections.Id())
.Where(Restrictions.Eq(Projections.Id(), id))
.OrderBy(Projections.Id()).Desc.List <Id>();
Assert.That(results.Count, Is.EqualTo(1));
}
}
public void TestSimpleCRUD()
{
ClassWithCompositeId theClass;
ClassWithCompositeId theSecondClass;
// insert the new objects
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
theClass = new ClassWithCompositeId(id);
theClass.OneProperty = 5;
theSecondClass = new ClassWithCompositeId(secondId);
theSecondClass.OneProperty = 10;
s.Save(theClass);
s.Save(theSecondClass);
t.Commit();
}
// verify they were inserted and test the SELECT
ClassWithCompositeId theClass2;
ClassWithCompositeId theSecondClass2;
using (ISession s2 = OpenSession())
using (ITransaction t2 = s2.BeginTransaction())
{
theClass2 = (ClassWithCompositeId)s2.Load(typeof(ClassWithCompositeId), id);
Assert.AreEqual(id, theClass2.Id);
IList results2 = s2.CreateCriteria(typeof(ClassWithCompositeId))
.Add(Expression.Eq("Id", secondId))
.List();
Assert.AreEqual(1, results2.Count);
theSecondClass2 = (ClassWithCompositeId)results2[0];
ClassWithCompositeId theClass2Copy = (ClassWithCompositeId)s2.Load(typeof(ClassWithCompositeId), id);
// verify the same results through Criteria & Load were achieved
Assert.AreSame(theClass2, theClass2Copy);
// compare them to the objects created in the first session
Assert.AreEqual(theClass.Id, theClass2.Id);
Assert.AreEqual(theClass.OneProperty, theClass2.OneProperty);
Assert.AreEqual(theSecondClass.Id, theSecondClass2.Id);
Assert.AreEqual(theSecondClass.OneProperty, theSecondClass2.OneProperty);
// test the update functionallity
theClass2.OneProperty = 6;
theSecondClass2.OneProperty = 11;
s2.Update(theClass2);
s2.Update(theSecondClass2);
t2.Commit();
}
// lets verify the update went through
using (ISession s3 = OpenSession())
using (ITransaction t3 = s3.BeginTransaction())
{
ClassWithCompositeId theClass3 = (ClassWithCompositeId)s3.Load(typeof(ClassWithCompositeId), id);
ClassWithCompositeId theSecondClass3 = (ClassWithCompositeId)s3.Load(typeof(ClassWithCompositeId), secondId);
// check the update properties
Assert.AreEqual(theClass3.OneProperty, theClass2.OneProperty);
Assert.AreEqual(theSecondClass3.OneProperty, theSecondClass2.OneProperty);
// test the delete method
s3.Delete(theClass3);
s3.Delete(theSecondClass3);
t3.Commit();
}
// lets verify the delete went through
using (ISession s4 = OpenSession())
{
try
{
ClassWithCompositeId theClass4 = (ClassWithCompositeId)s4.Load(typeof(ClassWithCompositeId), id);
}
catch (ObjectNotFoundException)
{
// I expect this to be thrown because the object no longer exists...
}
IList results = s4.CreateCriteria(typeof(ClassWithCompositeId))
.Add(Expression.Eq("Id", secondId))
.List();
Assert.AreEqual(0, results.Count);
}
}
public void TestSimpleCRUD()
{
// insert the new objects
ISession s = OpenSession();
ITransaction t = s.BeginTransaction();
ClassWithCompositeId theClass = new ClassWithCompositeId(id);
theClass.OneProperty = 5;
ClassWithCompositeId theSecondClass = new ClassWithCompositeId(secondId);
theSecondClass.OneProperty = 10;
s.Save(theClass);
s.Save(theSecondClass);
t.Commit();
s.Close();
// verify they were inserted and test the SELECT
ISession s2 = OpenSession();
ITransaction t2 = s2.BeginTransaction();
ClassWithCompositeId theClass2 = (ClassWithCompositeId)s2.Load(typeof(ClassWithCompositeId), id);
Assert.AreEqual( id, theClass2.Id );
IList results2 = s2.CreateCriteria(typeof(ClassWithCompositeId))
.Add(Expression.Expression.Eq("Id", secondId))
.List();
Assert.AreEqual(1, results2.Count);
ClassWithCompositeId theSecondClass2 = (ClassWithCompositeId)results2[0];
ClassWithCompositeId theClass2Copy = (ClassWithCompositeId)s2.Load(typeof(ClassWithCompositeId), id);
// verify the same results through Criteria & Load were achieved
Assert.AreSame(theClass2, theClass2Copy);
// compare them to the objects created in the first session
Assert.AreEqual(theClass.Id, theClass2.Id);
Assert.AreEqual(theClass.OneProperty, theClass2.OneProperty);
Assert.AreEqual(theSecondClass.Id, theSecondClass2.Id);
Assert.AreEqual(theSecondClass.OneProperty, theSecondClass2.OneProperty);
// test the update functionallity
theClass2.OneProperty = 6;
theSecondClass2.OneProperty = 11;
s2.Update(theClass2);
s2.Update(theSecondClass2);
t2.Commit();
s2.Close();
// lets verify the update went through
ISession s3 = OpenSession();
ITransaction t3 = s3.BeginTransaction();
ClassWithCompositeId theClass3 = (ClassWithCompositeId)s3.Load(typeof(ClassWithCompositeId), id);
ClassWithCompositeId theSecondClass3 = (ClassWithCompositeId)s3.Load(typeof(ClassWithCompositeId), secondId);
// check the update properties
Assert.AreEqual(theClass3.OneProperty, theClass2.OneProperty);
Assert.AreEqual(theSecondClass3.OneProperty, theSecondClass2.OneProperty);
// test the delete method
s3.Delete(theClass3);
s3.Delete(theSecondClass3);
t3.Commit();
s3.Close();
// lets verify the delete went through
ISession s4 = OpenSession();
try
{
ClassWithCompositeId theClass4 = (ClassWithCompositeId)s4.Load(typeof(ClassWithCompositeId), id);
}
catch(ObjectNotFoundException onfe)
{
// I expect this to be thrown because the object no longer exists...
Assert.IsNotNull(onfe); //getting ride of 'onfe' is never used compile warning
}
IList results = s4.CreateCriteria(typeof(ClassWithCompositeId))
.Add(Expression.Expression.Eq("Id", secondId))
.List();
Assert.AreEqual(0, results.Count);
s4.Close();
}
public void Hql()
{
// insert the new objects
ISession s = OpenSession();
ITransaction t = s.BeginTransaction();
ClassWithCompositeId theClass = new ClassWithCompositeId(id);
theClass.OneProperty = 5;
ClassWithCompositeId theSecondClass = new ClassWithCompositeId(secondId);
theSecondClass.OneProperty = 10;
s.Save(theClass);
s.Save(theSecondClass);
t.Commit();
s.Close();
ISession s2 = OpenSession();
IQuery hql = s2.CreateQuery("from ClassWithCompositeId as cwid where cwid.Id.KeyString = :keyString");
hql.SetString("keyString", id.KeyString);
IList results = hql.List();
Assert.AreEqual(1, results.Count);
s2.Close();
}
public void Criteria()
{
Id id = new Id("stringKey", 3, firstDateTime);
ClassWithCompositeId cId = new ClassWithCompositeId(id);
cId.OneProperty = 5;
// add the new instance to the session so I have something to get results
// back for
ISession s = OpenSession();
s.Save(cId);
s.Flush();
s.Close();
s = OpenSession();
ICriteria c = s.CreateCriteria(typeof(ClassWithCompositeId));
c.Add( Expression.Expression.Eq("Id", id) );
// right now just want to see if the Criteria is valid
IList results = c.List();
Assert.AreEqual(1, results.Count);
s.Close();
}
