Named queries

01-upsert.cs

using (var session = database.BeginSession())
{
    session.Advanced.UpsertNamedQuery<Customer>("CustomersViaSP", qb => qb.Where(c =>
        c.CustomerNo >= default(int)
        && c.CustomerNo <= default(int)
        && c.DeliveryAddress.Street == string.Empty));
}

02-consumeIt.cs

using (var session = database.BeginSession())
{
    var result = session.Advanced.NamedQuery<Customer>("CustomersViaSP", c =>
                     c.CustomerNo >= 500
                     && c.CustomerNo <= 550
                     && c.DeliveryAddress.Street == "Some street"));
}