Provider SQL Server

Language: English | Português (Brasil)

SQL Server

Package: DbSqlLikeMem.SqlServer

Use this provider when

• Your codebase depends on T-SQL behavior
• You need SQL Server-oriented repository and service tests
• You want fast local feedback before running real SQL Server integration tests

Simulated versions

• 7
• 2000
• 2005
• 2008
• 2012
• 2014
• 2016
• 2017
• 2019
• 2022

Supported today

• SQL Server-flavored ADO.NET mocks
• Practical dialect-aware parsing and execution for common test flows
• Dapper-friendly usage through the standard DbConnection surface
• Sequence setup and execution with SQL Server syntax

Dialect-specific behavior to watch

• Version-sensitive T-SQL behavior
• SQL Server sequence syntax: NEXT VALUE FOR schema.seq_name
• Differences in pagination and UPSERT strategy compared with other providers

Known limitations

• Exact optimizer and engine behavior still belong to real SQL Server validation
• Use the compatibility page before relying on advanced vendor-specific syntax in test assertions

Related pages

• Getting Started
• Providers and Compatibility
• DbConnection Interception