* OLE DB Provider
using System; using System.Data; using System.Data.OleDb; public class Test { public static void Main(string[] args) { // there is a libgda PostgreSQL provider string connectionString = "Provider=PostgreSQL;" + "Addr=127.0.0.1;" + "Database=test;" + "User ID=postgres;" + "Password=fun2db"; IDbConnection dbcon; dbcon = new OleDbConnection(connectionString); dbcon.Open(); IDbCommand dbcmd = dbcon.CreateCommand(); // requires a table to be created named employee // with columns firstname and lastname // such as, // CREATE TABLE employee ( // firstname varchar(32), // lastname varchar(32)); string sql = "SELECT firstname, lastname " + "FROM employee"; dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { string FirstName = reader["firstname"]; string LastName = reader["lastname"]; Console.WriteLine("Name: " + FirstName + " " + LastName); } // clean up reader.Close(); reader = null; dbcmd.Dispose(); dbcmd = null; dbcon.Close(); dbcon = null; } }
mcs TestExample.cs -r System.Data.dll
mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \ TestExample.cs \ -lib:C:/cygwin/home/MyHome/mono/install/lib \ -r System.Data.dll
mono TestExample.exe