protected override void OnSetUp()
{
using (ISession session = OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
var bobsConnection = new Connection
{
Address = "test.com",
ConnectionType = "http",
PortName = "80"
};
var e1 = new Person
{
Name = "Bob",
Connection = bobsConnection
};
session.Save(e1);
var sallysConnection = new Connection
{
Address = "test.com",
ConnectionType = "http",
};
var e2 = new Person
{
Name = "Sally",
Connection = sallysConnection
};
session.Save(e2);
var cachedNullConnection = new Connection
{
Address = "test.com",
ConnectionType = "http",
};
var cachedNullConnectionPerson = new CachedPerson
{
Name = "CachedNull",
Connection = cachedNullConnection
};
var cachedNotNullConnection = new Connection
{
Address = "test.com",
ConnectionType = "http",
PortName = "port"
};
var cachedNotNullConnectionPerson = new CachedPerson
{
Name = "CachedNotNull",
Connection = cachedNotNullConnection
};
session.Save(cachedNullConnectionPerson);
session.Save(cachedNotNullConnectionPerson);
session.Flush();
transaction.Commit();
session.Evict(typeof(CachedPerson));
}
}
public void QueryOverComponentWithANullProperty()
{
// Broken at the time NH3634 was reported
// Generates the following Rpc(exec sp_executesql)
// SELECT this_.Id as Id0_0_,
// this_.Name as Name0_0_,
// this_.ConnectionType as Connecti3_0_0_,
// this_.Address as Address0_0_,
// this_.PortName as PortName0_0_
// FROM people this_
// WHERE this_.ConnectionType = @p0
// and this_.Address = @p1
// and this_.PortName = @p2
//
// @p0=N'http',@p1=N'test.com',@p2=NULL
using (ISession session = OpenSession())
using (session.BeginTransaction())
{
var componentToCompare = new Connection
{
ConnectionType = "http",
Address = "test.com",
PortName = null
};
var sally = session.QueryOver<Person>()
.Where(p => p.Connection == componentToCompare)
.SingleOrDefault<Person>();
Assert.That(sally.Name, Is.EqualTo("Sally"));
Assert.That(sally.Connection.PortName, Is.Null);
}
}
public void CachedQueryAgainstComponentWithANullPropertyUsingCriteria()
{
var componentToCompare = new Connection
{
ConnectionType = "http",
Address = "test.com",
PortName = null
};
using (ISession session = OpenSession())
using (ITransaction tx = session.BeginTransaction())
{
var cached = session.CreateCriteria<CachedPerson>()
.Add(Restrictions.Eq("Connection", componentToCompare))
.SetCacheable(true)
.UniqueResult<CachedPerson>();
Assert.That(cached.Name, Is.EqualTo("CachedNull"));
Assert.That(cached.Connection.PortName, Is.Null);
using (var dbCommand = session.Connection.CreateCommand())
{
dbCommand.CommandText = "DELETE FROM cachedpeople";
tx.Enlist(dbCommand);
dbCommand.ExecuteNonQuery();
}
tx.Commit();
}
using (ISession session = OpenSession())
using (ITransaction tx = session.BeginTransaction())
{
//Should retreive from cache since we deleted directly from database.
var cached = session.CreateCriteria<CachedPerson>()
.Add(Restrictions.Eq("Connection", componentToCompare))
.SetCacheable(true)
.UniqueResult<CachedPerson>();
Assert.That(cached.Name, Is.EqualTo("CachedNull"));
Assert.That(cached.Connection.PortName, Is.Null);
tx.Commit();
}
}
public void CachedQueryMissesWithDifferentNullComponent()
{
var componentToCompare = new Connection
{
ConnectionType = "http",
Address = "test.com",
PortName = "port"
};
using (ISession session = OpenSession())
using (ITransaction tx = session.BeginTransaction())
{
var cached = session.CreateCriteria<CachedPerson>()
.Add(Restrictions.Eq("Connection", componentToCompare))
.SetCacheable(true)
.UniqueResult<CachedPerson>();
Assert.That(cached.Name, Is.EqualTo("CachedNotNull"));
Assert.That(cached.Connection.PortName, Is.Not.Null);
using (var dbCommand = session.Connection.CreateCommand())
{
dbCommand.CommandText = "DELETE FROM cachedpeople";
tx.Enlist(dbCommand);
dbCommand.ExecuteNonQuery();
}
tx.Commit();
}
componentToCompare.PortName = null;
using (ISession session = OpenSession())
using (ITransaction tx = session.BeginTransaction())
{
//Cache should not return cached entity, because it no longer matches criteria
var cachedPeople = session.CreateCriteria<CachedPerson>()
.Add(Restrictions.Eq("Connection", componentToCompare))
.SetCacheable(true)
.List<CachedPerson>();
Assert.That(cachedPeople, Is.Empty);
tx.Commit();
}
}