Provider PostgreSQL Npgsql

Language: English | Português (Brasil)

PostgreSQL / Npgsql

Package: DbSqlLikeMem.Npgsql

Use this provider when

• Your application targets PostgreSQL through Npgsql
• You need PostgreSQL-flavored tests with Dapper or ADO.NET
• Your scenarios depend on PostgreSQL sequence or RETURNING-style behavior

Simulated versions

• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17

Supported today

• PostgreSQL-oriented connection and command mocks
• Dialect-aware test flows for common PostgreSQL-style SQL
• Sequence functions such as nextval, currval, setval, and lastval
• Dapper-friendly usage on the same DbConnection surface

Dialect-specific behavior to watch

• PostgreSQL sequence functions and schema-qualified names
• PostgreSQL-style UPSERT through ON CONFLICT
• RETURNING-style expectations compared with other database families

Known limitations

• Confirm advanced PostgreSQL-specific SQL against the real provider when it becomes release-critical
• Use the compatibility page before assuming broad coverage of niche syntax combinations

Related pages

• Getting Started
• Providers and Compatibility
• DbConnection Interception