dotConnect for SQLite Features

Table of Contents

  1. General usability
  2. Network and connectivity
  3. Compatibility
  4. SQLite technology support
  5. Performance
  6. ADO.NET technology support
  7. ADO.NET Entity Framework
  8. LinqConnect (formerly known as LINQ to SQLite)
  9. Extended data access technologies and functionality
  10. Business Intelligence Solutions Support
  11. WinForms-specific features
  12. ASP.NET-specific features
  13. Script execution
  14. SQL execution monitoring
  15. Design-time enhancements
  16. Product clarity
  17. Licensing and support

General usability

  • Real RAD for database applications
  • Fully compliant with ADO.NET
  • 100% managed code
  • Highly usable design time support
  • Easy to deploy

Compatibility

  • Full support of the latest versions of SQLite
  • Support for both x64 and x86 architecture
  • .NET 7 support
  • NEW!
  • .NET 6 support
  • .NET 5 support
  • .NET Core 3.x, 2.x, and 1.x support
  • .NET Standard 2.1, 2.0 1.6, 1.5, 1.4, and 1.3 support
  • .NET Frameworks 4.8, 4.7, 4.6, 4.5, 4.0, 3.5, 2.0 support
  • Microsoft Visual Studio 2008, 2010, 2012, 2013, 2015, 2017, 2019 and 2022 support
  • CodeGear RAD Studio 2007 support
  • Embarcadero Delphi Prism support
  • SQL Server 2008 Business Intelligence Solutions support
  • Sync Framework support

SQLite technology support

  • All SQLite data types support
  • User-defined functions support
  • SQLiteDump component to store a database or its parts as a script and then restore it
  • The CEROD, SEE, SQLiteCrypt, and SQLCipher extensions support
  • Ability to enable extensions with the EnableLoadExtension connection string parameters
  • SQLite Online Backup API support

Performance

  • High overall performance
  • Intelligent fetch block size control
  • Advanced connection pooling
  • High performance batch processing
  • Native Library Pre-Loading

ADO.NET technology support


ADO.NET Entity Framework

  • Conceptual approach to enterprise development
  • High performance
  • Wide support for LINQ to Entities
  • Entity Framework Code First support
  • Entity Framework Code First Migrations support
  • Wide support for EntitySQL
  • Full CRUD (Create, Retrieve, Update, Delete) support
  • Wide support for server data types
  • Entity Framework Core Spatials support
  • Change tracking support
  • Object data caching
  • Inheritance mapping support (TPH, TPT, and TPCT models)
  • Capability to use stored procedures when manipulating data
  • Stored procedure import support
  • Ability to build database-independent applications
  • Full-text search support
  • Visual Studio EDM Wizard support
  • Reverse engineering of database objects to entity model
  • Support for most Entity Framework Canonical Functions
  • Visual model creation and code generation with Entity Developer
    • Update Model From Database functionality for Entity Developer
    • Update To Database with Mapping Synchronization functionality for Entity Developer

LinqConnect (formerly known as LINQ to SQLite)

  • Easy to use
  • High performance
  • Interchangeable with Microsoft LINQ to SQL
  • Plain CLR classes used (no need to use a common base class)
  • Full CRUD (Create, Retrieve, Update, Delete) support
  • Fluent Mapping support
  • Ability to execute DML statements in batches on SubmitChanges
  • Complex type support
  • PLINQ support (connection manager redesigned for thread safety)
  • Support for different configurable algorithms for primary key generation
  • Inheritance mapping support (Table Per Hierarchy and Table Per Type)
  • Support of Visual Studio Debugger Visualizer for the DataQuery objects
  • ASP.NET Dynamic Data support with ASP.NET Dynamic Data project templates
  • Automatic configurable compiled query caching
  • Change tracking support
  • Object data caching
  • Data binding support
  • Wide support for LINQ capabilities
  • Wide support for server data types
  • Load on demand (lazy load)
  • Database transactions support
  • Server-independent interface
  • Visual model creation and code generation with Entity Developer
    • Update Model From Database functionality for Entity Developer
    • Update To Database with Mapping Synchronization functionality for Entity Developer
  • Illustrated tutorial to get started with LinqConnect in 5 minutes

Extended data access technologies and functionality

  • Powerful SQLiteDataTable component for manipulating individual tables or query result
  • NonBlocking mode allows fetching data asynchronously in the background
  • On-demand data fetch for data-bound controls
  • Paginal access to query result
  • Server side master-detail relation based on queries
  • Support for Enterprise Library Data Access Application Block (DAAB)
  • Object-oriented building of SELECT statements
  • Extended warning and error information retrieval
  • Extended interface for processing execution exceptions
  • SQLiteDataAdapter.Fill method with sequential fetch support
  • Ability to defer fetching of some columns in a resultset
  • Named parameters support

Business Intelligence Solutions Support

  • SSIS DataFlow Source and Destination components
  • Analysis Services support
  • Reporting Services support

WinForms-specific features

  • Flexible data binding with DataLink component
  • InterForm technology for cross-form components cooperation
  • Global position synchronization within a data source

ASP.NET-specific features


Script execution

  • Advanced script execution features with SQLiteScript component
  • Support for executing individual statements in scripts
  • Support for executing huge scripts stored in files with dynamic loading

SQL execution monitoring

  • Extended SQL tracing capabilities with SQLiteMonitor component
  • Support for dbMonitor utility for advanced tracing analysis and control
  • Per-component SQL tracing
  • Optional log output to IDE toolwindows

Design-time enhancements


Product clarity

  • Complete documentation sets integrated into Visual Studio and CodeGear Delphi
  • Integration with Visual Studio and MSDN help collections
  • Documentation available as a standalone chm file
  • A large amount of helpful demos in C#, VB, C++, and Delphi

Licensing and support

  • Included annual dotConnect for SQLite Subscription with Priority Support
  • Licensed royalty-free per developer, per team, or per site