HAKOM.Persistence.Sql.SqlServer.Net Assembly
Provides the SQL Server-specific SQL persistence implementation for HAKOM applications, supplying concrete connection, command, parameter, and data reader types backed by Microsoft.Data.SqlClient.
Remarks
Section titled “Remarks”This assembly contains the SqlServerStorageProvider which derives from
SqlStorageProvider<TConnection,TCommand,TNativeParameter,TReader,TParameter,TParameterFactory>
and wires up SqlConnection, SqlCommand, SqlParameter,
and SqlDataReader as the concrete ADO.NET types.
Key SQL Server-specific behaviors include:
- Command preparation is skipped because SQL Server requires explicit data type
definitions on each parameter before
Preparecan be called. - Invalid floating-point values (
NaN,Infinity) inFLOATcolumns are detected and wrapped in a specific exception. - Parameters support
SqlDbType, size constraints, andDataTable-typed parameters for table-valued parameters.
Register SQL Server services via the extension method in ContainerExtensions:
using HAKOM.Persistence.Sql.SqlServer.Net.Api.Extensions;
container.UseSqlServer();| Namespaces | |
|---|---|
| HAKOM.Persistence.Sql.SqlServer.Net.Api | Contains the public API surface of the SQL Server persistence module, including SQL Server-specific parameter, parameter factory, and storage provider interfaces. |
| HAKOM.Persistence.Sql.SqlServer.Net.Api.Exceptions | Contains exception types specific to the SQL Server persistence provider. |
| HAKOM.Persistence.Sql.SqlServer.Net.Api.Extensions | Extension methods for registering SQL Server persistence services with the IContainer. |
Was this page helpful?Thanks for your feedback!