Development · Native API migration preview · Coverage validation in progress Published release →

API Browser

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.