Provider SQL Azure

Language: English | Português (Brasil)

SQL Azure

Package: DbSqlLikeMem.SqlAzure

Use this provider when

• Your production target is Azure SQL rather than on-prem SQL Server
• You want compatibility-level oriented validation in tests
• You need Azure SQL naming and provider aliases in the same test story

Simulated compatibility levels

• 100
• 110
• 120
• 130
• 140
• 150
• 160
• 170

Supported today

• Azure SQL-oriented connection mocks and provider-specific setup
• Compatibility-level-sensitive test flows
• Interception-ready connections using the same core interception surface
• SQL Azure sequence syntax aligned with the SQL Server family

Dialect-specific behavior to watch

• Alias forms such as sqlazure, azure-sql, azuresql, and azure_sql
• SQL Azure sequence syntax: NEXT VALUE FOR schema.seq_name
• Compatibility-level assumptions that may differ from on-prem SQL Server expectations

Known limitations

• Validate final cloud-specific behavior against Azure SQL itself for release confidence
• Use the shared compatibility pages before depending on advanced dialect-specific semantics

Related pages

• Getting Started
• Providers and Compatibility
• DbConnection Interception