dotConnect for SQLite is a library for providing data access to SQLite based database applications. It includes support for Object-relational mapping (ORM), is based on ADO.NET and implements a number of ASP 2.0 providers. It also comes packed with various tools for enhancing user's productivity.
It provides fast database connectivity and supports a number of SQLite native functionality, such as CEROD and SEE encryption extensions, user-defined functions and others. In addition, it can be also integrated into various third-party IDEs, namely Visual Studio, Delphi Prism and RAD Studio.
A number of visual components for simplifying various aspects of database connectivity process are included with the library. This components consist of various graphical wizards, editors and managers.
In addition to providing its own solution for visual creation of ORM models, it also supports other ORM solutions, namely ADO.NET Entity Framework, NHibernate and LinqConnnect (extends functionality of Microsoft LINQ to SQL).
For identifying DB events related to dotConnect for SQLite components, you can rely on external and freely available database monitoring application, called dbMonitor. While, for importing and exporting of data to/from SQLite databases, you can make use of added support for Integration Services.
Reviewed by Tony Hill (editor rating 4 out of 5 stars)