/// <summary>
        /// By default queries the table matching the class name.
        /// This uses your raw SQL so be careful to not create SQL injection holes.
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="pageNumber"></param>
        /// <param name="rowsPerPage"></param>
        /// <param name="conditions"></param>
        /// <param name="orderby"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
        public IEnumerable <T> GetListPaged <T>(int pageNumber, int rowsPerPage, string conditions = null, string orderby = null, object parameters = null)
        {
            SetSimpleCRUD();

            using (var conn = new SqlConnection(_connectionString))
            {
                conn.Open();
                IEnumerable <T> ret = _simpleCRUD.GetListPaged <T>(conn, pageNumber, rowsPerPage, conditions, orderby, parameters);
                conn.Close();
                return(ret);
            }
        }
 public virtual IEnumerable <TModel> GetListPaged(int pageNumber, int rowsPerPage, string conditions, string orderby, object parameters = null, IDbTransaction transaction = null, int?commandTimeout = null)
 {
     return(SimpleCRUD.GetListPaged <TModel>(_connection, pageNumber, rowsPerPage, conditions, orderby, parameters, transaction, commandTimeout));
 }