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

SQL Anywhere 11.0.1 » UltraLite - .NET Programming » UltraLite .NET 2.0 API reference » ULCommandBuilder class » GetInsertCommand methods

 

GetInsertCommand(Boolean) method

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

Syntax
Visual Basic
Public Function GetInsertCommand( _
   ByVal useColumnsForParameterNames As Boolean _
) As ULCommand
C#
public ULCommand GetInsertCommand(
   bool useColumnsForParameterNames
);
Parameters
  • useColumnsForParameterNames   If true, generate parameter names matching column names if possible. If false, generate @p1, @p2, and so on.

Return value

The automatically generated ULCommand object required to perform insertions.

Remarks

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 GetInsertCommand 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 GetInsertCommand method.

See also