{
public override IPooledDbConnection CreateConnection (IConnectionPool pool, DatabaseConnectionSettings settings, out string error)
{
SqlConnectionStringBuilder builder = null;
try {
if (settings.UseConnectionString) {
builder = new SqlConnectionStringBuilder (settings.ConnectionString);
} else {
builder = new SqlConnectionStringBuilder ();
builder.InitialCatalog = settings.Database;
if (settings.UseIntegratedSecurity) {
builder.IntegratedSecurity = true;
} else {
builder.UserID = settings.Username;
builder.Password = settings.Password;
}
if (settings.Port == 0) // Don't assign default port
builder.DataSource = settings.Server;
else
builder.DataSource = String.Concat (settings.Server, ",", settings.Port);
//builder.NetworkLibrary = "DBMSSOCN";
}
builder.Pooling = false;
SqlConnection connection = new SqlConnection (builder.ToString ());
connection.Open ();
error = null;
return new SqlServerPooledDbConnection (pool, connection);
} catch (Exception e) {
error = e.Message;
return null;
}
{
public override IPooledDbConnection CreateConnection (IConnectionPool pool,
DatabaseConnectionSettings settings,
out string error)
{
string connStr = null;
try {
if (settings.UseConnectionString) {
connStr = settings.ConnectionString;
} else {
//"Server=Server;Port=1234;Database=Test;Uid=UserName;Pwd=asdasd;"
//Default port is 3306. Enter value -1 to use a named pipe connection.
if (settings.Port > 0)
connStr = String.Format ("Server={0};Port={1};Database={2};Uid={3};Pwd={4};",
settings.Server, settings.Port, settings.Database, settings.Username, settings.Password);
else
connStr = String.Format ("Server={0};Database={2};Uid={3};Pwd={3};",
settings.Server, settings.Database, settings.Username, settings.Password);
}
connStr = SetConnectionStringParameter (connStr, String.Empty, "Pooling", "false");
MySqlConnection connection = new MySqlConnection (connStr);
connection.Open ();
error = null;
return new MySqlPooledDbConnection (pool, connection);
} catch (Exception e) {
error = e.Message;
return null;
}
public override IPooledDbConnection CreateConnection(IConnectionPool pool,
DatabaseConnectionSettings settings,
out string error)
{
string connStr = null;
try {
if (settings.UseConnectionString) {
connStr = settings.ConnectionString;
} else {
//"mongodb://[username:password@]hostname[:port][/[database][?options]]"
//Default port is 27017.
if(!string.IsNullOrEmpty(settings.Username) && !string.IsNullOrEmpty(settings.Password)) {
connStr = String.Format("mongodb://{3}:{4}@{0}:{1}/{2}",
settings.Server, settings.Port, settings.Database, settings.Username, settings.Password);
} else {
connStr = String.Format("mongodb://{0}:{1}/{2}",
settings.Server, settings.Port, settings.Database);
}
}
MongoDbConnection connection = new MongoDbConnection(connStr, settings.Database);
connection.Open();
error = null;
return new MongoDbPooledDbConnection (pool, connection);
} catch (Exception e) {
error = e.Message;
return null;
}
}
{
public override IPooledDbConnection CreateConnection (IConnectionPool pool, DatabaseConnectionSettings settings, out string error)
{
string connStr = null;
try {
if (settings.UseConnectionString) {
connStr = settings.ConnectionString;
} else {
//User ID=root;Password=myPassword;Host=localhost;Port=5432;Database=myDataBase;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;
if (settings.Port > 0)
connStr = String.Format ("User ID={0};Password={1};Host={2};Port={3};Database={4};",
settings.Username, settings.Password, settings.Server, settings.Port, settings.Database);
else
connStr = String.Format ("User ID={0};Password={1};Host={2};Database={3};",
settings.Username, settings.Password, settings.Server, settings.Database);
}
connStr = SetConnectionStringParameter (connStr, String.Empty, "Pooling", "false");
NpgsqlConnection connection = new NpgsqlConnection (connStr);
connection.Open ();
error = null;
return new NpgsqlPooledDbConnection (pool, connection);
} catch (Exception e) {
error = e.Message;
return null;
}
public DatabaseConnectionSettings GetDefaultConnectionSettings ()
{
DatabaseConnectionSettings settings = new DatabaseConnectionSettings ();
settings.ProviderIdentifier = Identifier;
settings.UseConnectionString = true;
return settings;
public DatabaseConnectionSettings GetDefaultConnectionSettings ()
{
DatabaseConnectionSettings settings = new DatabaseConnectionSettings ();
settings.ProviderIdentifier = Identifier;
settings.Port = 1521;
settings.MaxPoolSize = 5;
return settings;
public DatabaseConnectionSettings GetDefaultConnectionSettings ()
{
DatabaseConnectionSettings settings = new DatabaseConnectionSettings ();
settings.ProviderIdentifier = Identifier;
settings.Server = "localhost";
settings.Port = 3306;
settings.Username = "******";
settings.MaxPoolSize = 5;
return settings;
}
public bool ShowEditConnectionDialog (IDbFactory factory,
DatabaseConnectionSettings settings,
out DatabaseConnectionSettings newSettings)
{
DatabaseConnectionSettingsDialog dlg = new DatabaseConnectionSettingsDialog (factory, settings);
bool result = RunDialog (dlg);
if (result)
newSettings = dlg.ConnectionSettings;
else
newSettings = null;
return result;
bool IGuiProvider.ShowEditConnectionDialog(IDbFactory factory, DatabaseConnectionSettings settings, out DatabaseConnectionSettings newSettings)
{
DatabaseConnectionSettingsDialog dlg = new DatabaseConnectionSettingsDialog(factory, settings);
bool result = RunDialog (dlg);
if (result)
newSettings = dlg.ConnectionSettings;
else
newSettings = null;
Console.WriteLine("start edit connection dialog");
return result;
}
public override IPooledDbConnection CreateConnection (IConnectionPool pool, DatabaseConnectionSettings settings, out string error)
{
string connStr = null;
try {
if (settings.UseConnectionString) {
connStr = settings.ConnectionString;
} else {
connStr = String.Concat ("URI=file:", settings.Database);
}
SqliteConnection connection = new SqliteConnection (connStr);
connection.Open ();
error = null;
return new SqlitePooledDbConnection (pool, connection);
} catch (Exception e) {
error = e.Message;
return null;
}
}
{
public override IPooledDbConnection CreateConnection (IConnectionPool pool, DatabaseConnectionSettings settings, out string error)
{
string connStr = null;
try {
if (settings.UseConnectionString)
connStr = settings.ConnectionString;
else
throw new NotSupportedException ();
OdbcConnection connection = new OdbcConnection (connStr);
connection.Open ();
error = null;
return new OdbcPooledDbConnection (pool, connection);
} catch (Exception e) {
error = e.Message;
return null;
}
{
public override IPooledDbConnection CreateConnection (IConnectionPool pool, DatabaseConnectionSettings settings, out string error)
{
string connStr = null;
try {
if (settings.UseConnectionString) {
connStr = settings.ConnectionString;
} else {
//Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;
connStr = String.Format ("Data Source={0};User Id={1};Password={2};Integrated Security=no;",
settings.Database, settings.Username, settings.Password);
}
connStr = SetConnectionStringParameter (connStr, String.Empty, "Pooling", "false");
OracleConnection connection = new OracleConnection (connStr);
connection.Open ();
error = null;
return new OraclePooledDbConnection (pool, connection);
} catch (Exception e) {
error = e.Message;
return null;
}
public void Initialize()
{
DbConnectionSettings = new DatabaseConnectionSettings("vps561493.ovh.net", 8086, "admin", "admin");
_sut = new DatabaseSearchCriteriaRepository(DbConnectionSettings);
}
public bool Generate (DatabaseConnectionSettings connection, string outputType, string outputFile, string language,
string style, string defaultNamespace, string entityBase, string entityAttr,
string membersAttr, string generateTypes, string culture, bool generateSchema,
bool generateTimestamp, bool overrideEqualAndHash, bool extractProcedures, bool pluralize)
{
return SqlMetalServices.Generate (Provider, connection, outputType, outputFile, language, style, defaultNamespace,
entityBase, entityAttr, membersAttr, generateTypes, culture, generateSchema,
generateTimestamp, overrideEqualAndHash, extractProcedures, pluralize);
}
public DaoFactory(DatabaseConnectionSettings settings, ILogger logger)
{
_settings = settings ?? throw new ArgumentException(nameof(settings));
_logger = logger ?? throw new ArgumentException(nameof(logger));
}
//http://www.postgresql.org/docs/8.2/interactive/sql-dropdatabase.html
public override void DropDatabase (DatabaseSchema database)
{
if (String.Compare (database.Name, "template1", true) == 0)
throw new ArgumentOutOfRangeException ("Cannot delete template1 database");
string connStr = null;
// Close the pool, connect to a default DB an delete the other.
DatabaseConnectionSettings newSettings = new DatabaseConnectionSettings(pool.ConnectionContext.ConnectionSettings);
database.SchemaProvider.ConnectionPool.Close ();
database.SchemaProvider.ConnectionPool.ConnectionContext.Refresh ();
pool.Close ();
newSettings.Database = "template1";
if (newSettings.Port > 0)
connStr = String.Format ("User ID={0};Password={1};Host={2};Port={3};Database={4};",
newSettings.Username, newSettings.Password, newSettings.Server,
newSettings.Port, newSettings.Database);
else
connStr = String.Format ("User ID={0};Password={1};Host={2};Database={3};",
newSettings.Username, newSettings.Password,
newSettings.Server, newSettings.Database);
using (NpgsqlConnection conn = new NpgsqlConnection(connStr)) {
conn.Open ();
NpgsqlCommand cmd = new NpgsqlCommand (string.Concat("DROP DATABASE IF EXISTS \"", database.Name, "\";"));
cmd.Connection = conn;
cmd.ExecuteNonQuery ();
conn.Close ();
}
/// <summary>
/// Initializes a new instance of the <see cref="DatabaseVersionRepository" /> class.
/// </summary>
/// <param name="connectionSettings">The connection settings to use.</param>
public DatabaseVersionRepository(DatabaseConnectionSettings connectionSettings)
{
this.connectionSettings = connectionSettings;
}
/// <summary>
/// Initializes a new instance of the <see cref="UserRepository" /> class.
/// </summary>
/// <param name="connectionSettings">The connection settings to use.</param>
public UserRepository(DatabaseConnectionSettings connectionSettings)
{
this.connectionSettings = connectionSettings;
}
/// <summary>
/// Initializes a new instance of the <see cref="BlacklistRepository" /> class.
/// </summary>
/// <param name="connectionSettings">The connection settings to use.</param>
public BlacklistRepository(DatabaseConnectionSettings connectionSettings)
{
this.connectionSettings = connectionSettings;
}
public bool ShowEditConnectionDialog (IDbFactory factory, DatabaseConnectionSettings settings, out DatabaseConnectionSettings newSettings)
{
throw new NotImplementedException ();
public DatabaseConnectionSettings GetDefaultConnectionSettings()
{
DatabaseConnectionSettings settings = new DatabaseConnectionSettings ();
settings.ProviderIdentifier = Identifier;
settings.Server = "localhost";
settings.Port = 27017;
settings.Database = "test";
settings.Username = "";
settings.MaxPoolSize = 5;
Console.WriteLine("Get Default connection Settings");
return settings;
}
public UserGraduateDegreeDao(DatabaseConnectionSettings settings, ILogger logger) : base(settings, logger)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="MqttContext" /> class.
/// </summary>
/// <param name="connectionSettingsAccessor">The connection settings accessor.</param>
public MqttContext(IOptions <DatabaseConnectionSettings> connectionSettingsAccessor)
{
this.connectionSettings = connectionSettingsAccessor.Value;
}
public SqliteDatabaseConnectionSettingsDialog(IDbFactory factory, DatabaseConnectionSettings settings)
: base(factory, settings)
{
}
