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
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also