private async Task <int> GetCatalogRecordCount(AggregatedConditionDto condition, string spName) { using (var connection = new SqlConnection(ConnectionString)) { var xml = condition.Serialize(); var result = await connection.ExecuteScalarAsync <int>(spName, new { SearchConditionXml = xml, LanguageID = condition.Language }, commandType : CommandType.StoredProcedure); return(result); } }
private async Task <IEnumerable <T> > GetCatalogItems <T>(AggregatedConditionDto condition, string spName) { var xml = condition.Serialize(); using (var connection = new SqlConnection(ConnectionString)) { var result = await connection.QueryAsync <T>(spName, new { SearchConditionXml = xml, LanguageID = condition.Language, intStart = condition.PageNumber * condition.PageSize, intCount = condition.PageSize }, commandType : CommandType.StoredProcedure); return(result); } }