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 }