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.