Parameters
- useColumnsForParameterNames
- Determines whether dotConnect uses columns metadata to make up parameters' names. If true, the names are composed using colon and name of appropriate column; otherwise the names look like :p1, :p2 etc.
You can also use GetUpdateCommand() as the basis of a modified command. For example, you might call GetUpdateCommand() and modify the Devart.Common.DbCommand.CommandText value, and then explicitly set that on the DbDataAdapter.
After the SQL statement is first generated, you must explicitly call DbCommandBuilderBase.RefreshSchema if it changes the statement in any way. Otherwise, the GetUpdateCommand() still will be using information from the previous statement, which might not be correct. The SQL statements are first generated when the application calls either System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) or GetUpdateCommand().