AddCommand(IDbCommand,String,String,String) Method

In This Topic

Adds a command to the provider, resulting in an additional table in the Designer.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Overloads Sub AddCommand( _
   ByVal command As IDbCommand, _
   ByVal tableName As String, _
   ByVal identifierDelimiterFormat As String, _
   ByVal parameterMarkerFormat As String _
)

public void AddCommand( 
   IDbCommand command,
   string tableName,
   string identifierDelimiterFormat,
   string parameterMarkerFormat
)

public:
void AddCommand( 
   IDbCommand^ command,
   String^ tableName,
   String^ identifierDelimiterFormat,
   String^ parameterMarkerFormat
)

Parameters

command

The command to add.

tableName

The name for the resulting table.

identifierDelimiterFormat

The delimiter format for the identifiers. SQL server and Oracle use double quotes as delimiters whereas Access uses square brackets. For these types, you don't need to actually pass the pattern as it is done automatically by using the AddCommand(IDbCommand,String) Method overload.

Server	Delimiter format	Sample
SQL/Oracle/SQLite	"{0}"	SELECT * FROM "Customers"
Access	[{0}]	SELECT * FROM [Customers]
MySQL	`{0}`	SELECT * FROM `Customers`
PostgreSQL	"{0}"	SELECT * FROM "Customers"

parameterMarkerFormat

Format string which should be used to format parameter names in generated SQL queries.

Server	Parameter format
SQL/Oracle/SQLite	@{0}
Access	?{0}
MySQL	?{0}
PostgreSQL	:{0}

For the .NET framework connection types, the correct format is automatically chosen, for your own custom provider you might need to adapt the format here.

Example

C#
VB.NET

OleDbCommand command = new OleDbCommand("Select * from [Customers]", conn);
OleDbCommand command2 = new OleDbCommand("Select * from [Orders]", conn);

DbCommandSetDataProvider provider = new DbCommandSetDataProvider();
provider.AddCommand(command, "Customers");
provider.AddCommand(command2, "Orders");
provider.AddRelation("Customers2Orders", "Customers", "Orders", "CustomerID", "CustomerID");

LL.DataSource = provider;
LL.Design();

Dim command As New OleDbCommand("Select * from [Customers]", conn)
Dim command2 As New OleDbCommand("Select * from [Orders]", conn)

Dim provider As New DbCommandSetDataProvider()
provider.AddCommand(command, "Customers")
provider.AddCommand(command2, "Orders")
provider.AddRelation("Customers2Orders", "Customers", "Orders", "CustomerID", "CustomerID")

LL.DataSource = provider
LL.Design()

Requirements

Platforms: Windows 10 (Version 21H2 - 23H2), Windows 11 (21H2 - 22H2), Windows Server 2016 - 2022
.NET: .NET Framework 4.8, .NET 6, .NET 8, .NET 9

Reference

DbCommandSetDataProvider Class
DbCommandSetDataProvider Members
Overload List

Send Feedback