What's New in v2010 vol 2

.NET Object-Relational Mapping Library

Support for Stored Procedures

With DXperience v2010 vol 2, we have introduced support for stored procedures within the eXpressPersistent Objects Library. You can now directly call existing stored procedures and handle the returned result sets. In addition, you can map persistent classes to MS SQL Server and Oracle database views with the help of INSTEAD-OF triggers and stored procedures. To simplify implementation, the Generating Persistent Classes wizard has been extended with a corresponding page and options, generating all the auxiliary and helper classes, as well as DDL (Data Description Language) code for you.

Persistent Classes Wizard - New Page

Persistent Classes Wizard - New Option

Support for Direct SQL Queries

In addition to stored procedures, you can now execute direct SQL queries against a database and obtain query results as scalar values, result sets or object collections.

Related Blog Post: XPO – Direct SQL Queries
Related Video: eXpress Persistent Objects - Direct SQL Queries

Universal Data Source for Result Sets

With our new data source control - XPDataView - any result set you obtain from a database can be easily visualized in data-aware controls. The data source provides built-in filtering and sorting capabilities to shape resulting data as needed.

Related Blog Post: XPO – Direct SQL Queries

Instant Feedback™ UI Data Source

XPO provides a new data source control - XPInstantFeedbackSource - allowing you to activate the DevExpress Instant Feedback™ UI in your DevExpress WinForms Grid and SearchLookUpEdit Controls.

Explicit Transactions

You can now manually maintain explicit transactions within sessions or units of work, or allow XPO to do this automatically, via specially designed units of work (ExplicitUnitOfWork). Explicit transactions simplify managing object changes within a session or unit of work and also come in handy in scenarios when normal transactions cannot be used for batch object updates. While in an explicit transaction mode, changes made to persistent objects are temporarily stored in a database, allowing you to access these objects as if they were already stored in the database. All temporary changes can be finalized or rolled back at any time - just like normal transactions.

Related Blog Post: XPO - Explicit Transactions
Related Video: eXpress Persistent Objects - Explicit Transactions

ADO.NET Provider Assembly Dynamic Loading

With v2010 vol 2, XPO uses loose coupling to load ADO.NET provider assemblies dynamically. In essence, XPO has no direct reference to most of the ADO.NET providers, except for references to System.Data.SqlClient (for MS SQL Server support), System.Data.OleDb (for MS Access support) and VistaDB. You can now use any specific version of the provider without having to recompile the DevExpress.Xpo.vXXX.Providers assembly.

Related Blog Post: XPO – Uncoupled from ADO.Net Providers


Chat is one of the many ways you can contact members of the DevExpress Team.
We are available Monday-Friday between 7:30am and 4:30pm Pacific Time.

If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383


DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

Copyright © 1998-2014 Developer Express Inc.
All trademarks or registered trademarks are property of their respective owners