public SQLiteConnection( SQLiteConnection connection );
概要
Clones the settings and connection string from an existing connection. If the existing connection is already open, this function will open its own connection, enumerate any attached databases of the original connection, and automatically attach to them.
Returns non-zero if the given database connection is in autocommit mode. Autocommit mode is on by default. Autocommit mode is disabled by a BEGIN statement. Autocommit mode is re-enabled by a COMMIT or ROLLBACK.
public static ISQLiteConnectionPool ConnectionPool { get set }
概要
This property is used to obtain or set the custom connection pool implementation to use, if any. Setting this property to null will cause the default connection pool implementation to be used.
Gets/sets the default command timeout for newly-created commands. This is especially useful for commands used internally such as inside a SQLiteTransaction, where setting the timeout is not possible. This can also be set in the ConnectionString with "Default Timeout"
This method returns the string whose value contains the unique identifier for the source checkout used to build the interop assembly. If the SQLite interop assembly is not in use or the necessary information cannot be obtained for any reason, a null value may be returned.
This method returns the version of the interop SQLite assembly used. If the SQLite interop assembly is not in use or the necessary information cannot be obtained for any reason, a null value may be returned.
Returns the amount of memory (in bytes) currently in use by the SQLite core library.
リターン メモリー(バイトの)の量 現在 SQLite中心的ライブラリによる使用 。
public bool OwnHandle { get }
概要
Returns non-zero if the underlying native connection handle is owned by this instance.
リターン もしこの例による横たわりネイティブの接続ハンドルの所有不 0 。
public bool ParseViaFramework { get set }
概要
Non-zero if the built-in (i.e. framework provided) connection string parser should be used when opening the connection.
もし接続を開く時の内蔵の(すなわち、枠組は提供した)接続ストリングパーザの使用不 0。
public int PoolCount { get }
概要
Returns the number of pool entries for the file name associated with this connection.
ファイル名のためのプール入力の数がこの接続と結び付けたリターン。
public int PrepareRetries { get set }
概要
The maximum number of retries when preparing SQL to be executed. This normally only applies to preparation errors resulting from the database schema being changed.
The approximate number of virtual machine instructions between progress events. In order for progress events to actually fire, the event handler must be added to the System.Data.SQLite.SQLiteConnection.Progress event as well. This value will only be used when the underlying native progress callback needs to be changed.
This method returns the string whose value contains the unique identifier for the source checkout used to build the managed components currently executing. If the necessary information cannot be obtained for any reason, a null value may be returned.
This method returns the version of the managed components used to interact with the SQLite core library. If the necessary information cannot be obtained for any reason, a null value may be returned.
Returns the version of the underlying SQLite core library.
潜在的なSQLite中心的ライブラリのリターンバージョン。
public override ConnectionState State { get }
概要
Returns the state of the connection.
接続のリターン状態。
public string VfsName { get set }
概要
Gets/sets the VFS name for this connection. This value will only be used when opening the database.
この接続のためのVFS名。この価値は、データベースを開く時に使われるだけである。
public int WaitTimeout { get set }
概要
EXPERIMENTAL -- The wait timeout to use with System.Data.SQLite.SQLiteConnection.WaitForEnlistmentReset(System.Int32,System.Nullable{System.Boolean}) method. This is only used when waiting for the enlistment to be reset prior to enlisting in a transaction, and then only when the appropriate connection flag is set.
public event SQLiteAuthorizerEventHandler Authorize;
概要
This event is raised whenever SQLite encounters an action covered by the authorizer during query preparation. Changing the value of the System.Data.SQLite.AuthorizerEventArgs.ReturnCode property will determine if the specific action will be allowed, ignored, or denied. For the entire duration of the event, the associated connection and statement objects must not be modified, either directly or indirectly, by the called code.
This event is raised periodically during long running queries. Changing the value of the System.Data.SQLite.ProgressEventArgs.ReturnCode property will determine if the operation in progress will continue or be interrupted. For the entire duration of the event, the associated connection and statement objects must not be modified, either directly or indirectly, by the called code.
public int AddTypeMapping( string typeName, DbType dataType, bool primary );
概要
Adds a per-connection type mapping, possibly replacing one or more that already exist.
ことによると、すでに存在する1以上を取り替えて接続あたりタイプマッピングを追加する。
パラメーター
typeName:
The case-insensitive database type name (e.g. "MYDATE"). The value of this parameter cannot be null. Using an empty string value (or a string value consisting entirely of whitespace) for this parameter is not recommended.
A negative value if nothing was done. Zero if no per-connection type mappings were replaced (i.e. it was a pure add operation). More than zero if some per-connection type mappings were replaced.
The method to invoke between each step of the backup process. This parameter may be null (i.e. no callbacks will be performed). If the callback returns false -OR- throws an exception, the backup is canceled.
The number of milliseconds to sleep after encountering a locking error during the backup process. A value less than zero means that no sleep should be performed.
When TRUE, SQLite defers obtaining a write lock until a write operation is requested. When FALSE, a writelock is obtained immediately. The default is false, but in a multi-threaded multi-writer environment, one may instead choose to lock the database immediately to avoid any possible writer deadlock.
Supported isolation levels are Serializable, ReadCommitted and Unspecified.
サポートされた隔離レベルは直列化可能、ReadCommitted、および不特定であることである。
戻り値
Returns a SQLiteTransaction object.
リターン SQLiteTransactionオブジェクト 。
コメント:
Unspecified will use the default isolation level specified in the connection string. If no isolation level is specified in the connection string, Serializable is used. Serializable transactions are the default. In this mode, the engine gets an immediate lock on the database, and no other threads may begin a transaction. Other threads may read from the database, but not write. With a ReadCommitted isolation level, locks are deferred and elevated as needed. It is possible for multiple threads to start a transaction in ReadCommitted mode, but if a thread attempts to commit a transaction while another thread has a ReadCommitted lock, it may timeout or cause a deadlock on both threads until both threads' CommandTimeout's are reached.
When TRUE, SQLite defers obtaining a write lock until a write operation is requested. When FALSE, a writelock is obtained immediately. The default is TRUE, but in a multi-threaded multi-writer environment, one may instead choose to lock the database immediately to avoid any possible writer deadlock.
A System.Delegate object instance that helps implement the function to be bound. For scalar functions, this corresponds to the System.Data.SQLite.SQLiteInvokeDelegate type. For aggregate functions, this corresponds to the System.Data.SQLite.SQLiteStepDelegate type. For collation functions, this corresponds to the System.Data.SQLite.SQLiteCompareDelegate type.
A System.Delegate object instance that helps implement the function to be bound. For aggregate functions, this corresponds to the System.Data.SQLite.SQLiteFinalDelegate type. For other callback types, it is not used and must be null.
This method causes any pending database operation to abort and return at its earliest opportunity. This routine is typically called in response to a user action such as pressing "Cancel" or Ctrl-C where the user wants a long query operation to halt immediately. It is safe to call this routine from any thread. However, it is not safe to call this routine with a database connection that is closed or might close before this method returns.
Change the password (or assign a password) to an open database.
パスワード(または、パスワードを割り当てなさい)を、開いているデータベースに変更しなさい。
パラメーター
newPassword:
The new password to assign to the database
データベースに割り当てる新しいパスワード
コメント:
No readers or writers may be active for this process. The database must already be open and if it already was password protected, the existing password must already have been supplied.
Change the password (or assign a password) to an open database.
パスワード(または、パスワードを割り当てなさい)を、開いているデータベースに変更しなさい。
パラメーター
newPassword:
The new password to assign to the database
データベースに割り当てる新しいパスワード
コメント:
No readers or writers may be active for this process. The database must already be open and if it already was password protected, the existing password must already have been supplied.
The total number of per-connection settings cleared.
接続あたり設定の全体の数は澄んだ。
public static void ClearPool( SQLiteConnection connection );
概要
Clears the connection pool associated with the connection. Any other active connections using the same database file will be discarded instead of returned to the pool when they are closed.
The total number of per-connection type callbacks cleared.
接続あたりタイプコールバックの全体の数は澄んだ。
public int ClearTypeMappings();
概要
Clears the per-connection type mappings.
接続あたりタイプマッピングをクリアする。
戻り値
The total number of per-connection type mappings cleared.
接続あたりタイプマッピングの全体の数は澄んだ。
public object Clone();
概要
Creates a clone of the connection. All attached databases and user-defined functions are cloned. If the existing connection is open, the cloned connection will also be opened.
public static object CreateHandle( IntPtr nativeHandle );
概要
Creates and returns a new managed database connection handle. This method is intended to be used by implementations of the System.Data.SQLite.ISQLiteConnectionPool interface only. In theory, it could be used by other classes; however, that usage is not supported.
This must be a native database connection handle returned by the SQLite core library and it must remain valid and open during the entire duration of the calling method.
Cleans up resources (native and managed) associated with the current instance.
現在の例と関連したリソース(ネイティブと管理した)を洗浄する。
パラメーター
disposing:
Zero when being disposed via garbage collection; otherwise, non-zero.
ガベージコレクションを経て置かれる時の0;さもなければ不 0。
public void EnableExtensions( bool enable );
概要
Enables or disables extension loading.
拡張ロードを可能にするか、または使用不可にする。
パラメーター
enable:
True to enable loading of extensions, false to disable.
使用不可にするために間違いに拡張のロードを可能にする真。
public override void EnlistTransaction( System.Transactions.Transaction transaction );
概要
Manual distributed transaction enlistment support
マニュアルはトランザクション兵籍編入サポートを配布した
パラメーター
transaction:
The distributed transaction to enlist in
入隊するべき配布されたトランザクション
public SQLiteErrorCode ExtendedResultCode();
public static void GetMemoryStatistics( ref IDictionary statistics );
概要
Returns various global memory statistics for the SQLite core library via a dictionary of key/value pairs. Currently, only the "MemoryUsed" and "MemoryHighwater" keys are returned and they have values that correspond to the values that could be obtained via the System.Data.SQLite.SQLiteConnection.MemoryUsed and System.Data.SQLite.SQLiteConnection.MemoryHighwater connection properties.
This dictionary will be populated with the global memory statistics. It will be created if necessary.
この辞書にはグローバルなメモリー統計によって住む。それは必要なら作成される。
public override DataTable GetSchema( string collectionName );
概要
Returns schema information of the specified collection
指定されたコレクションのリターンスキーマ情報
パラメーター
collectionName:
The schema collection to retrieve
回復へのスキーマコレクション
戻り値
A DataTable of the specified collection
指定されたコレクションのDataTable
public override DataTable GetSchema( string collectionName, string[] restrictionValues );
概要
Retrieves schema information using the specified constraint(s) for the specified collection
指定されたコレクションのための指定された強制(s)を使ってスキーマ情報を検索する
パラメーター
collectionName:
The collection to retrieve.
回復へのコレクション。
restrictionValues:
The restrictions to impose. Typically, this may include: restrictionValues element index usage 0 The database (or catalog) name, if applicable. 1 The schema name. This is not used by this provider. 2 The table name, if applicable. 3 Depends on collectionName. When "IndexColumns", it is the index name; otherwise, it is the column name. 4 Depends on collectionName. When "IndexColumns", it is the column name; otherwise, it is not used.
The per-connection type mappings -OR- null if they are unavailable.
もしそれらの利用できなさ接続あたりタイプマッピング-OR-零。
public bool IsReadOnly( string name );
概要
Checks if this connection to the specified database should be considered read-only. An exception will be thrown if the database name specified via name cannot be found.
public static SQLiteErrorCode ReleaseMemory( int nBytes, bool reset, bool compact, ref int nFree, ref bool resetOk, ref uint nLargest );
概要
Attempts to free N bytes of heap memory by deallocating non-essential memory allocations held by the database library. Memory used to cache database pages to improve performance is an example of non-essential memory. This is a no-op returning zero if the SQLite core library was not compiled with the compile-time option SQLITE_ENABLE_MEMORY_MANAGEMENT. Optionally, attempts to reset and/or compact the Win32 native heap, if applicable.
The number of milliseconds to wait before retrying the I/O operation. This number is multiplied by the number of retry attempts so far to come up with the final number of milliseconds to wait. A negative value will cause the current interval to be queried and replace that negative value.
Sets the chunk size for the primary file associated with this database connection.
主要なファイルのためのかなりの量サイズがこのデータベース接続と結び付けたセット。
パラメーター
size:
The new chunk size for the main database, in bytes.
バイトの主要なデータベースのための新しいかなりの量サイズ。
戻り値
Zero for success, non-zero for error.
成功のための0、エラーのための不 0。
public void SetConfigurationOption( SQLiteConfigDbOpsEnum option, object value );
概要
Change a configuration option value for the database.
コンフィギュレーションオプション価値をデータベースに両替しなさい。
パラメーター
option:
The database configuration option to change.
変わるデータベースコンフィギュレーションオプション。
value:
The new value for the specified configuration option.
指定されたコンフィギュレーションオプションのための新しい値。
public void SetExtendedResultCodes( bool bOnOff );
public int SetLimitOption( SQLiteLimitOpsEnum option, int value );
概要
Change a limit value for the database.
限界価値をデータベースに両替しなさい。
パラメーター
option:
The database limit to change.
変わるデータベース限界。
value:
The new value for the specified limit.
指定された限界のための新しい値。
戻り値
The old value for the specified limit -OR- negative one if an error occurs.
指定された限界-OR-のための古い値 もしエラーの起こり否定的もの 。
public static SQLiteErrorCode SetMemoryStatus( bool value );
概要
Sets the status of the memory usage tracking subsystem in the SQLite core library. By default, this is enabled. If this is disabled, memory usage tracking will not be performed. This is not really a per-connection value, it is global to the process.
The object holding the callbacks for the database type name. If this parameter is null, any callbacks for the database type name will be removed if they are present.
public bool WaitForEnlistmentReset( int timeoutMilliseconds, bool? returnOnDisposed );
概要
EXPERIMENTAL -- Waits for the enlistment associated with this connection to be reset. This method always throws System.NotImplementedException when running on the .NET Compact Framework.
The approximate maximum number of milliseconds to wait before timing out the wait operation.
待機操作の外でタイミングの前に待つ数ミリ秒のおおよその最大の数。
returnOnDisposed:
The return value to use if the connection has been disposed; if this value is null, System.ObjectDisposedException will be raised if the connection has been disposed.
Non-zero if the enlistment assciated with this connection was reset; otherwise, zero. It should be noted that this method returning a non-zero value does not necessarily guarantee that the connection can enlist in a new transaction (i.e. due to potentical race with other threads); therefore, callers should generally use try/catch when calling the System.Data.SQLite.SQLiteConnection.EnlistTransaction(System.Transactions.Transaction) method.