public static SqlScriptBuilderBase CreateSqlBuilder(DbsDataConfig node) { if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_ODBC_MSSQL || node.DataType() == SoftwareDataKeys.DATA_PROVIDER_ODBC_IMSSQL) { return(new ScriptBuilderMsSql(node) as SqlScriptBuilderBase); } else if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_JET3) { return(new ScriptBuilderMsJet(node) as SqlScriptBuilderBase); } else if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_SQLITE) { return(new ScriptBuilderSqlite(node) as SqlScriptBuilderBase); } else { throw new NotImplementedException(); } }
public static SqlBaseAdapter CreateSqlAdapter(DbsDataConfig node) { #if WINDOWS_API if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_ODBC_MSSQL || node.DataType() == SoftwareDataKeys.DATA_PROVIDER_ODBC_IMSSQL) { return(new SqlMsSqlAdapter(node) as SqlBaseAdapter); } else if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_JET3) { return(new SqlMsJetAdapter(node) as SqlBaseAdapter); } else if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_SQLITE) { return(new SqlSqliteAdapter(node) as SqlBaseAdapter); } else { throw new NotImplementedException(); } #else return(null); #endif }
public ScriptBuilderMsSql(DbsDataConfig dataParams) : base(dataParams) { this.PlatformType = DBPlatform.DATA_PROVIDER_ODBC_MSSQL; }
protected abstract string GetConnectString(DbsDataConfig node);
public SqlBaseAdapter(DbsDataConfig node) { m_platformType = node.DataType(); m_databaseName = node.DbsFileName; }
public ScriptExecutor(string outputFilePath, string infoFileName, string codeFileName, DbsDataConfig targetNode) { m_InfoFileName = infoFileName; m_InfoFilePath = System.IO.Path.Combine(outputFilePath, infoFileName); m_InfoWriter = File.CreateText(m_InfoFilePath); m_CodeFileName = codeFileName; m_CodeFilePath = System.IO.Path.Combine(outputFilePath, codeFileName); m_CodeWriter = File.CreateText(m_CodeFilePath); m_TargetAdapter = SqlAdapterFactory.CreateSqlAdapter(targetNode); try { m_TargetAdapter.CreateDatabase(); m_TargetAdapter.CreateConnection(); m_TargetAdapter.OpenConnection(); } catch (Exception ex) { WriteInfoLine("Database Exception: {0}", ex.ToString()); } }
public SqlScriptBuilderBase(DbsDataConfig dataParams) { this.m_strOwnerName = dataParams.OwnrName(); this.m_strUsersName = dataParams.UserName(); }
public ScriptBuilderSqlite(DbsDataConfig dataParams) : base(dataParams) { this.PlatformType = DBPlatform.DATA_PROVIDER_SQLITE; }
public ScriptBuilderMsJet(DbsDataConfig dataParams) : base(dataParams) { this.PlatformType = DBPlatform.DATA_PROVIDER_JET35; }