Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

GetUpdateCommand(Boolean) method

Gets the automatically generated ULCommand object required to perform updates on the database.

Visual Basic

Public Function GetUpdateCommand( _
ByVal useColumnsForParameterNames As Boolean _
) As ULCommand

C#

public ULCommand GetUpdateCommand(
bool useColumnsForParameterNames
);

• useColumnsForParameterNames  If true, generate parameter names matching column names if possible. If false, generate @p1, @p2, and so on.

The automatically generated ULCommand object required to perform updates.

After the SQL statement is first generated, the application must explicitly call the DbCommandBuilder.RefreshSchema if it changes the ULDataAdapter.SelectCommand in any way. Otherwise, the GetUpdateCommand method will still be using 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 the GetUpdateCommand method.

• ULCommandBuilder class
• ULCommandBuilder members
• GetUpdateCommand methods
• ULCommand class
•  DbCommandBuilder.RefreshSchema
• SelectCommand property
•  DbDataAdapter.Update
•  DbCommandBuilder.DataAdapter