C# Class Tortuga.Chain.SQLiteDataSource

Class that represents a SQLite Data Source.

Inheritance: SQLiteDataSourceBase, IRootDataSource

Mostrar archivo Open project: docevaad/Chain Class Usage Examples

Private Properties

Property	Type	Description
CreateConnection	Microsoft.Data.Sqlite.SqliteConnection
CreateConnectionAsync	Task
Execute	int?
IRootDataSource	System.Data.Common.DbConnection
IRootDataSource	IOpenDataSource
IRootDataSource	ITransactionalDataSource
IRootDataSource	Task
IRootDataSource	Task
SQLiteDataSource	System

Public Methods

Method	Description
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.

Protected Methods

Method	Description
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.

Private Methods

Method	Description
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

Method Details

BeginTransaction() public method

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
return	SQLiteTransactionalDataSource

BeginTransactionAsync() public method

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
return	Task

CreateFromConfig() public static method

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

public static CreateFromConfig ( string connectionName ) : SQLiteDataSource
connectionName	string
return	SQLiteDataSource

Execute() protected method

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.
return	int?

ExecuteAsync() protected method

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
return	Task

ExecuteAsync() protected method

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.
return	Task

SQLiteDataSource() public method

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.
return	System

SQLiteDataSource() public method

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.
return	System

SQLiteDataSource() public method

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.
return	System

SQLiteDataSource() public method

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.
return	System

TestConnection() public method

Tests the connection.

public TestConnection ( ) : void
return	void

TestConnectionAsync() public method

Tests the connection asynchronously.

public TestConnectionAsync ( ) : Task
return	Task

WithCache() public method

Craetes a new data source with the provided cache.

public WithCache ( ICacheAdapter cache ) : SQLiteDataSource
cache	ICacheAdapter	The cache.
return	SQLiteDataSource

WithRules() public method

Creates a new data source with additional audit rules.

public WithRules ( ) : SQLiteDataSource
return	SQLiteDataSource

WithRules() public method

Creates a new data source with additional audit rules.

public WithRules ( IEnumerable additionalRules ) : SQLiteDataSource
additionalRules	IEnumerable	The additional rules.
return	SQLiteDataSource

WithSettings() public method

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.
return	SQLiteDataSource

WithUser() public method

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.
return	SQLiteDataSource