Even within the same solution, projects can have different packages added. Also be aware that NuGet packages are added on a per-project basis. If you don't know which you need then you can just add the Core package for now and add the other later if you need it. Do you want that support? That is what determines which package to add. As the descriptions say, they are both the official SQLite database engine and ADO.NET provider but, unlike the Core package, the first adds support for LINQ and EF6. Notice that the new options start with System.Data, which is generally reserved for Microsoft's own types.Īs for the other two, if you check the dependencies for each you will see that the first has a dependency on the second. Microsoft used to provide its own SQL Server CE but presumably decided that there was no point trying to compete withy SQLite as it already did what.
That was from before Microsoft embraced SQLite as it's recommended file-based database system. The last one was last updated almost 4 years ago, so clearly not the right option. While I stated my ultimate goal above can I also assume NuGet will put the SQLite package in the project Reference Folder The question is I want to have a self contained EXE project once packaged The Last option here seemed like the correct and logical choice then I looked at this SO PostĪfter 3 days of reading and searching I have given up hence the confusion has won This package contains native libraries for SQLite on Linux, macOS, and Windows (desktop and Universal Windows apps). SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. This package includes support for LINQ and Entity Framework 6. The official SQLite database engine for both x86 and 圆4 along with the ADO.NET provider. It seems the NuGet Ice Cream Store has a lot of flavors of SQLite The project is a WinForms app and I might try UWP apps My ultimate goal here is to install the correct SQLite package in Visual Studio 2019 on a Windows 7 SP 1 64 bit
0 kommentar(er)
