public static T queryToObject <T>(string query, List <addWithValue> _vals) where T : new() { NpgsqlConnection connection = new NpgsqlConnection(RouteConfig.connectString); connection.Open(); NpgsqlCommand command = new NpgsqlCommand(query, connection); for (int i = 0; i < _vals.Count; i++) { command.Parameters.AddWithValue(_vals[i].VAR, _vals[i].VAL); } NpgsqlDataReader dataReader = command.ExecuteReader(); NpgsqlDataAdapter da = new NpgsqlDataAdapter(); DataTable dt = new DataTable(); for (int i = 0; dataReader.Read(); i++) { } dt.Load(dataReader); da.SelectCommand = command; da.Fill(dt); T obj = TableUtils.CreateObjectFromTable <T>(dt); connection.Close(); return(obj); }
public static T queryToObject <T>(string query) where T : new() { NpgsqlConnection connection = new NpgsqlConnection(RouteConfig.connectString); connection.Open(); NpgsqlCommand command = new NpgsqlCommand(query, connection); NpgsqlDataReader dataReader = command.ExecuteReader(); NpgsqlDataAdapter da = new NpgsqlDataAdapter(); DataTable dt = new DataTable(); for (int i = 0; dataReader.Read(); i++) { } dt.Load(dataReader); da.SelectCommand = command; da.Fill(dt); T obj = TableUtils.CreateObjectFromTable <T>(dt); connection.Close(); return(obj); }