[STAThread]
static void Main(string[] args)
{
string script =
"DROP TABLE DEPT;"+
"CREATE TABLE DEPT ("+
" DEPTNO INT PRIMARY KEY,"+
" DNAME VARCHAR(14),"+
" LOC VARCHAR(13)"+
")WITH OIDS;"+
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+
"SELECT * FROM DEPT";
PgSqlConnection pgConn = new PgSqlConnection(
"host=server;database=test;user id=postgres;");
PgSqlScript pgScript = new PgSqlScript(script,pgConn);
pgScript.Progress += new Devart.Common.ScriptProgressEventHandler(OnProgress);
pgScript.Error += new Devart.Common.ScriptErrorEventHandler(OnError);
pgConn.Open();
pgScript.Execute();
pgConn.Close();
}
static void OnProgress(object sender, Devart.Common.ScriptProgressEventArgs e)
{
Console.WriteLine(e.Text);
Console.WriteLine(" Successfully executed.");
}
static void OnError(object sender, Devart.Common.ScriptErrorEventArgs e)
{
e.Ignore = true;
Console.WriteLine(e.Text);
Console.WriteLine(" Failed.");
}