Advertisement
Wawrzyn

NpgSQL C#

Oct 24th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.41 KB | None | 0 0
  1.             var builder = new NpgsqlConnectionStringBuilder
  2.             {
  3.                 Username = "dyncedlninyqrz",
  4.             Password = "5e92c4cc539d3c48d6c542f3e3a56883106440bffe1c2693c1bff69062070732",
  5.             Host = "ec2-46-51-184-229.eu-west-1.compute.amazonaws.com",
  6.             Port = 5432,
  7.             Database = "d86q4npnbodu6d",
  8.             SslMode = SslMode.Require,
  9.             TrustServerCertificate = true
  10.             };
  11.  
  12.             using (var conn = new NpgsqlConnection(builder.ConnectionString))
  13.             {
  14.                 conn.Open();
  15.  
  16.                 using (var cmd = new NpgsqlCommand())
  17.                 {
  18.                     cmd.Connection = conn;
  19.                     cmd.CommandText = "CREATE TABLE XYZ (A INT, B INT)";
  20.                     cmd.ExecuteNonQuery();
  21.                 }
  22.                 using (var cmd = new NpgsqlCommand())
  23.                 {
  24.                     cmd.Connection = conn;
  25.                     cmd.CommandText = "INSERT INTO XYZ VALUES (2, 3), (4, 3)";
  26.                     cmd.ExecuteNonQuery();
  27.                 }
  28.  
  29.                 using (var cmd = new NpgsqlCommand("SELECT * FROM XYZ", conn))
  30.                 using (var reader = cmd.ExecuteReader())
  31.                 {
  32.                     while (reader.Read())
  33.                         Console.WriteLine(reader.GetInt32(0) + " " + reader.GetInt32(1));
  34.                 }
  35.             }
  36.             Console.ReadKey();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement