dotConnect for SQLite History

2.80.102 Beta 04-Mar-10

Supported Visual Studio 2010 Release Candidate
ADO.NET Data Services v1.5 CTP2 supported
Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors

LINQ to SQLite

Fixed bug with nullable boolean and null comparison

Entity Developer

Support for ADO.NET Entity Framework 4 Release Candidate added
Improved Find in Model functionality

Entity Framework support

Supported ADO.NET Entity Framework 4 Release Candidate

2.80.97 Beta 17-Feb-10

Fixed bug with licensing in Visual Studio 2010 Beta 2 projects
Fixed bug with exception in License Information window

LINQ to SQLite

Fixed "Cannot access a disposed object" error
Fixed bug with "select new"
Fixed bug with insert of autoincremented values
Fixed bug with Count and IGrouping
Fixed bug with Union

Entity Developer

Fixed bug with "Trial period expired" on 64-bit Windows
Fixed the "MSL Parsing failed" problem on some model opening
Fixed bug with Read Only attribute

Entity Framework support

Fixed bug with EndsWith method

2.80.90 Beta 08-Feb-10

Supported Visual Studio 2010 Beta 2
Install Wizard improved (ability to automatically uninstall previous version added)
The 3.6.22 version of sqlite3.dll included to the installation package
Fixed bug with multiple rows constraint generation

LINQ to SQLite

Fixed bug with NotImplementedException and IGrouping.Count
Fixed the problem with group by and ordering
Fixed bug with exception on the master-detail insert
Fixed bug with Int32 instead of Int64

Entity Developer

Support for ADO.NET Entity Framework 4 Beta 2 added
Improved dialogs for editing model objects
Full integration with Visual Studio implemented
Fixed bug with Storage attribute setting
Fixed bug with OtherKey attribute setting
Fixed bug with model opening in case of manual association edit
Fixed bug with Generate related property check box

Entity Framework support

Supported ADO.NET Entity Framework 4 Beta 2
- Support for new Canonical aggregate and scalar functions added
- Ability to use standard DBMS functions in LINQ queries added

2.60.79 14-Jan-10

Supported parameterized commands in Reporting Services
Fixed bug with inability to "Copy data from one or more tables or views" in SQL Server Import and Export Wizard
Fixed bug with non-complete uninstall of dotConnect

LINQ to SQLite

Fixed the "Destabilize the runtime" problem

Entity Developer

Fixed bug with incorrect updating of the Project Explorer root node names

Entity Framework support

Fixed bug with EntitySQL BigCount function

2.60.62 16-Dec-09

LINQ to SQLite

Changed exception type on the Single method not returning value
Fixed bug with DataContext.CommandTimeout
Fixed bug with redundant quering of the nullable association end
Fixed bug with ArgumentException on provider initialization

Entity Developer

Fixed bug with 'Generate Related property' serialization

2.60.57 02-Dec-09

Entity Developer

Fixed bug with the Custom.After.Microsoft.Common.targets file appending
Fixed bug with inheritance and primary keys

2.60.54 19-Nov-09

Integration with improved dbMonitor added
Added orderid column for Site Map provider for custom map node ordering
Added some DataSet Wizard design-time improvements
Fixed bug with MembershipProvider.GetAllUsers() method
Fixed bug with DataLink.DataSource property after regeneration of DataSet

LINQ to SQLite

Devart DbLinqDataSource added
Linq performance improved
Supported navigation using properties (not only keys)
Fixed issue with removing entities from EntitySet
Fixed bug with EntitySet onAdd action
Fixed bug with updating the detached object
Fixed bug with AutoSync
Fixed the security problem in medium trust environment

Entity Developer

New T4 like template engine with powerful editor added
Updated code generation
- Ability to generate separate files for classes added
- Entity Framework Pregenerated Views support added
- Improved null handling code generation
Ability to execute LINQ and Entity SQL queries with data and native sql preview added
Ability to preview and edit data displayed in Database Explorer added
Table splitting added (emulation of deferred loading for "large" datatypes in EF)
OnDelete support for associations added
Corrected the setting of Source and Table attribute for non-database objects
Fixed bug with attach_Entity methods
Fixed bug with access and inheritance modifiers for properties

2.50.49 19-Oct-09

Added SchemaTable property to DbDataTable

LINQ to SQLite

Fixed bug with the Attach() method
Fixed bug with updating the associated entities
Fixed the "Constant cannot be sequence" error
Fixed bug with populating DataContext.GetCommand().Parameters collection
Fixed bug with Single() method

Entity Developer

Fixed bug with wrong IDE configuration path
Fixed bug with VS template
Fixed bug with model placed in non-root project folder

2.50.44 24-Sep-09

Added support for user-defined finctions
Fixed bugs in DataSet Wizard with Web Service projects
Fixed bug with licensing projects using wizard in nested folders of solution

LINQ to SQLite

Suported DeleteOnNull attribute of association and changed default behaviour (DeleteOnNull=false now)

Entity Developer

Added support for EF Precision and Scale facets
Improved MS EDM Designer compatibility
Fixed bug with using Entity Developer in Web Site projects

Entity Framework support

Increased performance for StartsWith, Contains and EndsWith methods

2.30.42 04-Sep-09

Fixed bug with licensing Startup projects
Fixed bug with using String.Format function computed at client side

LINQ to SQLite

Fixed bug with using objects from different contexts
Fixed bug with String.IsNullOrEmpty() function

Entity Developer

Added design time support for some EF facets
Enabled adding Schema name as prefix
Fixed bug with the connection reopen on refresh

2.30.39 06-Aug-09

Added some installation command line options
Fixed bug with dotConnects and dbForge Fusion integration

Entity Developer

Fixed bug with Entity Set pluralization naming rule
Fixed bug with EntitySet property deserialization
Fixed bug with Source property for the added classes
Fixed bug with connection string quotation for the standalone projects
Fixed bug with the serialization of property accessors

2.30.37 14-Jul-09

Visual Studio 2010 Beta supported
The CEROD and SEE extensions are supported
Ability to execute SQL statements separated with ; added
Ability to enable extensions with the EnableLoadExtension connection string parameters added
Performance improved
ASP.NET Web Providers: Added requiresUniqueEmail functionality

LINQ to SQLite

Added support of the String.IsNullOrEmpty() method
Fixed bug with nested LoadWith() methods on the query level
Fixed bug with inserting parent and several child entities in one InsertOnSubmit() when keys are db-generated
Fixed bug with the AssociateWith() method and VB.NET

Entity Developer

Advanced mapping with Entity Framework QueryView supported
Displaying of Navigation properties on diagram and project explorer implemented
Ability to change properties order added
Ability to edit Referential constraints added
Ability to set OnDelete action added
Ability to set Rows Affected parameter added
Added dialogs for suitable storage model editing
Added advanced search on the model
Added support for storing connections in the application configuration files
Added Entity Set Pluralization Naming Rule
Fixed bug with namespaces
Fixed bug with invisible OK button in Association Editor
Fixed bug with <edmx:*> tags
Fixed bug with XML Comments serialization

2.20.33 21-May-09

LINQ to SQLite

Added support for CompiledQuery
Fixed bug with the ExecuteCommand() method
Fixed bug with Distinct and count symultaneous usage
Fixed bug with DevExpress 9 integration
Fixed bug with Bit datatype

Entity Developer

Fixed some code generation bugs

2.20.29 28-Apr-09

LINQ to SQLite

Supported extended errors processing
Supported DataLoadOptions class and Include method for tuning data loading
Supported DeferredLoadingEnable functionality
Supported CreateDatabase() and DeleteDatabase() methods
Supported SqlMethods class
Added support for returning new Dictionary from query
Fixed bug with OnValidate()
Fixed bug with associations based on non-Primary keys
Fixed bug with SingleOrDefault and BLOBs
Fixed bug with update of entities that declare a version member
Fixed bug with ArgumentException in the Contains() method

Entity Developer

Added support for Entity Framework
Added naming rules for database objects
Added Visual Studio integration
Stability and performance improvements
Validation schema improved
Entity Framework Complex Type supported
Entity Framework Storage Model editing supported
Many-to-Many associations retrieving added
Usability improvements
Fixed bug with the wrong type for autoincrement column

2.00.26 02-Apr-09

Fixed bug with serialization in C++ projects

2.00.22 16-Feb-09

Fixed bug with DbDataTable in WPF applications
Fixed bug with Detail command in DbDataSet ParentRelation

LINQ to SQLite

Fixed bug with refreshing field values
Fixed bug with inserting several entities with autogenerated key

2.00.20 14-Jan-09

Numerous Entity Framework support improvements

LINQ to SQLite

Fixed bug with Table.Attach function
Fixed bug with inserting and deleting entities with an associations
Fixed bug with supporting parameters IsDbGenerated, IsVersion, UpdateCheck, CanBeNull in ColumnAttribute
Fixed bug with refreshing key fields when an association is present

2.00.16 05-Dec-08

Fixed bug with null value of EntityRef field in LINQ to SQLite
Fixed bug with Queriable.Cast to interface type in LINQ to SQLite
Fixed bug with submitting changes in DbDataTable on WPF

2.00.12 13-Nov-08

Supported LINQ to SQLite
Added Entity Developer for LINQ to SQLite
Supported SQLite engine library version 3.6 and above

1.00.2 22-Apr-08

Fixed bug with INTEGER PRIMARY KEY AUTOINCREMENT fields in Entity Framework
Fixed bug with missing SQLite3.dll in the Standard edition

1.00.1 08-Apr-08

First release of dotConnect for SQLite