An enhanced data provider for SQLite-based database applications development
dotConnect for SQLite Standard 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 Core Lab database
application development framework, dotConnect for SQLite Standardoffers
both high performance native connectivity to the SQLite database and a number of innovative development tools and technologies.
dotConnect for SQLite Standard leverages database application implementation, boosts productivity and introduces new approaches for designing application architecture.
The current version of dotConnect for SQLite Standard can be used with the following integrated development environments:
· Microsoft Visual Studio .NET
· Delphi for .NET and RAD Studio
dotConnect for SQLite Standard leverages database application implementation, boosts productivity and introduces new approaches for designing application architecture.
The current version of dotConnect for SQLite Standard can be used with the following integrated development environments:
· Microsoft Visual Studio .NET
· Delphi for .NET and RAD Studio
Here are some key features of "dotConnect for SQLite Standard":
· 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)
· 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, Profile provider
· 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 .NET and Borland 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
· 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)
· 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, Profile provider
· 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 .NET and Borland 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 This Release:
· Visual Studio 11 Beta is supported
· The sqlite3.dll library that is included into the installation package is updated to version 3.7.10
LinqConnect (formerly known as LINQ to SQLite):
· The bug with column order in queries including the UNION clause is fixed
· The bug with InvalidOperationException on disposing data contexts is fixed
Entity Developer:
· The copy/cut/paste functionality is added for objects of the conceptual part of a model
· The possibility to drag&drop properties between classes in Model Explorer is implemented
· The "HeaderTimestampVersionControlTag" generation template option is added for improving integration with version-control systems
· The bug with setting StoreGeneratedPattern to Identity for foreign key property of the child class when creating an association is fixed (Entity Framework models)
· The bug with generating mappings for many-to-many association of entity to itself is fixed
Entity Framework support:
· Entity Framework 5.0 Beta 1 is s...
· Visual Studio 11 Beta is supported
· The sqlite3.dll library that is included into the installation package is updated to version 3.7.10
LinqConnect (formerly known as LINQ to SQLite):
· The bug with column order in queries including the UNION clause is fixed
· The bug with InvalidOperationException on disposing data contexts is fixed
Entity Developer:
· The copy/cut/paste functionality is added for objects of the conceptual part of a model
· The possibility to drag&drop properties between classes in Model Explorer is implemented
· The "HeaderTimestampVersionControlTag" generation template option is added for improving integration with version-control systems
· The bug with setting StoreGeneratedPattern to Identity for foreign key property of the child class when creating an association is fixed (Entity Framework models)
· The bug with generating mappings for many-to-many association of entity to itself is fixed
Entity Framework support:
· Entity Framework 5.0 Beta 1 is s...

No comments:
Post a Comment