Skip to content
Documentation

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.

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 Prepare can be called.
  • Invalid floating-point values (NaN, Infinity) in FLOAT columns are detected and wrapped in a specific exception.
  • Parameters support SqlDbType, size constraints, and DataTable-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.
© 2026 Volue.Version v0.6.38017 November 2026