See Also

SQLiteCommand Class  | Devart.Data.SQLite Namespace  | SQLiteDataReader Class  | SQLiteConnection Class

See AlsoDevart.Data.SQLiteSend comments on this topic.

SQLiteCommand Class Members

Devart.Data.SQLite Namespace : SQLiteCommand Class

SQLiteCommand overview

Public Constructors

Public Constructor SQLiteCommand ConstructorOverloaded. Initializes a new instance of the SQLiteCommand class.

Public Properties

Public Property CommandTextOverridden. Gets or sets the SQL statement to execute against SQLite.
Public Property CommandTimeoutOverridden. Gets or sets the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data.
Public Property CommandTypeOverridden. Gets or sets a value indicating how the CommandText property is to be interpreted.
Public Property ConnectionGets or sets the SQLiteConnection used by this instance of the SQLiteCommand.
Public Property Container (Inherited from System.ComponentModel.Component)Gets the IContainer that contains the Component.
Public Property InsertIDReturns the rowid of the most recent successful INSERT into the database.
Public Property Owner (Inherited from Devart.Common.DbCommandBase)Gets or sets a form or other container that the Devart.Common.DbCommandBase instance belongs to.
Public Property ParameterCheck (Inherited from Devart.Common.DbCommandBase)Gets or sets a value indicating whether the command object regenerates parameter objects if text of the command is changed.
Public Property ParametersGets or sets the SQLiteParameterCollection.
Public Property Site (Inherited from System.ComponentModel.Component)Gets or sets the ISite of the Component.
Public Property Transaction (Inherited from System.Data.Common.DbCommand)Gets or sets the DbTransaction within which this DbCommand object executes.
Public Property UpdatedRowSourceOverridden. Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter.

Public Methods

Public Method BeginExecuteNonQuery (Inherited from Devart.Common.DbCommandBase)Overloaded. Starts an asynchronous invocation of an Devart.Common.DbCommandBase.ExecuteNonQuery method.
Public Method BeginExecuteReader (Inherited from Devart.Common.DbCommandBase)Overloaded. Starts an asynchronous invocation of an Devart.Common.DbCommandBase.ExecuteReader method.
Public Method CancelOverridden. Stops execution of SQLiteCommand methods.
Public Method CloneCreates a new object that is a copy of the current SQLiteCommand instance.
Public Method CreateObjRef (Inherited from System.MarshalByRefObject)Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Public Method CreateParameterCreates a new instance of a SQLiteParameter object.
Public Method Dispose (Inherited from System.ComponentModel.Component)Releases all resources used by the Component.
Public Method EndExecuteNonQuery (Inherited from Devart.Common.DbCommandBase)Ends an asynchronous invocation of the Devart.Common.DbCommandBase.ExecuteNonQuery method.
Public Method EndExecuteReaderEnds an asynchronous invocation of the ExecuteReader method.
Public Method ExecuteNonQuery (Inherited from Devart.Common.DbCommandBase)Executes SQL statement against the Devart.Common.DbCommandBase.Connection and returns the number of rows affected.
Public Method ExecutePageReaderReturns a specific subset of rows when paging through the results of a query.
Public Method ExecuteReaderOverloaded. Sends the CommandText to the Connection and builds a SQLiteDataReader.
Public Method ExecuteScalar (Inherited from Devart.Common.DbCommandBase)Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.
Public Method GetLifetimeService (Inherited from System.MarshalByRefObject)Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Public Method GetRecordCount (Inherited from Devart.Common.DbCommandBase)Returns count of records in the resultset.
Public Method InitializeLifetimeService (Inherited from System.MarshalByRefObject)Obtains a lifetime service object to control the lifetime policy for this instance.
Public Method PrepareOverridden. Creates a prepared (or compiled) version of the command on the server.
Public Method ResetCommandTimeout (Inherited from Devart.Common.DbCommandBase)Resets Devart.Common.DbCommandBase.CommandTimeout to its default value, which is taken from Devart.Common.DbCommandBase.DefaultCommandTimeout.
Public Method ToString (Inherited from System.ComponentModel.Component)Returns a String containing the name of the Component, if any. This method should not be overridden.

Public Events

Public Event Disposed (Inherited from System.ComponentModel.Component)Occurs when the component is disposed by a call to the Dispose method.

See Also

SQLiteCommand Class  | Devart.Data.SQLite Namespace  | SQLiteDataReader Class  | SQLiteConnection Class



© 2008 - 2016 Devart. All Rights Reserved.