HAKOM.Persistence.Sql.Net.Api Namespace
Contains the public API surface of the database-agnostic SQL persistence module, including storage provider interfaces, parameter abstractions, and base implementation classes.
Remarks
Section titled “Remarks”The key types in this namespace are:
- ISqlStorageProvider — Root interface for executing SQL statements without parameters.
- ISqlStorageProvider<TReader> — Extends the root with typed
Select,SelectFirst, andRead*column-value methods. - ISqlStorageProvider<TParameter,TParameterFactory,TReader> — Adds parameterised query execution, wildcard escaping, and collation support.
- ISqlParameter — Marker interface identifying a SQL parameter.
- ISqlParameter<TNative> — A SQL parameter that can convert itself to its native ADO.NET representation.
- ISqlParameterFactory<TParameter> — Creates strongly-typed SQL parameters from name/value pairs.
- SqlParameterFactory<TParameter> — Abstract base implementing common prefix handling for parameter names.
- SqlStorageProvider<TConnection,TCommand,TNativeParameter,TReader,TParameter,TParameterFactory> — The abstract base class that provider-specific assemblies derive from to supply concrete ADO.NET connection, command, and reader types.
- SqlRepositoryInformationStore<TStorageProvider,TReader,TRepositoryInformation> — Base class for SQL-backed repository information stores with optional caching.
- IConnectionSemaphoreCollection<TConnection> — Manages named semaphores that throttle concurrent connections per connection name.
| Classes | |
|---|---|
| SqlParameterFactory<TParameter> | Abstract base class for SQL parameter factories that handles parameter-name prefixing. |
| SqlRepositoryInformationStore<TStorageProvider,TReader,TRepositoryInformation> | Abstract base class for SQL-backed repository information stores that query metadata about a repository through a TStorageProvider and optionally cache the result. |
| SqlStorageProvider<TConnection,TCommand,TNativeParameter,TReader,TParameter,TParameterFactory> | Abstract base class for SQL-based storage providers that manages the full lifecycle of connecting, executing, reading, and releasing database resources. |
| Interfaces | |
|---|---|
| IConnectionSemaphoreCollection<TConnection> | Manages a collection of named System.Threading.SemaphoreSlim instances that throttle the number of concurrent connections per connection name. |
| ISqlParameter | Marker interface identifying a SQL parameter that can be passed to storage provider query and execution methods. |
| ISqlParameter<TNative> | A SQL parameter that can be converted to its native ADO.NET representation. |
| ISqlParameterFactory<TParameter> | Factory for creating strongly-typed SQL parameters from name/value pairs. |
| ISqlStorageProvider | Root interface for SQL-based storage providers, supporting execution of parameterless SQL statements. |
| ISqlStorageProvider<TParameter,TParameterFactory,TReader> | Extends ISqlStorageProvider<TReader> with parameterised query execution, wildcard escaping, and collation support. |
| ISqlStorageProvider<TReader> | Extends ISqlStorageProvider with typed query methods that stream results through a user-supplied parser, and provides strongly-typed column-reading methods for common CLR types. |
Was this page helpful?Thanks for your feedback!