Получение информации о структуре SQL-объекта

SOAP-запрос:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<GetDbCommand xmlns="http://www.fsight.ru/PP.SOM.Som">

<tDbCommand xmlns=" ">

  <id>S2!M!S!M1</id>

  </tDbCommand>

<tArg xmlns=" ">

<pattern>

  <obInst>true</obInst>

  <text>true</text>

  <fields>Get</fields>

  </pattern>

  </tArg>

  </GetDbCommand>

  </s:Body>

  </s:Envelope>

SOAP-ответ:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<GetDbCommandResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<id xmlns=" ">

  <id>S2!M!S!M1</id>

  </id>

<meta xmlns=" ">

<obInst>

<obDesc isShortcut="0" isLink="0" fullUrl="/">

  <i>OBJ9051</i>

  <n>Запрос</n>

  <k>9051</k>

  <c>770</c>

  <p>9050</p>

  <h>0</h>

  </obDesc>

  </obInst>

  <dirty>0</dirty>

  <type>Query</type>

<text>

<its>

<it>

  <driverID>ORCL8</driverID>

  <driverName>Oracle 9.x\10.x\11.x</driverName>

  <sqlText />

  </it>

  <driverID>MSSQL2008</driverID>

  <driverName>Microsoft SQL Server 2008</driverName>

  <sqlText />

  </it>

<it>

  <driverID>MSSQL2012</driverID>

  <driverName>Microsoft SQL Server 2012</driverName>

  <sqlText />

  </it>

<it>

  <driverID>OLEDB(ODBC HIVE)</driverID>

  <driverName>OLE DB(ODBC HIVE)</driverName>

  <sqlText />

  </it>

<it>

  <driverID>OLEDB(DB2)</driverID>

  <driverName>OLE DB(DB2)</driverName>

  <sqlText />

  </it>

<it>

  <driverID>OLEDB(ODBC)</driverID>

  <driverName>OLE DB(ODBC)</driverName>

  <sqlText />

  </it>

<it>

  <driverID>OLEDB(VISTADB)</driverID>

  <driverName>OLE DB(VISTADB)</driverName>

  <sqlText />

  </it>

<it>

  <driverID>OLEDB</driverID>

  <driverName>OLE DB</driverName>

  <sqlText />

  </it>

<it>

  <driverID>DB2</driverID>

  <driverName>DB2</driverName>

  <sqlText />

  </it>

<it>

  <driverID>TRDT</driverID>

  <driverName>Teradata</driverName>

  <sqlText />

  </it>

<it>

  <driverID>POSTGRES(NO_LO)</driverID>

  <driverName>PostgreSQL без поддержки типа lo</driverName>

  <sqlText />

  </it>

<it>

  <driverID>POSTGRES</driverID>

  <driverName>PostgreSQL</driverName>

  <sqlText />

  </it>

<it>

  <driverID>SQLITE</driverID>

  <driverName>SQLite</driverName>

  <sqlText />

  </it>

<it>

  <driverID>WSF</driverID>

  <driverName>Web Service Dal</driverName>

  <sqlText />

  </it>

  </its>

  <sqlText>SELECT * FROM T_COUNTRY</sqlText>

  </text>

<fields>

<its>

<it>

  <k>5</k>

  <id>ISO_CODE</id>

  <n>ISO_CODE</n>

  <vis>1</vis>

  <dt>1</dt>

  <size>255</size>

  <precision>0</precision>

  </it>

<it>

  <k>6</k>

  <id>NAME</id>

  <n>NAME</n>

  <vis>1</vis>

  <dt>1</dt>

  <size>255</size>

  <precision>0</precision>

  </it>

<it>

  <k>7</k>

  <id>POPULATION</id>

  <n>POPULATION</n>

  <vis>1</vis>

  <dt>3</dt>

  <size>22</size>

  <precision>2</precision>

  </it>

<it>

  <k>8</k>

  <id>AREA</id>

  <n>AREA</n>

  <vis>1</vis>

  <dt>3</dt>

  <size>22</size>

  <precision>2</precision>

  </it>

<it>

  <k>9</k>

  <id>CURRENCY</id>

  <n>CURRENCY</n>

  <vis>1</vis>

  <dt>1</dt>

  <size>255</size>

  <precision>0</precision>

  </it>

  </its>

  </fields>

  </meta>

  </GetDbCommandResult>

  </soapenv:Body>

JSON-запрос:

{
 "GetDbCommand" : 
  {
   "tDbCommand" : 
    {
     "id" : "S2!M!S!M1"
    },

   "tArg" : 
    {
     "pattern" : 
      {
       "obInst" : "true",
       "text" : "true",
       "fields" : "Get"
      }
    }
  }
}

JSON-ответ:

{
 "GetDbCommandResult" : 
  {
   "id" : 
    {
     "id" : "S2!M!S!M1"
    },
   "meta" : 
    {
     "obInst" : 
      {
       "obDesc" : 

        {
         "@fullUrl" : "\/",
         "@isShortcut" : "0",
         "@isLink" : "0",
         "i" : "OBJ9051",
         "n" : "Запрос",
         "k" : "9051",
         "c" : "770",
         "p" : "9050",
         "h" : "0"

        }
      },
     "dirty" : "0",
     "type" : "Query",
     "text" : 
      {
       "its" : 
        {
         "it" : 
          [

            {
             "driverID" : "ORCL8",
             "driverName" : "Oracle 9.x\10.x\11.x",
             "sqlText" : ""
            },
            {
             "driverID" : "MSSQL2008",
             "driverName" : "Microsoft SQL Server 2008",
             "sqlText" : ""
            },

            {
             "driverID" : "MSSQL2012",
             "driverName" : "Microsoft SQL Server 2012",
             "sqlText" : ""
            },
            {
             "driverID" : "OLEDB(ODBC HIVE)",
             "driverName" : "OLE DB(ODBC HIVE)",
             "sqlText" : ""
            },

            {
             "driverID" : "OLEDB(DB2)",
             "driverName" : "OLE DB(DB2)",
             "sqlText" : ""
            },
            {
             "driverID" : "OLEDB(ODBC)",
             "driverName" : "OLE DB(ODBC)",
             "sqlText" : ""
            },

            {
             "driverID" : "OLEDB(VISTADB)",
             "driverName" : "OLE DB(VISTADB)",
             "sqlText" : ""
            },
            {
             "driverID" : "OLEDB",
             "driverName" : "OLE DB",
             "sqlText" : ""
            },

            {
             "driverID" : "DB2",
             "driverName" : "DB2",
             "sqlText" : ""
            },
            {
             "driverID" : "TRDT",
             "driverName" : "Teradata",
             "sqlText" : ""
            },

            {
             "driverID" : "POSTGRES(NO_LO)",
             "driverName" : "PostgreSQL без поддержки типа lo",
             "sqlText" : ""
            },
            {
             "driverID" : "POSTGRES",
             "driverName" : "PostgreSQL",
             "sqlText" : ""
            },

            {
             "driverID" : "SQLITE",
             "driverName" : "SQLite",
             "sqlText" : ""
            },
            {
             "driverID" : "WSF",
             "driverName" : "Web Service Dal",
             "sqlText" : ""
            }

          ]
        },
       "sqlText" : "SELECT * FROM T_COUNTRY"
      },
     "fields" : 
      {
       "its" : 
        {
         "it" : 
          [

            {
             "k" : "5",
             "id" : "ISO_CODE",
             "n" : "ISO_CODE",
             "vis" : "1",
             "dt" : "1",
             "size" : "255",
             "precision" : "0"
            },
            {

             "k" : "6",
             "id" : "NAME",
             "n" : "NAME",
             "vis" : "1",
             "dt" : "1",
             "size" : "255",
             "precision" : "0"
            },
            {
             "k" : "7",

             "id" : "POPULATION",
             "n" : "POPULATION",
             "vis" : "1",
             "dt" : "3",
             "size" : "22",
             "precision" : "2"
            },
            {
             "k" : "8",
             "id" : "AREA",

             "n" : "AREA",
             "vis" : "1",
             "dt" : "3",
             "size" : "22",
             "precision" : "2"
            },
            {
             "k" : "9",
             "id" : "CURRENCY",
             "n" : "CURRENCY",

             "vis" : "1",
             "dt" : "1",
             "size" : "255",
             "precision" : "0"
            }
          ]
        }
      }
    }
  }
}

    public static GetDbCommandResult GetSQLObjectParameters(DbCommandId moniker)
    {
        var somClient = new SomPortTypeClient(); //Прокси-объект для выполнения операций
        //Параметры выполнения операции
        var tGet = new GetDbCommand()
        {
            tArg = new GetDbCommandArg()
            {
                pattern = new DbCommandMdPattern()
                {
                    fields = ListOperation.Get,
                    text = true
                }
            },
            tDbCommand = moniker
        };
        //Получение параметров
        var tResult = somClient.GetDbCommand(tGet);
        return tResult;
    }