Advantages of dotConnect for SQLite

Wide Coverage of SQLite Features - By providing access to the most advanced database functionality, dotConnect for SQLite allows developers to harness the full capabilities of the SQLite database engine and optimize their database applications. dotConnect for SQLite stands out as the set of components with the widest support of SQLite functionality.

Optimized Code - The goal of dotConnect for SQLite is to enable developers to write efficient and flexible database applications. The dotConnect for SQLite assemblies are implemented using optimized code and advanced data access algorithms. Components undergo comprehensive performance tests and are designed to help you write thin and efficient product data access layers.

Comprehensive Support for ADO.NET Technology Features - dotConnect for SQLite supports new ADO.NET features and technologies as soon as they are released. This includes base-class-based provider model, provider factories, connection string builder, metadata schemas, asynchronous commands, pooling enhancements, batch update support, provider-specific types, and so on. dotConnect for SQLite will continue supporting the newest standards and innovations of the .NET Framework.

Database Application Development Extensions - dotConnect for SQLite has a rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards and managers for typed SQLite-specific components, toolset for live data binding and much more. dotConnect for SQLite integrates tightly with Visual Studio, Delphi, and SQL Server Business Intelligence Solutions.

Provider-Specific Technologies - dotConnect for SQLite has extra components designed to simplify some tasks and support SQLite-specific technologies. Particularly, SQLiteScript serves to execute series of SQL statements, and SQLiteDump serves to backup or restore a whole database or its parts.

ADO.NET Entity Framework Support - ADO.NET Entity Framework is a conceptual approach to database application development with focus on objects instead of relational data.The flexible architecture of Entity Framework is made up of well-thought layers and modules. Entity Framework optimizes the development process with object-relational mapping, SQL-based entity query language, and LINQ. dotConnect for SQLite supports the Entity Framework capabilities, which allows you to base your object-oriented applications on SQLite. All standard Entity Framework samples can be easily ported to dotConnect for SQLite.

LINQ Support - dotConnect for SQLite includes support for LINQ to SQLite technology. The technology allows you to employ object-oriented database application development with less efforts and in less time. Compared to ADO.NET Entity Framework, LINQ to SQLite is better suited for RAD-style development, is easier to start with, and somewhat richer with server-oriented features like server-specific types. See our LINQ to SQLite tutorial for a quick start with the technology.

Both Connected and Disconnected Models - dotConnect for SQLite combines connected and disconnected data access models in a single SQLiteDataTable component, that allows you to design more flexible application architecture and use full power of data binding.

Development and Support - dotConnect for SQLite is a SQLite connectivity solution that has been actively developed and supported since 2007. dotConnect for SQLite comes with full documentation, demo projects, and fast (usually within one business day) technical support by the dotConnect for SQLite development team.

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
• Full support for x64 architecture
• Visual Studio support
• RAD Studio support
• SQL Server Business Intelligence Solutions support

SQLite technology support

• All SQLite data types support
• SQLiteDump component to store a database or its parts as a script and then restore it

Performance

• High overall performance
• Intelligent fetch block size control
• Advanced connection pooling
• High performance batch processing

ADO.NET technology support

• Support for ADO.NET Entity Framework [New]
• Batch update support
• Extended metadata information retrieval
• Enhanced pooling control through connection string
• Connection string builder
• Provider factory for generating key data access classes
• Asynchronous command execution
• Provider-specific types support

ADO.NET Entity Framework

• Conceptual approach to enterprise development
• High performance
• Wide support for LINQ to Entities capabilities
• Wide support for EntitySQL
• Full CRUD (Create, Retrieve, Update, Delete) support
• Wide support for server data types
• 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
• Visual model creation and code generation with Entity Developer   [New]

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
• 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
• Inheritance mapping support (table per hierarchy model)
• Server-independent interface
• Visual model creation and code generation with Entity Developer
• Illustrated tutorial to get started with LINQ to SQLite 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

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

• ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
• SQLiteDataSource web component
• SQLiteCacheDependency component to control Cache item dependencies in ASP.NET applications

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

• Automatic component registration in toolbox
• Advanced integration with Visual Studio, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SQLiteDataSource
• DataSet Wizard to create and edit typed SQLite-oriented datasets
• DataSet Manager to list and bind datasets in the project
• DataSet Editor to edit dataset contents
• Advanced design-time component and property editors
• IntelliSense descriptions for SQLite classes
• Syntax highlighting in design-time editors
• TableMappings editor
• Convenient instant data preview and management in design time

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