//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;
        }