public static List <ItemDao> GetTop100Items() { List <ItemDao> items = new List <ItemDao>(100); SqlResultMapper mapper = new SqlResultMapper(connectionString); Action <System.Data.IDataReader> map = r => { var item = new ItemDao(); item.ItemId = r.GetInt32(r.GetOrdinalOf("ItemID")); item.PartNumber = r.GetString(r.GetOrdinalOf("PartNumber")); item.ItemName = r.GetString(r.GetOrdinalOf("ItemName")); item.Description = r.GetString(r.GetOrdinalOf("Description")); items.Add(item); }; mapper.MapQueryResultsAsync(new SqlQuery("Select top 100 * from dbo.Item"), map, () => items).Wait(); return(items); }
public static void ExecuteStoredProc() { List <ItemDao> items = new List <ItemDao>(100); var sqlQuery = new SqlQuery(); sqlQuery.Query = "GetItem"; sqlQuery.Type = CommandType.StoredProcedure; sqlQuery.Parameters.Add(new SqlParameter("@PartNumber", "FQC-10070")); SqlResultMapper mapper = new SqlResultMapper(connectionString); Action <System.Data.IDataReader> map = r => { var item = new ItemDao(); item.ItemId = r.GetInt32(r.GetOrdinalOf("ItemID")); item.PartNumber = r.GetString(r.GetOrdinalOf("PartNumber")); item.ItemName = r.GetString(r.GetOrdinalOf("ItemName")); item.Description = r.GetString(r.GetOrdinalOf("Description")); items.Add(item); }; mapper.MapQueryResultsAsync(sqlQuery, map, () => items).Wait(); }