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
requestsIEnumerable<IDataRequest<IDbConnection, object>>The collection of DataRequests to execute as a batch.
cancellationTokenCancellationTokenThe 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
requestsIEnumerable<IDataRequest<IDbConnection, object>>The collection of DataRequests to execute as a batch.
transactionScopeITransactionScopeThe transaction scope to use.
cancellationTokenCancellationTokenThe 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
requestIDataRequest<IDbConnection, TResult>The DataRequest to validate.
Returns
- bool
True if the request is valid for this provider; otherwise, false.
Type Parameters
TResultThe type of the result.