■ PostgreSQL 데이터베이스를 사용하는 방법을 보여준다.
▶ Program.cs
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
using System; using Npgsql; namespace TestProject { /// <summary> /// 프로그램 /// </summary> class Program { //////////////////////////////////////////////////////////////////////////////////////////////////// Method ////////////////////////////////////////////////////////////////////////////////////////// Static //////////////////////////////////////////////////////////////////////////////// Private #region 프로그램 시작하기 - Main() /// <summary> /// 프로그램 시작하기 /// </summary> private static void Main() { Console.Title = "PostgreSQL 데이터베이스 사용하기"; string connectionString = "Host=127.0.0.1;Port=5432;Database=testdb;User ID=postgres;Password=1234"; using(NpgsqlConnection connection = new NpgsqlConnection(connectionString)) { try { connection.Open(); using(NpgsqlCommand command = new NpgsqlCommand()) { command.Connection = connection; command.CommandText = "SELECT * FROM student"; using(NpgsqlDataReader reader = command.ExecuteReader()) { while(reader.Read()) { Console.WriteLine ( $"id={reader.GetInt32(0)}|name={reader.GetString(1)}|age={reader.GetFieldValue<int?>(2)}" ); } } } } catch(Exception exception) { Console.WriteLine(exception.ToString()); } } } #endregion } } |
