dotConnect for SQLite has three sets of assemblies:

• for full .NET Framework
• .NET Standard 1.3 compatible assemblies (compatible with .NET Core 1.0 and higher and .NET Framework 4.6 and higher)
• .NET Standard 2.0 compatible assemblies (compatible with .NET Core 2.0 and higher and .NET Framework 4.6.1 and higher)

dotConnect for SQLite also has .NET Standard 2.1 compatible assemblies for Entity Framework 6.4 and Entity Framework Core 5 support on .NET Core 3.0 and higher. .NET Standard compatible assemblies are only available as NuGet packages, except for the Entity Framework Core 2 related assembly, installed by the installer.

The dotConnect for SQLite installer does not install .NET Standard compatible assemblies, except for the Entity Framework Core 2 related assembly. You can get them only by installing dotConnect for SQLite NuGet packages to your project. For trial version of dotConnect for SQLite you will still need to install the dotConnect for SQLite installer in order to obtain the license key files.

The dotConnect for SQLite NuGet packages include both .NET Standard 1.3 compatible and .NET Standard 2.0 compatible assemblies. The corresponding assemblies are automatically selected, depending on the platform your project targets, when you install NuGet packages to your projects.

Limitations

Since .NET Core is limited in comparison to full .NET Framework, dotConnect for SQLite .NET Standard compatible assemblies offer less classes and features than the assemblies for full .NET Framework, and dotConnect for SQLite does not support certain technologies for other .NET platforms that are supported for the full .NET Framework. .NET Standard 1.3 compatible assemblies are significantly more limited than .NET Standard 2.0 compatible assemblies.

Here is the list of features, not supported in .NET Standard assemblies:

• DataLink, ParentDataRelation, and related features are not available in .NET Standard compatible assemblies.
• DataSet Wizard, DataSet Editor, and DataSet Manager also are not available for projects, targeting other .NET platforms than full .NET Framework.
• Sync Framework support. There are no .NET Standard compatible Devart.Data.Synchronization.dll and Devart.Data.SQLite.Synchronization.dll assemblies.
• Asynchronous query execution.
• Enterprise Library support.

The following features are supported in .NET Standard 2.0 compatible assemblies, but are not supported in .NET Standard 1.3 compatible assemblies:

• Database object metadata. Since there are no DataTable class, there are no GetSchema method to retrieve the SQLite metadata as a DataTable.
• Query column metadata. Since there are no DataTable class, there are no SQLiteDataReader.GetSchemaTable method to retrieve the SQLite metadata as a DataTable. However, you can retrieve these metadata in other way. The SQLiteDataReader class implements the IDbColumnSchemaGenerator interface, and has the GetColumnSchema method that retrieves typed metadata about colums of the query.
• SQLiteDataSet, SQLiteDataTable, SQLiteCommandBuilder, SQLiteDataAdapter and related classes.
• SQLiteDump class.
• Component classes of the dotConnect for SQLite in .NET Standard 1.3 compatible assemblies are no longer inherited from the System.ComponentModel.Component class, because this class is not present in .NET Core. However, they still implement the System.ComponentModel.IComponent interface, because there is such interface in .NET Core 1.0.
• Classes that implement the ICloneable interface in assemblies for Full .NET Framework don't implement this interface in .NET Standard 1.3 compatible assemblies, because there is no such interface in .NET Core 1.0. However, they still have their public Clone() methods.

See Also

Compatibility