POST api/ExecuteSQLQuery

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
Database	string	None.
Query	string	None.
ProcedureName	string	None.
Params	Collection of Param	None.

Request Formats

application/json, text/json

Sample:

{
  "Database": "sample string 1",
  "Query": "sample string 2",
  "ProcedureName": "sample string 3",
  "Params": [
    {
      "Name": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Name": "sample string 1",
      "Value": "sample string 2"
    }
  ]
}

application/xml, text/xml

Sample:

<SQLModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Models">
  <Database>sample string 1</Database>
  <Params>
    <Param>
      <Name>sample string 1</Name>
      <Value>sample string 2</Value>
    </Param>
    <Param>
      <Name>sample string 1</Name>
      <Value>sample string 2</Value>
    </Param>
  </Params>
  <ProcedureName>sample string 3</ProcedureName>
  <Query>sample string 2</Query>
</SQLModel>

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'JQueryMvcFormUrlEncodedFormatter' to write type 'SQLModel'.

Response Information

Resource Description

IHttpActionResult

None.

Response Formats

application/json, text/json, application/xml, text/xml

Sample:

Sample not available.