Пример #1
0
        public async Task <IEnumerable <e.TestTable> > LoadPage(int offset, int count)
        {
            var sqlParams = new SqlParameter[]
            {
                new SqlParameter("@offset", offset),
                new SqlParameter("@count", count),
            };

            return(await this.Database.SqlQuery <e.TestTable>("TestTable_SelectPage" + sqlParams.AsExecuteString(), sqlParams).ToListAsync());
        }