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.

.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 all levels. 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.

Moreover, this connector regularly undergoes security and performance tests to make sure it stays ahead of the competition at all times. Extra benefits include premium support, frequent updates, and detailed documentation to help you with a quick and easy start.

Watch the video

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

Worry-free connection to SQLite

dotConnect for SQLite, first and foremost, provides quick and easy connection to SQLite databases, required in software development.

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

Learn more

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.

Compatibility and integration

Platforms

.NET 5.0, 6.0, 7.0, 8.0, 9.0
.NET Framework 2.0-4.8
.NET Core 1.x, 2.x, 3.0
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.

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 data fetching control (background, on-demand, pagination) and helps establish server-side data relationships. The refresh of specific records and selective column loading facilitate effective performance optimization.

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.

Leading companies choose dotConnect

Other .NET connectors for databases

Ready to get started?

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 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