Represents a pre-compiled SQL statement or query, with or without IN parameters. This object can be used to execute a statement or query efficiently multiple times. This class cannot be inherited.

Syntax

Visual Basic
Public NotInheritable Class ULCommand
  Inherits DbCommand
  Implements ICloneable

C#
public sealed class ULCommand: DbCommand,
  ICloneable

Remarks

ULCommand objects can be created directly, or with the ULConnection.CreateCommand method. This method ensures that the command has the correct transaction for executing statements on the given connection.

The ULCommand.Transaction method must be reset after the current transaction is committed or rolled back.

ULCommand features the following methods for executing commands on an UltraLite.NET database:

You can reset most properties, including the ULCommand.CommandText, and reuse the ULCommand object.

For resource management reasons, it is recommended that you explicitly dispose of commands when you are done with them. In C#, you may use a using statement to automatically call the System.ComponentModel.Component.Dispose() method or explicitly call the System.ComponentModel.Component.Dispose() method. In Visual Basic, you always explicitly call the System.ComponentModel.Component.Dispose() method.

Inherits: System.Data.Common.DbCommand

Implements: System.Data.IDbCommand, System.IDisposable

See also

• ULCommand members
• CreateCommand method
• Transaction property
• ExecuteNonQuery method
• ExecuteReader() method
• ExecuteResultSet() method
• ExecuteScalar method
• ExecuteTable() method
• ULTable class
• CommandText property
•  CommandType.TableDirect
•  Component.Dispose
• CommandType property
• IndexName property
•  DbCommand
•  IDbCommand
•  IDisposable
• ULResultSet class
• ULDataReader class