Provider SQLite

Language: English | Português (Brasil)

SQLite

Package: DbSqlLikeMem.Sqlite

Use this provider when

• You want a lightweight SQLite-flavored test path
• Your team values fast local execution and simple setup
• Your application behavior is centered on SQLite semantics

Simulated versions

• 3

Supported today

• SQLite-oriented ADO.NET mocks for fast local test loops
• Fluent schema and data setup with a low-friction workflow
• Dapper-friendly usage over the same standard connection surface
• Practical dialect-aware behavior for common SQLite-style tests

Dialect-specific behavior to watch

• SQLite has a narrower version family than the server-style providers
• SQL shape and feature expectations differ from enterprise providers such as SQL Server, Oracle, or DB2
• Use provider-specific pages when you also support broader multi-dialect suites

Known limitations

• Keep the compatibility page close when comparing SQLite assumptions with other database families
• Validate final production behavior against the real provider if SQLite is not your only deployment target

Related pages

• Getting Started
• Providers and Compatibility
• ADO.NET and Dapper