ADO.NET Provider for SQLite with ORM Support

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.

With 11 years of development history, dotConnect for SQLite provides an ultimate pack of robust data connectivity features and already empowers thousands of data-related .NET apps.

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.

Advanced Visual Studio Integration

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.0
Broad Compatibility

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:

Enhanced ORM Support

Features

ASP.NET

ASP.NET

Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.
BIS

BIS

Enables Integration Services to export and import data to/from SQLite databases.
Monitoring

Monitoring

Allows per-component tracing of database events with a free dbMonitor application.
More features
More ADO.NET providers
Related Articles

Related Products

What our customers say

Yigit Aktan
Senior Solution Engineer, Premier Mission Critical (PMC) Team at Microsoft
I used dotConnect for SQLite provider on my testing development and I can say it was fast!, reliable and really suitable to easily develop SQLite database based projects. I will suggest your provider if my colleagues need it.
Simon Kingaby
Piedmont Natural Gas
I have got to say that you guys are the most responsive group when it comes to fixing bugs. Many of the problems I have posted about have specifically been addressed in a subsequent release of your dotConnect for SQLite or Entity Developer products. This one wasn't even a complaint and you fixed it anyway. Thank you! Please keep up the great customer service, you guys are awesome!
Robin Warren
Ibis Biosciences
...Really like your product, by the way. I had previously used the EFSQLiteProvider example provided by MS, and actually got that working in our system, but was it ever slow!! Installing dotConnect for SQLite was easy, and the speed improvement was obvious.