public void NamedQuery_WhenStoredProcedureWithArgsHasResult_ReturnsItems()
{
IList<ItemForNamedQueries> refetched;
using (var uow = Database.CreateUnitOfWork())
{
var query = new NamedQuery(ProcedureName);
query.Add(new QueryParameter("minId", QueryForMinId), new QueryParameter("maxId", QueryForMaxId));
refetched = uow.NamedQuery<ItemForNamedQueries>(query).ToList();
}
Assert.AreEqual(4, refetched.Count());
CustomAssert.AreValueEqual(_items[2], refetched[0]);
CustomAssert.AreValueEqual(_items[5], refetched[3]);
}
public void NamedQueryAsJson_WhenStoredProcedureWithArgsHasResult_ReturnsItems()
{
IList<string > refetchedJson;
using (var uow = Database.CreateUnitOfWork())
{
var query = new NamedQuery(ProcedureName);
query.Add(new QueryParameter("minId", QueryForMinId), new QueryParameter("maxId", QueryForMaxId));
refetchedJson = uow.NamedQueryAsJson<ItemForNamedQueries>(query).ToList();
}
Assert.AreEqual(4, refetchedJson.Count());
Assert.AreEqual("{\"Id\":3,\"SortOrder\":3}", refetchedJson[0]);
Assert.AreEqual("{\"Id\":6,\"SortOrder\":6}", refetchedJson[3]);
}
public void NamedQuery_WhenStoredProcedureHasNoResult_NonNullEmptyResult()
{
var minIdOutsideScope = _items.Count + 1;
var maxIdOutsideScope = minIdOutsideScope;
IList<ItemForNamedQueries> refetched;
using (var uow = Database.CreateUnitOfWork())
{
var query = new NamedQuery(ProcedureName);
query.Add(new QueryParameter("minId", minIdOutsideScope), new QueryParameter("maxId", maxIdOutsideScope));
refetched = uow.NamedQuery<ItemForNamedQueries>(query).ToList();
}
Assert.IsNotNull(refetched);
Assert.AreEqual(0, refetched.Count());
}
private static int GetCustomersViaSpRaw(ISisoDatabase database, int customerNoFrom, int customerNoTo)
{
var d = new DateTime(2012, 1, 1);
using (var session = database.BeginSession())
{
var q = new NamedQuery("CustomersViaSP");
q.Add(new DacParameter("p0", 10));
q.Add(new DacParameter("p1", true));
q.Add(new DacParameter("p2", d));
q.Add(new DacParameter("p3", customerNoFrom));
q.Add(new DacParameter("p4", customerNoTo));
q.Add(new DacParameter("p5", "The delivery street #544"));
return session.Advanced.NamedQuery<Customer>(q).ToArray().Length;
}
}