Devart is glad to announce the release of dotConnect for SQLite 5.10, Devart ADO.NET data provider for SQLite with support for Entity Framework, LinqConnect (LINQ to SQLite) and NHibernate. The new version offers you support for .NET Standard 2.0, .NET Core 2.0 and Entity Framework Core 2.0
.NET Standard Compatible Assemblies
dotConnect provider for SQLite now has .NET Standard compatible assemblies both for .NET Standard 1.3 and .NET Standard 2.0. .NET Standard 2.0 assemblies require .NET Core 2.0 or later or Full .NET Framework 4.6.1 or later. .NET Standard 2.0 compatible assemblies are not included in the product installers and are available only via NuGet packages, as well as .NET Standard 1.3 compatible assemblies.
NuGet packages of dotConnect for SQLite now include both .NET Standard 1.3 and .NET Standard 2.0 compatible assemblies. The corresponding assemblies are selected automatically, depending on the target framework of your project.
Not all provider features, available for Full .NET Framework are also available in .NET Standard compatible assemblies. However, the new .NET Standard 2.0 compatible assemblies support much more features, that are not available in .NET Standard 1.3 compatible assemblies. Particularly, the new assemblies include support for distributed transactions, DataAdapter and CommandBuilder classes, Dump classes, etc. You can see the full list of features in the dotConnect for SQLite documentation.
Technical Licensing
.NET Standard 2.0 compatible assemblies use the same licensing mechanism as .NET Standard 1.3 compatible assemblies. They use either license key files placed to a specific folder (C:\ProgramData\Devart\dotConnect\License\) or license keys provided as a connection string parameter. Note that trial license key files are generated by the trial installers of our product. If you want to try the .NET Standard compatible assemblies of our products, distributed via NuGet packages, you will still need to install the product in order to obtain the trial license key file. You can find more information about technical licensing in the dotConnect for SQLite documentation.
New Features in Entity Developer
The new version of Entity Developer supports Entity Framework Core 2.0. Now you can design both Entity Framework Core 1.1 and 2.0 models. In Entity Framework Core 2.0 models you can use complex types for entity properties, Entity Framework Core 2.0 native mapping for database scalar functions, table splitting, generate self-contained type configuration code, etc.
Additionally, the new version of Entity Developer now supports executing LINQ queries against the model and retrieving data when working with projects, targeting .NET Core or .NET Standard.
Here is the complete list of dotConnect for SQLite 5.10.1013 features:
- .NET Standard 2.0 is supported
- .NET Standard 2.0 compatible assemblies are added to the Devart.Data and Devart.Data.SQLite NuGet packages
- The SQLiteDataAdapter and SQLiteCommandBuilder are implemented
- The SQLiteConnection.GetSchema() and SQLiteDataReader.GetSchemaTable() methods for metadata retrieving are implemented
- The SQLiteDump class is implemented
- Component classes in .NET Standard 2.0 compatible assemblies are inherited from the Component class, and some of them implement the ICloneable and ISupportInitialize interfaces
- Some of the classes, representing data types, now implement the INullable and ISerializable interfaces
- .NET Core 2.0 is supported
- The sqlite3.dll library that is included into the installation package is updated to version 3.21.0
- .NET Standard 2.0 is supported
- .NET Core 2.0 is supported
- The bug with .Union().Any() is fixed
- .NET Standard 2.0 projects in Visual Studio 2017 are supported
- .NET Core 2.0 projects in Visual Studio 2017 are supported
- Entity Framework Core 2.0 is supported
- The Retrieve Data functionality via Model Explorer for EF Core 2 is implemented
- The bug with escaping invalid XML characters in the comments generated by templates is fixed
- Entity Framework Core 1.1.3 is supported
- Entity Framework Core 2.0 is supported
http://www.devart.com/dotconnect/sqlite/