dotConnect for Dynamics 365 Documentation
Devart.Data.Dynamics Namespace / DynamicsCommand Class / DynamicsCommand Constructor / DynamicsCommand Constructor(String,DynamicsConnection)
The text of the query.
A DynamicsConnection object that represents the connection to Dynamics 365.
Example

DynamicsCommand Constructor(String,DynamicsConnection)
Initializes a new instance of the DynamicsCommand class with the text of the query and a %% object.
Syntax
'Declaration
 
Public Function New( _
   ByVal commandText As String, _
   ByVal connection As DynamicsConnection _
)
 

Parameters

commandText
The text of the query.
connection
A DynamicsConnection object that represents the connection to Dynamics 365.
Remarks
The following table shows initial property values for an instance of DynamicsCommand.
Properties Initial value
CommandText commandText
CommandTimeout 30
CommandType System.Data.CommandType.Text
Connection connection
Example
The following example creates a DynamicsCommand and sets some of its properties.
public void CreateCommand()
{
  DynamicsConnection dynamicsConnection = new DynamicsConnection(
      "Server=https://your_company.crm4.dynamics.com;User Id=Test@Test.onmicrosoft.com;Password=A123456789;");
  string mySelectQuery = "SELECT * FROM contact";
  DynamicsCommand dynamicsCommand = new DynamicsCommand(mySelectQuery, dynamicsConnection);
  dynamicsCommand.FetchSize = 100;
}
Public Sub CreateCommand()
  Dim dynamicsConnection As New DynamicsConnection( _
    "Server=https://your_company.crm4.dynamics.com;User Id=Test@Test.onmicrosoft.com;Password=A123456789;")
  Dim mySelectQuery As String = _
    "SELECT * FROM contact"
  Dim dynamicsCommand As New DynamicsCommand(mySelectQuery, dynamicsConnection)
  dynamicsCommand.FetchSize = 100
End Sub
See Also