Gets the automatically generated ULCommand object required to perform deletions on the database.
Visual Basic syntaxPublic Shadows Function GetDeleteCommand(
ByVal useColumnsForParameterNames As Boolean
) As ULCommand C# syntaxpublic new ULCommand GetDeleteCommand(bool useColumnsForParameterNames) ParametersuseColumnsForParameterNames If true, generate parameter names matching column names if possible. If false, generate @p1, @p2, and so on.
ReturnsThe automatically generated ULCommand object required to perform deletions.
ExceptionsInvalidOperationException The DbCommandBuilder.DataAdapter property has not been initialized.The DataAdapter.SelectCommand property has not been initialized.The DataAdapter.SelectCommand.Connection property has not been initialized.Dynamic SQL generation is not supported against multiple base tables.Dynamic SQL generation is not supported against a SelectCommand value that contains duplicate columns.Dynamic SQL generation for the DeleteCommand property is not supported against a SelectCommand value that does not return any key column information.
RemarksAfter the SQL statement is first generated, the application must explicitly call the DbCommandBuilder.RefreshSchema method if it changes the ULDataAdapter.SelectCommand value in any way. Otherwise, the GetDeleteCommand method still uses information from the previous statement, which might not be correct. The SQL statements are first generated when the application calls either the DbDataAdapter.Update(System.Data.DataSet) or GetDeleteCommand methods.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |
![[external link]](gif/external.gif)
System.Data.Common.DbCommandBuilder.DataAdapter