'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.