static void Main(string[] args)
{
PgSqlConnectionStringBuilder pgCSB = new PgSqlConnectionStringBuilder();
pgCSB.Host = "192.168.1.78";
pgCSB.Port = 5432;
pgCSB.UserId = "postgres";
pgCSB.Password = "******";
pgCSB.Database = "tms2";
pgCSB.MaxPoolSize = 150;
pgCSB.ConnectionTimeout = 30;
pgCSB.Unicode = true;
PgSqlConnection pgSqlConnection = new PgSqlConnection(pgCSB.ConnectionString);
try
{
pgSqlConnection.Open();
Count(pgSqlConnection);
}
catch (PgSqlException ex)
{
Console.WriteLine("Exception occurs: {0}", ex.Error);
}
finally
{
pgSqlConnection.Close();
Console.ReadLine();
}
}
private string GetConnection(string databaseName = "customer_test")
{
var connectionStringBuilder = new PgSqlConnectionStringBuilder(DbConnectionString)
{
Database = databaseName,
Pooling = true
};
return(connectionStringBuilder.ConnectionString);
}
public SqlClient(string ip, string port, string user_id, string password, string database)
{
pgCSB = new PgSqlConnectionStringBuilder();
pgCSB.Host = ip;
pgCSB.Port = int.Parse(port);
pgCSB.UserId = user_id;
pgCSB.Password = password;
pgCSB.Database = database;
pgCSB.Unicode = true;
SiAuto.Si.Enabled = true;
SiAuto.Si.Level = Level.Debug;
SiAuto.Si.Connections = @"file(filename=""" +
Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) +
"\\sqllog.sil\",rotate=weekly,append=true,maxparts=5,maxsize=500MB)";
}
protected PostgresDotConnectSqlDatabaseContext(DataAccessModel model, SqlDialect sqlDialect, SqlDataTypeProvider sqlDataTypeProvider, SqlQueryFormatterManager sqlQueryFormatterManager, PostgresDotConnectSqlDatabaseContextInfo contextInfo)
: base(model, sqlDialect, sqlDataTypeProvider, sqlQueryFormatterManager, contextInfo.DatabaseName, contextInfo)
{
if (!string.IsNullOrEmpty(contextInfo.ConnectionString))
{
this.ConnectionString = contextInfo.ConnectionString;
this.ServerConnectionString = Regex.Replace(this.ConnectionString, @"Database\s*\=[^;$]+[;$]", "");
}
else
{
this.Host = contextInfo.ServerName;
this.UserId = contextInfo.UserId;
this.Password = contextInfo.Password;
this.Port = contextInfo.Port;
var connectionStringBuilder = new PgSqlConnectionStringBuilder
{
Host = contextInfo.ServerName,
UserId = contextInfo.UserId,
Password = contextInfo.Password,
Port = contextInfo.Port,
Pooling = contextInfo.Pooling,
Enlist = false,
Charset = "UTF8",
Unicode = true,
MaxPoolSize = contextInfo.MaxPoolSize,
UnpreparedExecute = contextInfo.UnpreparedExecute
};
if (contextInfo.ConnectionTimeout != null)
{
connectionStringBuilder.ConnectionTimeout = contextInfo.ConnectionTimeout.Value;
}
if (contextInfo.ConnectionCommandTimeout != null)
{
connectionStringBuilder.DefaultCommandTimeout = contextInfo.ConnectionCommandTimeout.Value;
}
this.ServerConnectionString = connectionStringBuilder.ConnectionString;
connectionStringBuilder.Database = contextInfo.DatabaseName;
this.ConnectionString = connectionStringBuilder.ConnectionString;
}
this.SchemaManager = new PostgresSqlDatabaseSchemaManager(this);
}
protected PostgresDotConnectSqlDatabaseContext(DataAccessModel model, SqlDialect sqlDialect, SqlDataTypeProvider sqlDataTypeProvider, SqlQueryFormatterManager sqlQueryFormatterManager, PostgresDotConnectSqlDatabaseContextInfo contextInfo)
: base(model, sqlDialect, sqlDataTypeProvider, sqlQueryFormatterManager, contextInfo.DatabaseName, contextInfo)
{
if (!string.IsNullOrEmpty(contextInfo.ConnectionString))
{
this.ConnectionString = contextInfo.ConnectionString;
this.ServerConnectionString = Regex.Replace(this.ConnectionString, @"Database\s*\=[^;$]+[;$]", "");
}
else
{
this.Host = contextInfo.ServerName;
this.UserId = contextInfo.UserId;
this.Password = contextInfo.Password;
this.Port = contextInfo.Port;
var connectionStringBuilder = new PgSqlConnectionStringBuilder
{
Host = contextInfo.ServerName,
UserId = contextInfo.UserId,
Password = contextInfo.Password,
Port = contextInfo.Port,
Pooling = contextInfo.Pooling,
Enlist = false,
Charset = "UTF8",
Unicode = true,
MaxPoolSize = contextInfo.MaxPoolSize,
UnpreparedExecute = contextInfo.UnpreparedExecute
};
if (contextInfo.ConnectionTimeout != null)
{
connectionStringBuilder.ConnectionTimeout = contextInfo.ConnectionTimeout.Value;
}
if (contextInfo.ConnectionCommandTimeout != null)
{
connectionStringBuilder.DefaultCommandTimeout = contextInfo.ConnectionCommandTimeout.Value;
}
this.ServerConnectionString = connectionStringBuilder.ConnectionString;
connectionStringBuilder.Database = contextInfo.DatabaseName;
this.ConnectionString = connectionStringBuilder.ConnectionString;
}
this.SchemaManager = new PostgresSqlDatabaseSchemaManager(this);
}
public SqlClient(string ip, string port, string user_id, string password, string database, string Pooling, string MinPoolSize, string MaxPoolSize, string ConnectionLifetime)
{
PgSqlConnectionStringBuilder pgCSB = new PgSqlConnectionStringBuilder();
pgCSB.Host = ip;
pgCSB.Port = int.Parse(port);
pgCSB.UserId = user_id;
pgCSB.Password = password;
pgCSB.Database = database;
pgCSB.Pooling = bool.Parse(Pooling);
pgCSB.MinPoolSize = int.Parse(MinPoolSize);
pgCSB.MaxPoolSize = int.Parse(MaxPoolSize);
pgCSB.ConnectionLifetime = int.Parse(ConnectionLifetime);;
pgCSB.Unicode = true;
pgSqlConnection = new PgSqlConnection(pgCSB.ConnectionString);
}
