dotConnect for SQLite Features

General usability

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 and SEE extensions support
Ability to enable extensions with the EnableLoadExtension connection string parameters

Conceptual approach to enterprise development
High performance
Wide support for LINQ to Entities
Entity Framework Code First support [New]
Entity Framework Code First Migrations support [New]
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 Studio EDM Wizard support
Reverse engineering of database objects to entity model
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

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

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

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

Automatic component registration in toolbox
Advanced integration with Visual Studio 2008, 2010, and 2012, 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 dotConnect for SQLite classes
Syntax highlighting in design-time editors
TableMappings editor
Convenient instant data preview and management in design time