Advertisement
mosmondor

Untitled

Aug 21st, 2013
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.75 KB | None | 0 0
  1. public List<GenericIdName> GetProducts()
  2. {
  3.     return ListFetcher<GenericIdName>("select * from products", dr => new GenericIdName { Id = GetGuid(dr, "id"), Name = GetString(dr, "product_name") });
  4. }
  5. public delegate TResult Func<T, TResult>(T t);
  6. private List<T> ListFetcher<T>(string Query, Func<MySqlDataReader, T> param)
  7. {
  8.     using (MySqlConnection conn = new MySqlConnection(_connectionString))
  9.     {
  10.         conn.Open();
  11.         MySqlCommand c = conn.CreateCommand();
  12.         c.CommandText = Query;
  13.         List<T> retval = new List<T>();
  14.         using (MySqlDataReader dr = c.ExecuteReader())
  15.         {
  16.             while (dr.Read())
  17.             {
  18.                 retval.Add(param(dr));
  19.             }
  20.         }
  21.         return retval;
  22.     }
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement