//Returns SQL SERVER database schema // 26.09.2012 - Travis.Frisinger : Amended to properly intergate the schema public string FindSqlDatabaseSchema(string serverName, string databaseName, string username, string password) { dynamic xmlResponse = new UnlimitedObject(); IDBHelper helper = DBHelperFactory.GenerateNewHelper(enSupportedDBTypes.MSSQL); var props = new DBConnectionProperties(); props.Server = serverName; props.DB = databaseName; props.User = username; props.Pass = password; string result = helper.ExtractCodedEntities(helper.CreateConnectionString(props)); return result; }
// Travis.Frisinger - 09.09.2012 : added mode and dbType public string CallProcedure(string serverName, string databaseName, string procedure, string parameters, string mode, string username, string password) { string result = "<Error>Invalid Parameters</Error>"; if(mode == "interrogate") { IDBHelper helper = DBHelperFactory.GenerateNewHelper(enSupportedDBTypes.MSSQL); var props = new DBConnectionProperties(); props.Server = serverName; props.DB = databaseName; props.User = username; props.Pass = password; result = helper.TickleDBLogic(helper.CreateConnectionString(props), procedure, parameters); } return result; }
//This returns a list of SQLSERVER database given a serverName public string FindSqlDatabases(string serverName, string username, string password) { IDBHelper helper = DBHelperFactory.GenerateNewHelper(enSupportedDBTypes.MSSQL); var props = new DBConnectionProperties(); props.Server = serverName; props.DB = "master"; props.User = username; props.Pass = password; string result = helper.ListDatabases(helper.CreateConnectionString(props)); return result; }