Table of Contents

Interface ISqlPersistenceProvider

Namespace
Excalibur.Data.Persistence
Assembly
Excalibur.Data.Abstractions.dll

Specialized persistence provider for SQL databases that handles DataRequest execution with SQL-specific capabilities. Implementation-specific services are available via GetService(Type).

public interface ISqlPersistenceProvider : IPersistenceProvider, IAsyncDisposable, IDisposable
Inherited Members

Properties

DatabaseType

Gets the database type (e.g., "Postgres", "SqlServer", "MySQL").

string DatabaseType { get; }

Property Value

string

The database type (e.g., "Postgres", "SqlServer", "MySQL").

Methods

ExecuteBatchAsync(IEnumerable<IDataRequest<IDbConnection, object>>, CancellationToken)

Executes a batch of DataRequests as a single unit for improved performance. All requests must succeed or the entire batch will be rolled back.

Task<IEnumerable<object>> ExecuteBatchAsync(IEnumerable<IDataRequest<IDbConnection, object>> requests, CancellationToken cancellationToken)

Parameters

requests IEnumerable<IDataRequest<IDbConnection, object>>

The collection of DataRequests to execute as a batch.

cancellationToken CancellationToken

The cancellation token.

Returns

Task<IEnumerable<object>>

A collection of results corresponding to each request in the batch.

ExecuteBatchInTransactionAsync(IEnumerable<IDataRequest<IDbConnection, object>>, ITransactionScope, CancellationToken)

Executes a batch of DataRequests within a transaction scope.

Task<IEnumerable<object>> ExecuteBatchInTransactionAsync(IEnumerable<IDataRequest<IDbConnection, object>> requests, ITransactionScope transactionScope, CancellationToken cancellationToken)

Parameters

requests IEnumerable<IDataRequest<IDbConnection, object>>

The collection of DataRequests to execute as a batch.

transactionScope ITransactionScope

The transaction scope to use.

cancellationToken CancellationToken

The cancellation token.

Returns

Task<IEnumerable<object>>

A collection of results corresponding to each request in the batch.

ValidateRequest<TResult>(IDataRequest<IDbConnection, TResult>)

Validates that a DataRequest is compatible with this SQL provider.

bool ValidateRequest<TResult>(IDataRequest<IDbConnection, TResult> request)

Parameters

request IDataRequest<IDbConnection, TResult>

The DataRequest to validate.

Returns

bool

True if the request is valid for this provider; otherwise, false.

Type Parameters

TResult

The type of the result.