dotConnect for SQLite Standard 3.30.160

dotConnect for SQLite Standard 3.30.160 is regarded as a helpful and convenient program with which you can present a complete solution for developing SQLite. 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.

Major Features:

1. .NET Framework support
2. ADO .NET core classes
3. Native data types classes and structures
4. SQLiteScript class
5. SQLiteMonitor class  
6. Design-time features, including component editors and property editors
7. Advanced Visual Studio 2005/2008/2010 integration
8. InterForm technology.

Enhancements:

• DbTransactionBase class is added
• TransactionStateChanging and TransactionStateChanged events are added to the DbConnectionBase class
• Policy file for the Devart.Data.SQLite.Entity assembly is added
• The License Information Wizard is 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
• The "Use schema name" checkbox is added to DataSet Wizard
• The bug with dropping database objects when calling the SQLiteDump.Restore method is fixed
• The bug with Membership provider compatibility between .NET Framework 2.0 and 4.0 is fixed
• The bug with launching Devart documentation via Start menu is fixed
• LinqConnect (formerly known as LINQ to SQLite)
• • Implemented eager loading in case the related entities collection is referenced in the select clause of the query
  • The bug with incorrect operation order during SubmitChanges() calls is fixed
  • The bug with ArgumentExceptions thrown in background threads is fixed
  • The bug with using public properties when refreshing or materializing an entity is fixed
  • The bug with grouping a collection by a whole entity is fixed
• Entity Developer
• • New Templates are added:
  • • LinqConnect: POCO template with XML mapping generation
    • Entity Framework: POCO template, Self-Tracking template, DbContext template with fluent mapping generation
  • Templates usability is improved
  • Template Editor is significantly improved
  • Ability to declare additional properties for model objects is added
  • Ability to specify .NET attributes for model objects is added
  • Implemented runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models
  • The "Preserve schema name in storage" option is added
  • The bug with code generation for the 'Delete Rule' association property in LinqConnect models is fixed
  • The bug with generation of attach/detach methods for many-to-many associations in LinqConnect models is fixed
  • The bug with external mapping for LinqConnect models is fixed
  • The bug with default values set via a function for string fields in LinqConnect models is fixed
  • The bug with the "Access" combobox of the Association editor in LinqConnect models is fixed
  • The bug with procedures that differ only by name in Database Explorer is fixed (Entity Framework models)
  • Entity Framework support
  • Batch Updates support is added
  • Adjustable SQL Formatting for DML commands is added
  • Ability to configure the NULL values inserting behaviour is added
  • IgnoreSchemaName workaround (mainly for Code First) is added
  • DisableQuoting workaround is added
  • SQLiteFunctions.Like support (including LINQ to Entities) is added
  • Configurable database deletion and creation support is added
  • The bug with Entity Framework configurability is fixed
  • The bug with Optimistic Concurrency is fixed.

• Microsoft Visual Studio 2010
• Microsoft Visual Studio 2008
• Microsoft Visual Studio 2005
• Embarcadero Delphi Prism
• CodeGear RAD Studio 2007.