Announcements

• DML Options
  • Batch Updates
    • Batch Updates Limitations
    • Batch Updates Settings
  • Other DML Options
• SQL Formatting Settings
• Workarounds
• Database Script Generation Settings
  • DeleteDatabaseBehaviour
  • DBMS-Specific Properties
    • Oracle
    • MySQL
    • PostgreSQL
• Provider-Specific LIKE Implementation
• Oracle-Specific Improvements
  • Multiple Includes Support Improvement in Oracle
  • NumberMappings Support in EDM Wizard
  • Improved StoreGeneratedPattern Attribute Handling

In the new version of Devart dotConnect ADO.NET providers for Oracle, MySQL, PostgreSQL and SQLite we have significantly extended functional capabilities of Entity Framework. We maximally fulfilled requests of our users, including those received via our new UserVoice. Our users mainly requested new functional features, more flexibility in behavior and configuration as well as better performance.
(more…)

Go to devart.uservoice.com and share your ideas about Entity Framework support in dotConnect data providers. There you may vote for features that are already in our roadmap, and they will have higher priority in our plans, or you may suggest your own features, and if they will get enough votes, we will include them to the roadmap. Your opinion helps us to make Entity Framework support in dotConnect data providers better and more useful for you.

(more…)

ORMBattle.NET has recently updated their results of testing various .NET Framework ORMs and added LinqConnect to their lists. LinqConnect demonstrates one of the best results it their tests.

ORMBattle.NET is an open-source project for ORM comparison, supported by a development team from X-tensive.com. This project contains a set of tests for feature-oriented comparison, but it is more focused on the performance tests (CRUD operation performance, object materialization, etc.).

LinqConnect development team agrees with most of the tests. The results on the whole are reliable enough to consider them when choosing ORM framework.

We already are studying the situations where LinqConnect showed bad results and working on performance improvement.

New version of Entity Developer comes with completely redesigned template system, which allows much more comfortable template editing and much more flexible code generation.

Code Generation

New template framework allows you to create additional templates for a wide range of tasks:

• Generating code for other languages than Visual Basic and C#
• Use custom base class
• Generate classes without namespace (for example, in Visual Basic, where project has implicit namespace)
• Implement GetHashCode() and Equals() for the class, which allow to add entities into HashTable.
• Implement default value setting for properties
• Create an interface, which contains only public properties, for a class
• IPOCO
• Property validation

New T4 like template language features the full power of C# or Visual Basic in the templates, allowing virtually anything you may want for code generation. Organizing iterated or conditional output has never been easier. You may even import your own assemblies and use classes from them.
(more…)

When designing model, and especially when debugging it, it is often necessary to view and edit table and view data or fill tables with some test data. Now Entity Developer allows viewing and editing data of tables, views, and model entities, create and execute LINQ to SQL and Entity SQL queries against the model, eliminating the need for additional applications and reducing time for accessing these operations.

Editing Database Data

Entity Developer allows you to directly edit database data in the tables or views. Just right-click the table or view in the Database Explorer window and choose Retrieve Data from the popup menu. A new window will open with two tabs: Data and SQL.

SQL tab contains the SQL query to the specified table or view. Data tab displays table or view data, which you can edit.

To edit data in the cell click on a cell you want to edit. After making any changes to the cell, press to confirm changes or ESCAPE to cancel. To add a new record, click the ‘+’ button under the grid. To delete a record from the grid, click the ‘-’ button under the grid. You may also use grid popup menu for insert and delete operations.
(more…)