public override IList <DataBaseEntity> GetDataBases(ServiceSite site) { IList <DataBaseEntity> list = null; using (MySqlConnection connection = new MySqlConnection(site.DbConnectionStringBuilder.ConnectionString)) { connection.Open(); DataTable databases = connection.GetSchema(SqlClientMetaDataCollectionNames.Databases, new string[] { null }); if (databases != null && databases.Rows.Count > 0) { list = new List <DataBaseEntity>(); foreach (DataRow database in databases.Rows) { string name = (string)database["database_name"]; MySqlConnectionStringBuilder con = new MySqlConnectionStringBuilder(site.DbConnectionStringBuilder.ConnectionString); con.Database = name; DataBaseEntity db = new DataBaseEntity(con, name); db.Service = site; list.Add(db); } } } return(list); }
public static ServiceSite NewInstance(DbConnectionStringBuilder connectionstringbuilder, string service) { site = new ServiceSite(connectionstringbuilder, service); return(site); }
public abstract IList <DataBaseEntity> GetDataBases(ServiceSite site);
public override IList<DataBaseEntity> GetDataBases(ServiceSite site) { IList<DataBaseEntity> list = null; using (MySqlConnection connection = new MySqlConnection(site.DbConnectionStringBuilder.ConnectionString)) { connection.Open(); DataTable databases = connection.GetSchema(SqlClientMetaDataCollectionNames.Databases, new string[] { null }); if (databases != null && databases.Rows.Count > 0) { list = new List<DataBaseEntity>(); foreach (DataRow database in databases.Rows) { string name = (string)database["database_name"]; MySqlConnectionStringBuilder con = new MySqlConnectionStringBuilder(site.DbConnectionStringBuilder.ConnectionString); con.Database = name; DataBaseEntity db = new DataBaseEntity(con,name); db.Service = site; list.Add(db); } } } return list; }
public abstract IList<DataBaseEntity> GetDataBases(ServiceSite site);
public static ServiceSite NewInstance(DbConnectionStringBuilder connectionstringbuilder, string service) { site = new ServiceSite(connectionstringbuilder, service); return site; }