dotConnect for SQLite Standard

dotConnect for SQLite Standard Description

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 Here are some key features of "dotConnect for SQLite Standard":General usabilityReal RAD for database applicationsFully compliant with ADO.NET100% managed codeHighly usable design time supportEasy to deployCompatibilityFull support of the latest versions of SQLiteFull support for x64 architectureVisual Studio .NET 2005 and 2008 supportCodeGear RAD Studio 2007 supportSQL Server 2005 Business Intelligence Solutions supportSQLite technology supportAll SQLite data types supportSQLiteDump component to store a database or its parts as a script and then restore itPerformanceHigh overall performanceIntelligent fetch block size controlAdvanced connection poolingHigh performance batch processingADO.NET technology supportFull support for ADO.NET Entity FrameworkBatch update supportExtended metadata information retrievalEnhanced pooling control through connection stringConnection string builderProvider factory for generating key data access classesAsynchronous command executionProvider-specific types supportExtended data access technologies and functionalityPowerful SQLiteDataTable component for manipulating individual tables or query resultNonBlocking mode allows fetching data asynchronously in the backgroundOn-demand data fetch for data-bound controlsPaginal access to query resultServer side master-detail relation based on queriesSupport for Enterprise Library Data Access Application Block (DAAB)Object-oriented building of SELECT statementsExtended warning and error information retrievalExtended interface for processing execution exceptionsSQLiteDataAdapter.Fill method with sequential fetch supportAbility to defer fetching of some columns in a resultsetNamed parameters supportWinForms-specific featuresFlexible data binding with DataLink componentInterForm technology for cross-form components cooperationGlobal position synchronization within a data sourceASP.NET-specific featuresASP.NET data providers: Membership provider, Role provider, Session State provider, Profile providerSQLiteDataSource web componentSQLiteCacheDependency component to control Cache item dependencies in ASP.NET applicationsScript executionAdvanced script execution features with SQLiteScript componentSupport for executing individual statements in scriptsSupport for executing huge scripts stored in files with dynamic loadingSQL execution monitoringExtended SQL tracing capabilities with SQLiteMonitor componentSupport for DBMonitor utility for advanced tracing analysis and controlPer-component SQL tracingOptional log output to IDE toolwindowsDesign-time enhancementsAutomatic component registration in toolboxAdvanced integration with Visual Studio 2005 and 2008, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SQLiteDataSourceDataSet Wizard to create and edit typed SQLite-oriented datasetsDataSet Manager to list and bind datasets in the projectDataSet Editor to edit dataset contentsAdvanced design-time component and property editorsIntelliSense descriptions for SQLite classesSyntax highlighting in design-time editorsTableMappings editorConvenient instant data preview and management in design timeProduct clarityComplete documentation sets integrated into Visual Studio .NET and Borland DelphiIntegration with Visual Studio and MSDN help collectionsDocumentation available as a standalone chm fileA large amount of helpful demos in C#, VB, C++, and Delphi Requirements:ADO.NET Framework.NET Framework What's New in This Release: [ read full changelog ]The bug with retrieving views in Business Intelligence Solutions projects is fixedLinqConnect (formerly known as LINQ to SQLite):The bug with wrong order for creation tables with the many-to-many associations via the CreateDatabase() method is fixedThe bug with the entity cache (EntityCacheMode.WeakReference) is fixedEntity Developer:The predefined templates (POCO Entity and LinqConnect) are improved: new template setting, "Generate Dummy Comments", is added (LinqConnect models)The bug related to detecting unique keys is fixed (LinqConnect models)The bug related to the "Custom tool error: Unknown namespace or alias (NamespaceName.NamespaceName)" error when setting return type of the method to complex type is fixed (Entity Framework models)Entity Framework support:The behaviour is changed: Code-First Migrations generates DEFAULT values for new NOT NULL columns of Boolean, Guid, DateTime types when adding them in the existing table �.You can free download dotConnect for SQLite Standard from Softpedia now.