dotConnect for SQLite

dotConnect for SQLite is an enhanced ORM enabled data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. With support for Entity Framework, NHibernate, and LinqConnect ORMs, it introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.

Fast and Advanced ADO.NET Provider
dotConnect for SQLite offers both high-performance connectivity to the SQLite database and a number of innovative development tools and technologies. It supports a wide range of SQLite-specific features, such as user-defined functions, CEROD and SEE encryption extensions, support for enabling SQLite extensions with connection string parameters, etc.

RAD Approach
dotConnect for SQLite provides a vast number of GUI tools that increase your productivity. It integrates into Visual Studio Server Explorer and other tools and provides advanced visual component editors to simplify component tweaking. DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.

ORM Solutions
The app for SQLite offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. dot Connect for SQLite supports ADO.NET Entity Framework, NHibernate, and LinqConnect (formerly known as LINQ to SQLite) - our own ORM solution, closely compatible to Microsoft LINQ to SQL, while extending its functionality with its own features.

Features and Highlights

• 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 .NET 2005 and 2008 support
• CodeGear RAD Studio 2007 support
• SQL Server 2005 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
• Full support for ADO.NET Entity Framework
• 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
• 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)
• The 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 provider, Role provider, Session State provider, a Profile provider
• SQLiteDataSource web component
• SQLiteCacheDependency component to control Cache item dependencies in ASP.NET applications
• Script execution
• 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 .NET and Borland Delphi
• Integration with Visual Studio and MSDN help collections
• Documentation available as a standalone chm file
• A large number of helpful demos in C#, VB, C++, and Delphi

Note: 30 days trial version. Requires .NET Framework