Devart dotConnect for SQLite v5.17.1782 Professional
Devart dotConnect for SQLite v5.17.1782 Professional
dotConnect for SQLite is a high-performance ORM enabled data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.
Our ADO.NET SQLite provider supports a wide range of SQLite-specific features, such as user-defined functions, CEROD, SQLiteCrypt, and SEE encryption extensions, support for enabling SQLite extensions with connection string parameters, etc.
Advanced Visual Studio Integration
dotConnect for SQLite provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.
SQLite ADO.NET Provider supports advanced Visual Studio integration (DDEX), and provides convenient visual component editors to simplify component tweaking.
Broad Compatibility
dotConnect for SQLite was the first SQLite database provider to support .NET Core and Entity Framework Core, and we work hard to support new platforms and development technologies as soon as they are released.
Visual Studio support: 2008 – 2019
Platforms support:
Full .NET Framework 2.0 – 4.8
.NET Core 1.x, 2.x, and 3.1
Enhanced ORM Support
dotConnect for SQLite offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our SQLite ADO.NET Provider supports the following ORMs:
Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, and 3.1
NHibernate
LinqConnect
5.17.1782 03-Dec-20
The sqlite3.dll library that is included into the installation package is updated to version 3.34.0
Visual Studio 2019 version 16.9 Preview is supported
The bug with using URI format with file path in the Data Source connection string parameter is fixed
The bug with updating projects that reference EF6 provider assembly via Upgrade Wizard is fixed
Entity Developer
The new features are supported in Entity Framework 5.0:
TPT inheritance
Many-to-many associations
The new types of properties IPAddress and PhysicalAddress
The Model Refactoring functionality is supported for classes in EF Core Model
The behavior is changed in a standalone Entity Developer: by default the Target Framework model property in EF Core Model is set to .NET 5 instead of .NET Framework
The bug with saving non-default value of Target Framework model property in EF6 model modified with a standalone Entity Developer is fixed
The bug with adding new arguments at the end of argument list instead of actual position in method signature by Update From Database Wizard is fixed
Entity Framework support
Entity Framework Core 5.0 is supported
Entity Framework Core 3.1.10 is supported
The behavior is changed: EF Core 3 assemblies available via NuGet package are compiled for .NET Standard 2.0 instead of .NET Standard 2.1
The behavior is changed: EF Core 2 assemblies are no longer available via NuGet package but created in the provider installation folder
The bug with using another context's connection in DbContextOptionsBuilder.UseSQLite(connection) in EF Core is fixed
The sqlite3.dll library that is included into the installation package is updated to version 3.34.0
Visual Studio 2019 version 16.9 Preview is supported
The bug with using URI format with file path in the Data Source connection string parameter is fixed
The bug with updating projects that reference EF6 provider assembly via Upgrade Wizard is fixed
Entity Developer
The new features are supported in Entity Framework 5.0:
TPT inheritance
Many-to-many associations
The new types of properties IPAddress and PhysicalAddress
The Model Refactoring functionality is supported for classes in EF Core Model
The behavior is changed in a standalone Entity Developer: by default the Target Framework model property in EF Core Model is set to .NET 5 instead of .NET Framework
The bug with saving non-default value of Target Framework model property in EF6 model modified with a standalone Entity Developer is fixed
The bug with adding new arguments at the end of argument list instead of actual position in method signature by Update From Database Wizard is fixed
Entity Framework support
Entity Framework Core 5.0 is supported
Entity Framework Core 3.1.10 is supported
The behavior is changed: EF Core 3 assemblies available via NuGet package are compiled for .NET Standard 2.0 instead of .NET Standard 2.1
The behavior is changed: EF Core 2 assemblies are no longer available via NuGet package but created in the provider installation folder
The bug with using another context's connection in DbContextOptionsBuilder.UseSQLite(connection) in EF Core is fixed
Only for V.I.P Warning! You are not allowed to view this text.