Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var builder = new NpgsqlConnectionStringBuilder
- {
- Username = "dyncedlninyqrz",
- Password = "5e92c4cc539d3c48d6c542f3e3a56883106440bffe1c2693c1bff69062070732",
- Host = "ec2-46-51-184-229.eu-west-1.compute.amazonaws.com",
- Port = 5432,
- Database = "d86q4npnbodu6d",
- SslMode = SslMode.Require,
- TrustServerCertificate = true
- };
- using (var conn = new NpgsqlConnection(builder.ConnectionString))
- {
- conn.Open();
- using (var cmd = new NpgsqlCommand())
- {
- cmd.Connection = conn;
- cmd.CommandText = "CREATE TABLE XYZ (A INT, B INT)";
- cmd.ExecuteNonQuery();
- }
- using (var cmd = new NpgsqlCommand())
- {
- cmd.Connection = conn;
- cmd.CommandText = "INSERT INTO XYZ VALUES (2, 3), (4, 3)";
- cmd.ExecuteNonQuery();
- }
- using (var cmd = new NpgsqlCommand("SELECT * FROM XYZ", conn))
- using (var reader = cmd.ExecuteReader())
- {
- while (reader.Read())
- Console.WriteLine(reader.GetInt32(0) + " " + reader.GetInt32(1));
- }
- }
- Console.ReadKey();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement