dotConnect for SQLite - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

dotConnect for SQLite by Devart (formerly Core Lab)

URLs: dotconnect-for-sqlite, dotconnect for sqlite, dotconnectforsqlite, devart

Develop SQLite-based database applications with ease. 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 a 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. dotConnect for SQLite introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.

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 2005/2008, Delphi, and SQL Server 2005 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 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

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 2005 and 2008, 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

What's new in dotConnect for SQLite V3.50?

Fluent Mapping support added

The bug inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed

The bug deleting dependent entities when other changes were made is fixed

The bug entity materialization for queries with multiple eager loading options is fixed

The bug saving (inserting or updating) System.Data.Linq.Binary objects is fixed

The bug creating foreign keys in SQLite databases on DataContext.CreateDatabase is fixed

Support for enumerated types ("enums") in LinqConnect and Entity Framework June 2011 CTP models is implemented

New skins to improve the apllication appearance implemented

Selection driven highlighting implemented

Capability for changing the shape color for entities, complex types and enums mplemented

Capability for selecting the diagram skin type implemented

Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower

The bug saving custom attribute properties with default values in .edml files is fixed

The bug changing property names ("Index was outside the bounds of the array") is fixed

The bug incorrect generation of the private variables names in Entity Framework models is fixed

What's new in dotConnect for SQLite V3.30?

A DbTransactionBase class added

TransactionStateChanging and TransactionStateChanged events added to the DbConnectionBase class

Policy file for the Devart.Data.SQLite.Entity assembly added

License Information Wizard improved: it now generates licenses for projects that have Entity Framework models or refer to Devart.Data.SQLite.Web, but have no direct references to Devart.Data.SQLite.dll

"Use schema name" checkbox added to the DataSet Wizard

Bug fix: dropping database objects when calling the SQLiteDump.Restore method

Bug fix: Membership provider compatibility between .NET Framework 2.0 and 4.0

Bug fix: launching Devart documentation via Start menu

What's new in dotConnect for SQLite V3.10?

Fixed bug with resetting CopyLocal property of Devart references to False after using Upgrade Wizard

Fixed bug with unicode characters when using Upgrade Wizard

Fixed bug with compatibility with Microsoft Team Foundation Server 2010 Power Tools (broken designers for WPF, Silverlight, etc)

Fixed Visual Studio integration conflict with Windows Phone Developer Tools

LinqConnect (formerly known as LINQ to SQLite)

Fixed bug with deserializing LinqConnect exceptions

Fixed bug with attaching entities as modified to DataContext

Entity Developer

Fixed code generation for many-to-many associations when the Unidirectional serialization mode is enabled (LinqConnect models)

Fixed some bugs in Table Per Concrete Type (TPC) design time support in Entity Framework models

Fixed bug with wrong Metadata Artifact Processing setting for Web Site projects in Entity Framework models

What's new in dotConnect for SQLite V2.90.140?

Supports password salt in ASP.NET membership provider

Improved Upgrade wizard

Fixed bug with Upgrade Wizard on web sites

Fixed bug with disposing data table with InterForm ParentRelation

Fixed bug with lost InterForm connection

Fixed bug with filling DevExpress ASPxGridView in Auto DataPagingMode of SQLiteDataSource

Fixed bug with extra empty string in CommandText

Fixed bug with named parameter used twice in the same command

Fixed bug with hashed passwords in Membership provider

What's new in dotConnect for SQLite V2.80.120?

Supports Visual Studio 2010

Install Wizard improved (ability to automatically uninstall previous version added)

ADO.NET Data Services v1.5 supported

Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors

The 3.6.22 version of sqlite3.dll included to the installation package

What's new in dotConnect for SQLite V2.60?

Integration with improved dbMonitor added

Added orderid column for Site Map provider for custom map node ordering

Added some DataSet Wizard design-time improvements

Fixed bug with MembershipProvider.GetAllUsers() method

Fixed bug with DataLink.DataSource property after regeneration of DataSet

Develop SQLite-based database applications with ease.

Pricing: dotConnect for SQLite V3.50 - Professional 1 Developer License - with 1 Year Subscription, dotConnect for SQLite V3.50 - Professional 4 Developer Team License - with 1 Year Subscription, dotConnect for SQLite V3.50 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , dotConnect for SQLite Professional Subscription Renewals 1 Developer License Subscription Renewal , dotConnect for SQLite Professional Subscription Renewals 4 Developer Team License Subscription Renewal, dotConnect for SQLite Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal

Evals & Downloads: Read the dotConnect for SQLite License Agreement, Download the dotConnect for SQLite V3.50 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Vista, Windows XP

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET Class

Compatible Containers: Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Keywords: sql lite sqllite

crlab corelab

Database DB Connectivity

Part numbers: PC-532786-401089 532786-401089 PC-532786-401090 532786-401090 PC-532786-401091 532786-401091 PC-532786-401092 532786-401092 PC-532786-401093 532786-401093 PC-532786-401094 532786-401094