C# Класс Tortuga.Chain.SQLiteDataSource

Class that represents a SQLite Data Source.

Наследование: SQLiteDataSourceBase, IRootDataSource

Показать файл Открыть проект Примеры использования класса

Private Properties

Свойство	Тип	Описание
CreateConnection	Microsoft.Data.Sqlite.SqliteConnection
CreateConnectionAsync	Task
Execute	int?
IRootDataSource	System.Data.Common.DbConnection
IRootDataSource	IOpenDataSource
IRootDataSource	ITransactionalDataSource
IRootDataSource	Task
IRootDataSource	Task
SQLiteDataSource	System

Открытые методы

Метод	Описание
BeginTransaction ( IsolationLevel isolationLevel = null, bool forwardEvents = true ) : SQLiteTransactionalDataSource	Creates a new transaction. The caller of this method is responsible for closing the transaction.
BeginTransactionAsync ( IsolationLevel isolationLevel = null, bool forwardEvents = true ) : Task	Creates a new transaction. The caller of this method is responsible for closing the transaction.
CreateFromConfig ( string connectionName ) : SQLiteDataSource	Creates a new connection using the connection string in the app.config file.
SQLiteDataSource ( Microsoft.Data.Sqlite.SqliteConnectionStringBuilder connectionStringBuilder, SQLiteDataSourceSettings settings = null ) : System	Initializes a new instance of the SQLiteDataSource class.
SQLiteDataSource ( string name, Microsoft.Data.Sqlite.SqliteConnectionStringBuilder connectionStringBuilder, SQLiteDataSourceSettings settings = null ) : System	Initializes a new instance of the SQLiteDataSource class.
SQLiteDataSource ( string connectionString, SQLiteDataSourceSettings settings = null ) : System	Initializes a new instance of the SQLiteDataSource class.
SQLiteDataSource ( string name, string connectionString, SQLiteDataSourceSettings settings = null ) : System	Initializes a new instance of the SQLiteDataSource class.
TestConnection ( ) : void	Tests the connection.
TestConnectionAsync ( ) : Task	Tests the connection asynchronously.
WithCache ( ICacheAdapter cache ) : SQLiteDataSource	Craetes a new data source with the provided cache.
WithRules ( ) : SQLiteDataSource	Creates a new data source with additional audit rules.
WithRules ( IEnumerable additionalRules ) : SQLiteDataSource	Creates a new data source with additional audit rules.
WithSettings ( SQLiteDataSourceSettings settings ) : SQLiteDataSource	Creates a new data source with the indicated changes to the settings. The new data source will share the same database metadata cache.
WithUser ( object userValue ) : SQLiteDataSource	Creates a new data source with the indicated user. This is used in conjunction with audit rules.

Защищенные методы

Метод	Описание
Execute ( SQLiteTransaction>.OperationExecutionToken executionToken, SQLiteTransaction>.OperationImplementation implementation, object state ) : int?	Executes the specified operation.
ExecuteAsync ( SQLiteParameter>.CommandExecutionToken executionToken, CommandImplementationAsync implementation, CancellationToken cancellationToken, object state ) : Task	Executes the specified operation asynchronously.
ExecuteAsync ( SQLiteTransaction>.OperationExecutionToken executionToken, SQLiteTransaction>.OperationImplementationAsync implementation, CancellationToken cancellationToken, object state ) : Task	execute as an asynchronous operation.

Приватные методы

Метод	Описание
CreateConnection ( ) : Microsoft.Data.Sqlite.SqliteConnection
CreateConnectionAsync ( CancellationToken cancellationToken = default(CancellationToken) ) : Task
Execute ( SQLiteParameter>.CommandExecutionToken executionToken, CommandImplementation implementation, object state ) : int?
IRootDataSource ( ) : DbConnection
IRootDataSource ( DbConnection connection, DbTransaction transaction ) : IOpenDataSource
IRootDataSource ( ) : ITransactionalDataSource
IRootDataSource ( ) : Task
IRootDataSource ( ) : Task
SQLiteDataSource ( string name, Microsoft.Data.Sqlite.SqliteConnectionStringBuilder connectionStringBuilder, SQLiteDataSourceSettings settings, SQLiteMetadataCache databaseMetadata, ICacheAdapter cache, object>.ConcurrentDictionary extensionCache ) : System

Описание методов

BeginTransaction() публичный Метод

Creates a new transaction.

The caller of this method is responsible for closing the transaction.

public BeginTransaction ( IsolationLevel isolationLevel = null, bool forwardEvents = true ) : SQLiteTransactionalDataSource
isolationLevel	IsolationLevel
forwardEvents	bool
Результат	SQLiteTransactionalDataSource

BeginTransactionAsync() публичный Метод

Creates a new transaction.

The caller of this method is responsible for closing the transaction.

public BeginTransactionAsync ( IsolationLevel isolationLevel = null, bool forwardEvents = true ) : Task
isolationLevel	IsolationLevel
forwardEvents	bool
Результат	Task

CreateFromConfig() публичный статический Метод

Creates a new connection using the connection string in the app.config file.

public static CreateFromConfig ( string connectionName ) : SQLiteDataSource
connectionName	string
Результат	SQLiteDataSource

Execute() защищенный Метод

Executes the specified operation.

protected Execute ( SQLiteTransaction>.OperationExecutionToken executionToken, SQLiteTransaction>.OperationImplementation implementation, object state ) : int?
executionToken	SQLiteTransaction>.OperationExecutionToken	The execution token.
implementation	SQLiteTransaction>.OperationImplementation	The implementation.
state	object	The state.
Результат	int?

ExecuteAsync() защищенный Метод

Executes the specified operation asynchronously.

protected ExecuteAsync ( SQLiteParameter>.CommandExecutionToken executionToken, CommandImplementationAsync implementation, CancellationToken cancellationToken, object state ) : Task
executionToken	SQLiteParameter>.CommandExecutionToken
implementation	CommandImplementationAsync
cancellationToken	System.Threading.CancellationToken
state	object
Результат	Task

ExecuteAsync() защищенный Метод

execute as an asynchronous operation.

protected ExecuteAsync ( SQLiteTransaction>.OperationExecutionToken executionToken, SQLiteTransaction>.OperationImplementationAsync implementation, CancellationToken cancellationToken, object state ) : Task
executionToken	SQLiteTransaction>.OperationExecutionToken	The execution token.
implementation	SQLiteTransaction>.OperationImplementationAsync	The implementation.
cancellationToken	System.Threading.CancellationToken	The cancellation token.
state	object	The state.
Результат	Task

SQLiteDataSource() публичный Метод

Initializes a new instance of the SQLiteDataSource class.

public SQLiteDataSource ( Microsoft.Data.Sqlite.SqliteConnectionStringBuilder connectionStringBuilder, SQLiteDataSourceSettings settings = null ) : System
connectionStringBuilder	Microsoft.Data.Sqlite.SqliteConnectionStringBuilder
settings	Tortuga.Chain.SQLite.SQLiteDataSourceSettings	Optional settings object.
Результат	System

SQLiteDataSource() публичный Метод

Initializes a new instance of the SQLiteDataSource class.

connectionStringBuilder;connectionStringBuilder is null.

public SQLiteDataSource ( string name, Microsoft.Data.Sqlite.SqliteConnectionStringBuilder connectionStringBuilder, SQLiteDataSourceSettings settings = null ) : System
name	string	The name of the data source.
connectionStringBuilder	Microsoft.Data.Sqlite.SqliteConnectionStringBuilder	The connection string builder.
settings	Tortuga.Chain.SQLite.SQLiteDataSourceSettings	Optional settings object.
Результат	System

SQLiteDataSource() публичный Метод

Initializes a new instance of the SQLiteDataSource class.

public SQLiteDataSource ( string connectionString, SQLiteDataSourceSettings settings = null ) : System
connectionString	string
settings	Tortuga.Chain.SQLite.SQLiteDataSourceSettings	Optional settings object.
Результат	System

SQLiteDataSource() публичный Метод

Initializes a new instance of the SQLiteDataSource class.

Connection string is null or emtpy.;connectionString

public SQLiteDataSource ( string name, string connectionString, SQLiteDataSourceSettings settings = null ) : System
name	string	The name of the data source.
connectionString	string	The connection string.
settings	Tortuga.Chain.SQLite.SQLiteDataSourceSettings	Optional settings object.
Результат	System

TestConnection() публичный Метод

Tests the connection.

public TestConnection ( ) : void
Результат	void

TestConnectionAsync() публичный Метод

Tests the connection asynchronously.

public TestConnectionAsync ( ) : Task
Результат	Task

WithCache() публичный Метод

Craetes a new data source with the provided cache.

public WithCache ( ICacheAdapter cache ) : SQLiteDataSource
cache	ICacheAdapter	The cache.
Результат	SQLiteDataSource

WithRules() публичный Метод

Creates a new data source with additional audit rules.

public WithRules ( ) : SQLiteDataSource
Результат	SQLiteDataSource

WithRules() публичный Метод

Creates a new data source with additional audit rules.

public WithRules ( IEnumerable additionalRules ) : SQLiteDataSource
additionalRules	IEnumerable	The additional rules.
Результат	SQLiteDataSource

WithSettings() публичный Метод

Creates a new data source with the indicated changes to the settings.

The new data source will share the same database metadata cache.

public WithSettings ( SQLiteDataSourceSettings settings ) : SQLiteDataSource
settings	Tortuga.Chain.SQLite.SQLiteDataSourceSettings	The new settings to use.
Результат	SQLiteDataSource

WithUser() публичный Метод

Creates a new data source with the indicated user.

This is used in conjunction with audit rules.

public WithUser ( object userValue ) : SQLiteDataSource
userValue	object	The user value.
Результат	SQLiteDataSource