public void ExecuteNonQuery(string sql) { var connectioStringProvider = new ConnectionStringProvider(); var connection = new NpgsqlConnection(connectioStringProvider.GetConnectionString()); connection.Open(); var command = new NpgsqlCommand(sql, connection); command.ExecuteNonQuery(); connection.Close(); }
public void Consultar(string identificador) { var connectioStringProvider = new ConnectionStringProvider(); var connection = new NpgsqlConnection(connectioStringProvider.GetConnectionString()); List <object> lista = new List <object>(); var command = new NpgsqlCommand("SELECT nombre FROM hotel", connection); NpgsqlDataReader dr = command.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { lista.Add(dr.GetString(0)); lista.Add(dr.GetString(1)); lista.Add(dr.GetString(2)); lista.Add(dr.GetString(3)); lista.Add(dr.GetString(4)); lista.Add(dr.GetString(5)); } } connection.Close(); }