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();
}
