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. 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, and 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., 5.0, 7.0.10 and 6.0.21.
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:
- Visual Studio 2022 Release and Preview
- Visual Studio 2019
- Visual Studio 2017
- Visual Studio 2015
- Visual Studio 2015
- Visual Studio 2013
- Visual Studio 2012
- Visual Studio 2010
- Visual Studio 2008
- Embarcadero Delphi Prism
- CodeGear RAD Studio 2007
- Visual Studio Code
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.