SQLite database engine

dotConnect for SQLite supports SQLite engine version 3 and above

Framework Compatibility

The provider works with .NET Frameworks 2.0, 3.0, 3.5, 4.0, 4.5, 4.6, 4.7, or 4.8, .NET 5.0, NET 6.0, and .NET 7.0 . The product is compatible with ADO.NET Entity Framework v1 - v6 and Entity Framework Core 1.1.5, 2.2.6, 3.1.10, 5.0, 5.0. (SQLite server or higher is required for Entity Framework). The current version is compatible with ADO.NET Entity Framework v1 - v6 and Entity Framework Core 1.1.5, 2.2.6, 3.1., and 5.0 The provider supports .NET Core 2.x, 3.x, and is compatible with EF Core 5, 6, 7, and 8.

Additionally, dotConnect for SQLite provides .NET Standard 1.3 compatible assemblies, which are compatible with .NET Core 1.x and .NET Framework 4.6 and higher, and .NET Standard 2.0 compatible assemblies, compatible with .NET Core 2.0 and higher and .NET Framework 4.6.1 and higher. There are also .NET Standard 2.1 compatible assemblies for Entity Framework 6.3 and Entity Framework Core 3, 5, and 6, compatible with .NET Core 3.x and .NET 5.

IDE Compatibility

dotConnect for SQLite can be used with following integrated development environments:

There are some limitations in Express Editions of Visual Studio. The following features are not available: provider add-in, automatic toolbox components registration and Server Explorer integration. As an exclusion, Visual Web Developer 2008 and 2010 supports Server Explorer features.

RAD Studio 2007 is supported in run time only as these environments have no WinForms designers.

Since dotConnect for SQLite is available as NuGet packages, it supports Visual Studio Code. Visual Studio Code is a cross-platform code editor, developed by Microsoft.

Unlike Microsoft Visual Studio, Visual Studio Code does not support design-time features. Thus, there are no integration of dotConnect for SQLite to Visual Studio Code, and no design-time features or wizards or other tools, etc.

Devart Data Providers Compatibility

Since Devart data providers use a common assembly (Devart.Data.dll), it is necessary to make sure that all installed data providers are compatible.