dotConnect for SQLite Documentation
In This Topic
    NuGet Packages
    In This Topic

    dotConnect for SQLite has three sets of assemblies:

    dotConnect for SQLite also has .NET Standard 2.0 compatible assemblies for Entity Framework 6.3 and Entity Framework Core 3 support on .NET Core 3.0 and higher. .NET Standard compatible assemblies are only available as NuGet packages.

    The dotConnect for SQLite NuGet packages are added to your project from nuget.org as usual, via the Package Manager Console. The dotConnect for SQLite NuGet packages contain .NET Standard compatible assemblies for all the supported .NET Standard versions - 1.3 and 2.0. The corresponding assemblies are selected automatically, depending on the target framework of your project.

    Installing dotConnect for SQLite NuGet Packages

    When you are developing your solutions in not very old Visual Studio versions, it is very easy to add dotConnect for SQLite NuGet packages to your projects. You need simply to open the Package Manager Console by selecting Package Manager Console from the Tools -> NuGet Package Manager menu, and then enter and run the necessary command:

    For projects, using general ADO.NET functionality of dotConnect for SQLite, you need to install the Devart.Data.SQLite package. Execute the following command in the Package Manager Console:

    Install-Package Devart.Data.SQLite

    For projects, using LinqConnect features of dotConnect for SQLite, you need to install the Devart.Data.SQLite.Linq package. Execute the following command in the Package Manager Console:

    Install-Package Devart.Data.SQLite.Linq

    For projects, using Entity Framework Core 1, 3, 5, or 6 with SQLite, install the Devart.Data.SQLite.EFCore package. Execute the following command in the Package Manager Console:

    Install-Package Devart.Data.SQLite.EFCore

    For projects, using Entity Framework Core 1.1, for which you use database-first approach and generate an Entity Framework Core mapping via the Scaffold-DbContext command of Package Manager Console, you need to install the Devart.Data.SQLite.EFCore.Design package. Execute the following command in the Package Manager Console:

    Install-Package Devart.Data.SQLite.EFCore.Design

    Note that this package is not needed any more for Entity Framework Core 2.0 and higher. All the needed functionality Entity Framework Core 2.0 and higher is included to the Devart.Data.SQLite.EFCore package.

    For projects, working with spatial data in Entity Framework Core 3 with SQLite, install the Devart.Data.SQLite.EFCore.NetTopologySuite package. Execute the following command in the Package Manager Console:

    Install-Package Devart.Data.SQLite.EFCore.NetTopologySuite

    For projects, using Entity Framework 6.4 with SQLite on .NET Core 3, the Devart.Data.SQLite.EF6 NuGet package should be installed. Execute the following command in the Package Manager Console:

    Install-Package Devart.Data.SQLite.EF6

    There also are Visual Studio extensions for earlier Visual Studio versions. If you use some other tool than Visual Studio, you can get NuGet packages with the nuget.exe console tool.

    Note that .NET Standard 2.0 compatible assembly for Entity Framework Core 2, Devart.Data.SQLite.Entity.EFCore.dll, is not available via NuGet packages. It is installed to your computer with the dotConnect for SQLite installer, and you can get it from the \Entity\EFCore2\netstandard2.0\ subfolder of the dotConnect for SQLite installation folder.

    See Also

    .NET Standard Compatibility