Module
System.Data.Sql
module System.Data.Sql
SQL connections and mapping
SQL-domain contracts: configured databases open connections, statements bind positional values, and execution returns owned buffered rows. SqlMapper maps rows to scalar properties or through explicit callbacks. Transactions have explicit completion and lifetime. This is not ADO.NET or Dapper API compatibility.
See SQL member reference for signatures, errors, ownership and limits. The optional System.Data.PostgreSql binding currently supports local trust-authenticated PostgreSQL only; TLS, password authentication and remote access remain unimplemented.
Types
9 items
SqlConnection
One serial conversation with a database. Implementations reject overlapping operations.
SqlDatabase
Configured access to a SQL database; opening produces one independently owned session.
SqlError
Recoverable SQL failures. Server preserves SQLSTATE; transport errors do not imply a safe retry.
SqlMapper
SQL-first buffered mapping; no change tracking, SQL generation or dynamic code generation.
SqlResult
Buffered results independent of the session. CommandTag retains the provider's completion tag.
SqlRow
An owned row snapshot. Names are ordinal and duplicate names are ambiguous.
SqlStatement
SQL text and an owned snapshot of named or positional values; providers define binding syntax.
SqlTransaction
Explicit transaction lifetime. Disposal before completion abandons the session to guarantee rollback.
SqlValue
Portable parameter values. Null is SQL NULL, distinct from empty text.