Devart dotConnect for SQLite v6.1.151.0 Professional
Devart dotConnect for SQLite v6.1.151.0 Professional
dotConnect for SQLite is a high-performance ORM enabled ADO.NET provider for SQLite. It 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.
dotConnect for SQLite is the best solution to use SQLite in .NET Framework and develop SQLite .NET applications. It allows integrating SQLite with .NET data-related technologies, like ADO.NET, Entity Framework, Entity Framework Core and build all kinds of SQLite .NET applications - ASP.NET applications and websites, Console, WinForms, .NET MAUI apps, etc.
Our .NET Framework data provider for SQLite 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. It supports Visual Studio 2019, 2017, 2015, 2013, 2012, 2010, and 2008.
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. It supports the following .NET platforms:
.NET 5.0
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 includes Entity Framework provider and Entity Framework Core provider (Devart.Data.SQLite.EFCore) and supports the following ORMs:
Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, 3.1, 5.0, and 6.0
NHibernate
LinqConnect
Dapper
6.1.151 01-Jun-23:
Visual Studio 2022 version 17.7 Preview is supported
The sqlite3.dll library that is included into the installation package is updated to the version 3.41.1
Entity Framework support
Entity Framework Core 7.0.5 is supported
Entity Framework Core 6.0.16 is supported
The bug with ignoring schema set for indexes via CreateIndex() and DropIndex() operations of EF Core Code-First Migrations is fixed
The bug with incorrect SQL translation of reused LINQ query, which includes array.Contains() and other expressions, in EF Core 5/6/7 is fixed
The bug with generating parameter prefixed by a double colon in EF Core 7 is fixed
Entity Developer
The behavior is changed: the primitive properties by default have Inheritance Modifier = None
The bug with the detection of non-existent changes while updating a model from a database is fixed
The bug with creating Devart Entity Model in Visual Studio 2022 is fixed
The bug with missing model context namespace in EntityFrameworkUnitOfWork.cs produced by the Repository And Unit of Work template (C#) in EF Core is fixed
The bug with generating incorrect scale in mapping for decimal columns by the EF Core template (Visual Basic) in EF Core 5 and higher is fixed
The bug with code generation for TPT inheritance in the EF Core template is fixed
Visual Studio 2022 version 17.7 Preview is supported
The sqlite3.dll library that is included into the installation package is updated to the version 3.41.1
Entity Framework support
Entity Framework Core 7.0.5 is supported
Entity Framework Core 6.0.16 is supported
The bug with ignoring schema set for indexes via CreateIndex() and DropIndex() operations of EF Core Code-First Migrations is fixed
The bug with incorrect SQL translation of reused LINQ query, which includes array.Contains() and other expressions, in EF Core 5/6/7 is fixed
The bug with generating parameter prefixed by a double colon in EF Core 7 is fixed
Entity Developer
The behavior is changed: the primitive properties by default have Inheritance Modifier = None
The bug with the detection of non-existent changes while updating a model from a database is fixed
The bug with creating Devart Entity Model in Visual Studio 2022 is fixed
The bug with missing model context namespace in EntityFrameworkUnitOfWork.cs produced by the Repository And Unit of Work template (C#) in EF Core is fixed
The bug with generating incorrect scale in mapping for decimal columns by the EF Core template (Visual Basic) in EF Core 5 and higher is fixed
The bug with code generation for TPT inheritance in the EF Core template is fixed
Only for V.I.P
Warning! You are not allowed to view this text.