Devart is glad to announce the release of the new version of dotConnect for SQLite, enhanced database connectivity solution built over ADO.NET architecture that offer Entity Framework and LINQ to SQL support. New dotConnect for SQLite offers complete support for Visual Studio 2010 Release Candidate and Entity Framework 4 Release Candidate.
Entity Developer 2.80 was greatly improved. Now Entity Developer seamlessly integrates with Visual Studio 2008 and Visual Studio 2010 Release Candidate. Entity Developer LINQ to SQL and Entity Framework models are edited inside the Visual Studio without the need to open the model in a separate Entity Developer application. You can use Entity Developer for creating models for both Entity Framework 1 and Entity Framework 4 Release Candidate. For example, such feature as Lazy Loading is now supported for Entity Framework 4 Release Candidate models.
Support for new Canonical aggregate and scalar functions was added to dotConnect for SQLite, and you may use standard database functions in LINQ queries.
Installation of new dotConnect for SQLite also was improved. Now previous version of the product can be uninstalled automatically by the installation wizard.
Here is the complete list of dotConnect for SQLite 2.80.120 features:
- Supported Visual Studio 2010 Release Candidate
- Install Wizard improved (ability to automatically uninstall previous version added)
- ADO.NET Data Services v1.5 CTP2 supported
- Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors
- The 3.6.22 version of sqlite3.dll included to the installation package
- Fixed bug with licensing in Visual Studio 2010 Release Candidate projects
- Fixed bug with exception in License Information window
- Fixed bug with multiple rows constraint generation
- Added support for Boolean type
- Added support for specific dynamic expressions
- Fixed bug with Refresh() method
- Fixed bug with LoadWith() method
- Fixed the 'Unable to cast object' problem
- Fixed bug with Where() and nullable parameter
- Fixed bug with multiple LoadWith() calls
- Fixed bug with calling a method in the Select clause
- Fixed "Cannot Refresh Entity" error
- Fixed bug with nullable boolean and null comparison
- Fixed "Cannot access a disposed object" error
- Fixed bug with "select new"
- Fixed bug with insert of autoincremented values
- Fixed bug with Union
- 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
- Support for ADO.NET Entity Framework 4 Release Candidate added
- Improved dialogs for editing model objects
- Full integration with Visual Studio implemented
- Improved Find in Model functionality
- Improved One-To-One associations handling
- Fixed bug with different namespaces and procedure code generation
- Fixed bug with Unicode facet serialization
- Fixed problem with DevartEntityDeploySplit
- Fixed problem with metadata resources generation
- Fixed bug with App_Code subfolders
- Fixed bug with Many-to-Many associations
- Fixed several bugs in VB.NET code generation templates
- 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
- 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
- Supported ADO.NET Entity Framework 4 Release Candidate
- Support for new Canonical aggregate and scalar functions added
- Ability to use standard DBMS functions in LINQ queries added
- Added support for methods creating and deleting the database (EF v1 and EF v4)
- Fixed bug with EndsWith method
http://www.devart.com/dotconnect/sqlite/