public void FilterOnOffOn()
{
var c = new Category { Code = "2600", Deleted = true };
SaveCategory(c);
using (ISession s = OpenSession())
{
s.EnableFilter("state").SetParameter("deleted", false);
IList<Category> result =
s.CreateQuery("from Category where Code = :code").SetParameter("code", "2600").List<Category>();
Assert.That(result.Count == 0);
}
using (ISession s = OpenSession())
{
IList<Category> result =
s.CreateQuery("from Category where Code = :code").SetParameter("code", "2600").List<Category>();
Assert.That(result.Count > 0);
}
using (ISession s = OpenSession())
{
s.EnableFilter("state").SetParameter("deleted", true);
IList<Category> result =
s.CreateQuery("from Category where Code = :code").SetParameter("code", "2600").List<Category>();
Assert.That(result.Count > 0);
}
Cleanup();
}
private void SaveCategory(Category c)
{
using (ISession s = OpenSession())
{
using (ITransaction tx = s.BeginTransaction())
{
s.Save(c);
tx.Commit();
}
}
}
public void Bug()
{
var c = new Category { Code = "2600", Deleted = false };
SaveCategory(c);
// exec queries, twice, different session
ExecQuery();
ExecQuery();
// cleanup using filter
using (ISession s = OpenSession())
{
using (ITransaction tx = s.BeginTransaction())
{
s.EnableFilter("state").SetParameter("deleted", false);
s.Delete("from Category");
tx.Commit();
}
}
}