What is dotConnect for SQLite used for?

dotConnect for SQLite is an enhanced data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. As part of the Devart database application development framework, dotConnect for SQLite offers both high performance native connectivity to the SQLite database and a number of innovative development tools and technologies. It also introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.

How to deploy an app written with dotConnect for Salesforce?

To deploy applications written with dotConnect for SQLite you should register run-time assemblies Devart.Data.SQLite.dll and Devart.Data.dll at Global Assembly Cache (GAC) for appropriate framework or place them in the folder of your application (Bin folder for web projects). These two assemblies should be available in all applications written with dotConnect for SQLite. Make sure that your project contains the license resource as it is described in Licensing. Your application should also have access to the sqlite3.dll library. This library can be located either in the application folder or in a system-wide accessible folder. The bitness (32-bit or 64-bit) of the library must correspond to the bitness of your application.

How to install and configure dotConnect for Salesforce?

dotConnect for SQLite is provided as a single setup package and contains all required files for Full .NET Framework and documentation. You can easily download it from the Devart website. To connect to SQLite database in design-time, follow the steps below: 1. Run an IDE. 2. Open Toolbox and find SQLiteConnection component in dotConnect for SQLite Data tab. 3. Double-click the component. Note that new object appears on the designer underneath the form. If this is first time you create SQLiteConnection in this application, it is named sqLiteConnection1. 4. Click on the sqLiteConnection1 object and press F4 to focus on object's properties. 5. Set the ConnectionString property to 'FailIfMissing=False;'. This will allow dotConnect for SQLite to create the needed file. If you already have the database file, you may skip this step. 6. Specify the path to your database file in the DataSource property. E.g.: D:\TestApplication\database.db. 7. Note that as you assign values to these properties the ConnectionString property is automatically updated to reflect your settings. Now it contains something like Data Source=D:\TestApplication\database.db;FailIfMissing=False.

dotConnect for SQLite

.NET 10 available

PM> Install-Package Devart.Data.SQLite

Supported Platforms

See in action

.NET Connector for SQLite With ORM Support

dotConnect for SQLite is a versatile enterprise-grade connector that enables access to SQLite data in .NET applications of any complexity. It delivers advanced ORM support, compatibility with multiple SQLite versions and .NET platforms, and easy integration with a variety of IDEs, including Microsoft Visual Studio.

The connector undergoes regular security and performance testing to ensure reliability and consistent quality. It also includes premium support, frequent updates, and detailed documentation to help you get started quickly.

Advanced ORM support: EF Core, Dapper, NHibernate, LinqConnect, and more
Full compliance with ADO.NET standards
Advanced encryption methods: CEROD, SEE, SQLiteCrypt, and SQLCipher
Support for all SQLite data types, user-defined functions, and more
Support for non-blocking, on-demand data loading with paginal access and query-based master-detail relationships
Top performance with intelligent fetch sizing, deferred column loading, and efficient batch execution
Integration with Visual Studio

Simple connection
Encrypted connection

C# Copy code

using Devart.Data.SQLite;

class Program
{
  static void Main()
  {
    using SQLiteConnection conn = new(
      "Data Source=path\\to\\your\\sakila.db;" +
      "License Key=**********");
    conn.Open();
  }
}

C# Copy code

using Devart.Data.SQLite;

class Program
{
  static void Main()
  {
    using SQLiteConnection conn = new(
      "Data Source=path\\to\\your\\sakila.db;" +
      "Encryption=AES256;" +
      "FailIfMissing=false;" +
      "Password=best;" +
      "License Key=**********");
    conn.Open();
  }
}

Worry-free connection to SQLite

dotConnect for SQLite, first and foremost, provides a quick and easy connection to SQLite databases, supporting both simple and encrypted connections.

Easy connection without any client libraries
Full support for SQLite-specific data types
Robust security features with advanced encryption and authentication
Flexible connectivity options for diverse operational environments
Cost-effective deployment

Connection details

Advanced ORM support

dotConnect for SQLite offers enhanced ORM support with a bundled Entity Developer – visual designer for ORM models:

Entity Framework Core

1.x, 2.x, 3.x, 5.0, 6.0, 7.0, 8.0, 9.0

NHibernate

1.x-5.x

Entity Framework

v1-v6

Dapper

1.x, 2.x

Entity Developer supports multiple ORM technologies and automatically generates entity classes and the DbContext class, helping simplify development and keep the data model in sync with the database.

Explore the features

Integrated SQLite encryption

Our data provider perfectly works with SQLite Encryption Extension, an add-on that encrypts SQLite databases and thus protects sensitive data, eliminating any need for third-party encryption solutions. Additionally, you will be able to protect your data with the following algorithms: AES, Blowfish, TripleDES, Cast128, RC4.

Explore the features

Compatibility and integration

Platforms

.NET 5.0, 6.0, 7.0, 8.0, 9.0, 10.0
.NET Framework 2.0-4.8
.NET Core 2.0-3.1
ASP.NET Core Blazor
.NET MAUI

SQLite

All versions

Visual Studio Extension

Data source connection
Database object explorer
Data retrieval and display

Compatibility with NuGet

Works in any NuGet-compatible IDE like VS Code, JetBrains Rider, etc.

Compatibility details

Features

Database-specific features

dotConnect for SQLite delivers all-encompassing support for various database-specific features, including different connection modes and protocols, data types, and optimized components for bulk data operations and database script handling.

Advanced durability

Our data provider offers advanced data fetching control, including background loading, on-demand access, and pagination support. Features like refreshing specific records and selectively loading columns help optimize application performance when working with SQLite’s local data storage.

Microsoft technology support

dotConnect for SQLite is fully compatible with Microsoft's data-oriented technologies, including but not limited to Microsoft Enterprise Library, various ASP.NET providers, ExtendedMembership providers, and Microsoft Sync Framework.

Secure connections

The SQLite Encryption Extension (SEE) is an add-on to the public domain version of SQLite that enables applications to read and write encrypted database files (comprising both data and metadata). Our data provider works with a number of encryption algorithms, including AES, Blowfish, TripleDES, Cast128, RC4.

Fast data loading

Our data provider allows importing even large datasets into SQLite databases with exceptional speed and efficiency. This greatly facilitates faster initialization, data population, and overall improved performance during data-intensive operations.

Integration with Visual Studio

dotConnect for SQLite supports advanced Visual Studio integration (DDEX) and provides intuitive visual editors to help tweak components in the most convenient way. Seamless support for Visual Studio goes all the way up to the latest version.

View all features

Leading companies choose dotConnect

Other .NET connectors for databases

Your universal ADO.NET provider for multiple database systems

dotConnect Universal

dotConnect Universal offers universal access to data of different databases for the Microsoft .NET Framework. It supports the most popular database servers, including Microsoft SQL Server, Microsoft Access, Oracle Database, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.

$269.95

Developer edition

Buy now

Connect to SQLite in .NET Applications

Discover how to directly access SQLite databases in .NET applications using the advanced capabilities of dotConnect for SQLite, Entity Developer, and Entity Framework Core.

Using Entity Framework Core With SQLite

This in-depth article will help you learn to use EF Core with SQLite, covering everything from integration with Entity Framework and creation of an EF Core model to operations with data.

SQLite Connection Strings

SQLite connection strings provide the parameters that are necessary to establish a successful connection to SQLite databases. Learn all about them from our comprehensive guide.

Get started with dotConnect for SQLite at no cost

Download a FREE, fully-functional trial version and elevate your database development and administration today!

Download for free

Try dotConnect Universal

Universal access to data of different databases for the Microsoft .NET Framework. It supports most of the major database servers, including Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird.

Get now

Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with our team.

Contact support

Try the 30-day trial of the full product. No limits. No card required. Start free trial