Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<GenericIdName> GetProducts()
- {
- return ListFetcher<GenericIdName>("select * from products", dr => new GenericIdName { Id = GetGuid(dr, "id"), Name = GetString(dr, "product_name") });
- }
- public delegate TResult Func<T, TResult>(T t);
- private List<T> ListFetcher<T>(string Query, Func<MySqlDataReader, T> param)
- {
- using (MySqlConnection conn = new MySqlConnection(_connectionString))
- {
- conn.Open();
- MySqlCommand c = conn.CreateCommand();
- c.CommandText = Query;
- List<T> retval = new List<T>();
- using (MySqlDataReader dr = c.ExecuteReader())
- {
- while (dr.Read())
- {
- retval.Add(param(dr));
- }
- }
- return retval;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement