public TEntity FindOne(DetachedCriteria criteria)
{
ICriteria executableCriteria =
RepositoryHelper <TEntity> .GetExecutableCriteria(sessionProvider.OpenSession.Session, criteria, null);
return((TEntity)executableCriteria.UniqueResult());
}
public ICollection <TEntity> FindAll(DetachedCriteria criteria, params Order[] orders)
{
ICriteria executableCriteria =
RepositoryHelper <TEntity> .GetExecutableCriteria(sessionProvider.OpenSession.Session, criteria, orders);
return(executableCriteria.List <TEntity>());
}
/// <summary>
/// Counts the number of instances matching the criteria.
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public long Count(DetachedCriteria criteria)
{
ICriteria crit = RepositoryHelper <TEntity> .GetExecutableCriteria(sessionProvider.OpenSession.Session, criteria, null);
crit.SetProjection(Projections.RowCount());
object countMayBe_Int32_Or_Int64_DependingOnDatabase = crit.UniqueResult();
return(Convert.ToInt64(countMayBe_Int32_Or_Int64_DependingOnDatabase));
}
public TEntity FindFirst(DetachedCriteria criteria, params Order[] orders)
{
ICriteria executableCriteria =
RepositoryHelper <TEntity> .GetExecutableCriteria(sessionProvider.OpenSession.Session, criteria, orders);
executableCriteria.SetFirstResult(0);
executableCriteria.SetMaxResults(1);
return((TEntity)executableCriteria.UniqueResult());
}
public ICollection <TEntity> FindAll(DetachedCriteria criteria, int firstResult, int maxResults, params Order[] orders)
{
ICriteria executableCriteria =
RepositoryHelper <TEntity> .GetExecutableCriteria(sessionProvider.OpenSession.Session, criteria, orders);
executableCriteria.SetFirstResult(firstResult);
executableCriteria.SetMaxResults(maxResults);
return(executableCriteria.List <TEntity>());
}