Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select count(*) from
- (Select e.ID,e.Name from Object as e where...)
- select count(*) from Object e where e = (Select distinct e.ID,e.Name from ...)
- var session = GetSession();
- var criteria = session.CreateCriteria(typeof(Order))
- .Add(Restrictions.Eq("Product", product))
- .SetProjection(Projections.CountDistinct("Price"));
- return (int) criteria.UniqueResult();
- public IList GetOrders(int pageindex, int pagesize)
- {
- IList results = session.CreateMultiQuery()
- .Add(session.CreateQuery("from Orders o").SetFirstResult(pageindex).SetMaxResults(pagesize))
- .Add(session.CreateQuery("select count(*) from Orders o"))
- .List();
- return results;
- }
- [DataObjectMethod(DataObjectMethodType.Select)]
- public DataTable GetOrders(int startRowIndex, int maximumRows)
- {
- IList result = dao.GetOrders(startRowIndex, maximumRows);
- _count = Convert.ToInt32(((IList)result[1])[0]);
- return DataTableFromIList((IList)result[0]); //Basically creates a DataTable from the IList of Orders
- }
- IList results = session.CreateMultiQuery()
- .Add(session.CreateQuery("from Orders o").SetFirstResult(pageindex).SetMaxResults(pagesize))
- .Add(session.CreateQuery("select count(distinct e.Id) from Orders o where..."))
- .List();
- return results;
- public IList GetOrders(int pageindex, int pagesize, out int total)
- {
- var results = session.CreateQuery().Add(session.CreateQuery("from Orders o").SetFirstResult(pageindex).SetMaxResults(pagesize));
- var wCriteriaCount = (ICriteria)results.Clone());
- wCriteriaCount.SetProjection(Projections.RowCount());
- total = Convert.ToInt32(wCriteriaCount.UniqueResult());
- return results.List();
- }
- int count = session.QueryOver<Orders>().RowCount();
Add Comment
Please, Sign In to add comment