dotConnect for SQLite 2.00

dotConnect for SQLite 2.00 offers you a great application for connection. This is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies.

dotConnect offers a complete solution for developing database-related applications and web sites. With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database application development.

 dotConnect for SQLite supports SQLite engine version 3 and higher. The provider works with .NET Framework 2.0, 3.0, and 3.5. dotConnect for SQLite is compatible with the latest version of ADO.NET Entity Framework, and can be used with the following integrated development environments:

• Microsoft Visual Studio 2008
• Microsoft Visual Studio 2005
• Delphi 2007
  

Delphi for .NET and RAD Studio 2007 are supported in run time only as these environments have no WinForms designers.

 Major Advantages:

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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.
9. 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. 

Major Features:

1. Direct access to SQLite database
2. 100% managed code
3. High performance
4. Easy to deploy
5. Supports the latest versions of SQLite database
6. All SQLite data types support
7. Entity Framework support
8. LINQ to SQLite support
9. Operates in both connected and disconnected models
10. Powerful SQLiteDataTable component as all-in-one table data access solution
11. Auxiliary components for SQL scripts and bulk data transfer
12. Extra data binding capabilities
13. Cross-form components cooperation
14. Ability of monitoring query execution
15. Licensed royalty-free per developer, per team, or per site

Enhancements:

• Supported LINQ to SQLite
• Supported SQLite engine library version 3.6 and above
• Added Entity Developer for LINQ to SQLite
• Renamed assemblies, namespaces, and classes 

Requirements: .NET Framework

 WareSeeker Editor