public void SetDatabaseReader(Project project) { if (project.DatabaseType == DatabaseTypes.SQLServer && databaseSchemaReader == null) { databaseSchemaReader = new SQLServerDatabaseExtractor(); conn = new System.Data.SqlClient.SqlConnection(connectionString); } else if (project.DatabaseType == DatabaseTypes.Access && databaseSchemaReader == null) { databaseSchemaReader = null; } else if (project.DatabaseType == DatabaseTypes.Oracle && databaseSchemaReader == null) { databaseSchemaReader = null; } else if (project.DatabaseType == DatabaseTypes.MySQL && databaseSchemaReader == null) { databaseSchemaReader = null; } }
public void SetConnectionString(Project project,string databaseName) { connectionString = ""; if (project.DatabaseType == DatabaseTypes.SQLServer) { if (project.IsWindowsAuthentication) { connectionString = DataStructure.SQLConn; connectionString = connectionString.Replace("##DS##", project.ServerName); Entities.MetaDataSchema.Database database = Entities.MetaDataSchema.Database.GetByName(project.Databases, databaseName); if (database != null) connectionString = connectionString.Replace("##IC##", database.Name); else connectionString = connectionString.Replace("initial catalog=##IC##", ""); } else { connectionString = DataStructure.SQLPassConn; connectionString = connectionString.Replace("##DS##", project.ServerName); connectionString = connectionString.Replace("##UID##", project.UserName); connectionString = connectionString.Replace("##PASS##", project.Password); if (project.Databases != null) { Entities.MetaDataSchema.Database database = Entities.MetaDataSchema.Database.GetByName(project.Databases, databaseName); if (database != null) connectionString = connectionString.Replace("##IC##", database.Name); else connectionString = connectionString.Replace("initial catalog=##IC##;", ""); } else { connectionString = connectionString.Replace("initial catalog=##IC##;", ""); } } } }
public abstract void GetDatabases(Project project);
public Project Connect(DatabaseTypes type,string userName,string password,string database,string serverName,bool winAuth) { Project project = null; try { project = new Project(); project.DatabaseType = type; project.UserName = userName; project.Password = password; project.ServerName = serverName; project.IsWindowsAuthentication = winAuth; SetDatabaseReader(project); SetConnectionString(project, database); //System.Data.Common.DbConnection conn = null; //if (databaseSchemaReader is SQLServerDatabaseExtractor) //{ // conn = new System.Data.SqlClient.SqlConnection(connectionString); //} //conn.Open(); } catch (Exception ex) { throw ex; } return project; }
public abstract void GetFunctions(Project project);
public abstract void GetStoredProcedures(Project project);
public abstract void GetViews(Project project);
public abstract void GetTableRelations(Project project);
public abstract void GetTables(Project project);