public DbFactory(DbType type, DbConnectionData data)
{
DbFactorySettings.Type = type;
switch (type)
{
case DbType.SQL:
//new SQLLibrary.CONNECTION(data);
break;
case DbType.SQLite:
new SQLiteLibrary.CONNECTION(data);
break;
case DbType.MySQL:
//new MySQLLibrary.CONNECTION(data);
break;
case DbType.Oracle:
//new OracleLibrary.CONNECTION(data);
break;
}
DbFactorySettings.Factory = this;
Insert = GetInsertService();
Update = GetUpdateService();
Delete = GetDeleteService();
Check = GetCheckService();
Get = GetGetService();
Execute = GetExecuteService();
}
public CONNECTION(DbConnectionData conData, bool overwriteConData = true)
{
if (overwriteConData)
{
Settings.ConnectionData = new DbConnectionData {
Instance = conData.Instance, Name = conData.Name, Password = conData.Password, Path = conData.Path,
Port = conData.Port, ServerName = conData.ServerName, User = conData.User
}
}
;
if (string.IsNullOrEmpty(conData.Instance))
{
Settings.ConnectionString = string.Format(@"Data Source={0};Initial Catalog={1};User Id={2};Password = {3};",
conData.ServerName, conData.Name, conData.User, conData.Password);
}
else
{
Settings.ConnectionString = string.Format(@"Data Source={1}\{0};Initial Catalog={2};User Id={3};Password = {4};",
conData.Instance, conData.ServerName, conData.Name, conData.User, conData.Password);
}
//Set Addentional Settings
Settings.ThrowExceptions = conData.ThrowExceptions;
}
private void ReadSettings()
{
LogDirectory = GetSetting("LogDirectory");
MasterDatabaseConnectionString =
GetConnectionString("Master", out var masterDatabaseConnectionData);
MasterDatabaseConnectionData = masterDatabaseConnectionData;
SyncReplicaDatabaseConnectionString =
GetConnectionString("Sync", out var syncReplicaDatabaseConnectionData);
SyncReplicaDatabaseConnectionData = syncReplicaDatabaseConnectionData;
}
private DbConnectionData ReadConnectionData(string replicaName)
{
var result = new DbConnectionData
{
Host = GetSetting(replicaName + "_DbHost"),
Port = GetSetting(replicaName + "_DbPort"),
User = GetSetting(replicaName + "_DbUser"),
Pass = GetSetting(replicaName + "_DbPass"),
Name = GetSetting(replicaName + "_DbName")
};
return(result);
}
private string GetConnectionString(string replicaName, out DbConnectionData data)
{
data = ReadConnectionData(replicaName);
var result =
$"Server={data.Host};"
+ $"Database={data.Name};"
+ $"User Id={data.User};"
+ $"Password={data.Pass};"
+ $"Port={data.Port};"
+ "SSL Mode=Prefer;"
+ "Trust Server Certificate=true;"
+ "Server Compatibility Mode=Redshift;"
;
return(result);
}
public CONNECTION(DbConnectionData conData)
{
//Data Source=OraDb;User Id=scott;Password=tiger; lt. Oracle Doku
if (string.IsNullOrEmpty(conData.Instance))
{
Settings.ConnectionString = string.Format(@"Data Source={0};Initial Catalog={1};User Id={2};Password = {3};",
conData.ServerName, conData.Name, conData.User, conData.Password);
}
else
{
Settings.ConnectionString = string.Format(@"Data Source={1}\{0};Initial Catalog={2};User Id={3};Password = {4};",
conData.Instance, conData.ServerName, conData.Name, conData.User, conData.Password);
}
//Set Addentional Settings
Settings.ThrowExceptions = conData.ThrowExceptions;
}
public CONNECTION(DbConnectionData conData)
{
if (string.IsNullOrEmpty(conData.Name))
{
return;
}
if (string.IsNullOrEmpty(conData.Path))
{
Settings.ConnectionString = string.Format("Data Source={0}", conData.Name);
}
else
{
Settings.ConnectionString = string.Format("Data Source={0}", Path.Combine(conData.Path, conData.Name));
}
//Set Addentional Settings
Settings.ThrowExceptions = conData.ThrowExceptions;
}
public MainWindow()
{
InitializeComponent();
m_connectionData = new DbConnectionData();
//SQL
m_connectionData.ServerName = "";
m_connectionData.Name = "TestDb";
m_connectionData.User = "";
m_connectionData.Password = "";
m_connectionData.Instance = ""; //Leave empty for default Instance
m_dbFactory = new DbFactory(DbType.SQL, m_connectionData); //Uncomment for SQL
////SQLite
//m_connectionData.Path = Environment.CurrentDirectory;
//m_connectionData.Name = "D_TestApp.db";
//m_dbFactory = new DbFactory(DbType.SQLite, m_connectionData); //Uncomment for SQLite
////MySQL
//m_connectionData.ServerName = "";
//m_connectionData.Port = "";
//m_connectionData.Name = "";
//m_connectionData.User = "";
//m_connectionData.Password = "";
//m_dbFactory = new DbFactory(DbType.MySQL, m_connectionData); //Uncomment for MySQL
////Oracle
//m_connectionData.ServerName = "";
//m_connectionData.Port = "";
//m_connectionData.Name = "";
//m_connectionData.User = "";
//m_connectionData.Password = "";
//m_dbFactory = new DbFactory(DbType.Oracle, m_connectionData); //Uncomment for Oracle
#region Init Logger
m_dbFactory.InitLogger("DbFactoryLog", debugLevel: DebugLevelConstants.VeryHigh);
m_dbFactory.InitNotifyIcon(new NotifyData {
Title = "TestApp", NotifyOnError = true, NotifyOnInfo = true
});
//LogTester();
#endregion
}
