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)
{
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);
}
}
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));
}
}
public MainWindow()
{
InitializeComponent();
var connectionData = new DbConnectionData();
//SQL
connectionData.ServerName = "localhost";
connectionData.Name = "";
connectionData.User = "";
connectionData.Password = "";
connectionData.Instance = ""; //Leave empty for default Instance
//m_dbFactory = new DbFactory(DbType.SQL, connectionData); //Uncomment for SQL
//SQLite
connectionData.Path = Environment.CurrentDirectory;
connectionData.Name = "D_TestApp.db";
//m_dbFactory = new DbFactory(DbType.SQLite, connectionData); //Uncomment for SQLite
//MySQL
connectionData.ServerName = "";
connectionData.Port = "";
connectionData.Name = "";
connectionData.User = "";
connectionData.Password = "";
//m_dbFactory = new DbFactory(DbType.MySQL, connectionData); //Uncomment for MySQL
//Oracle
connectionData.ServerName = "";
connectionData.Port = "";
connectionData.Name = "";
connectionData.User = "";
connectionData.Password = "";
m_dbFactory = new DbFactory(DbType.Oracle, connectionData); //Uncomment for Oracle
#region Init Logger
m_dbFactory.InitLogger("DbFactoryLog");
m_dbFactory.InitNotifyIcon(new NotifyData { Title = "TestApp", NotifyOnError = true, NotifyOnInfo = true });
#endregion
}
