Provider MySQL

Language: English | Português (Brasil)

MySQL

Package: DbSqlLikeMem.MySql

Use this provider when

• Your application ships against MySQL
• You need MySQL-flavored SQL behavior in repository or service tests
• You want Dapper or ADO.NET tests without starting a MySQL server

Simulated versions

• 3
• 4
• 5
• 8

Supported today

• Provider-specific ADO.NET mocks for MySQL-oriented tests
• Fluent schema and data setup in memory
• Dialect-aware parsing and execution for practical test flows
• Dapper-friendly usage on top of the same mocked connection

Dialect-specific behavior to watch

• MySQL-specific UPSERT paths such as ON DUPLICATE KEY UPDATE
• MySQL-style pagination and syntax differences from SQL Server or PostgreSQL
• Sequence syntax is not a first-class MySQL path; prefer identity or auto-increment style setup when modeling those scenarios

Known limitations

• Use the compatibility pages before assuming full engine parity for advanced MySQL syntax
• Keep a small real-provider test slice for release-critical flows

Related pages

• Getting Started
• Providers and Compatibility
• MiniProfiler Integration