XPO v2011 adds extended support for WCF services

IDataStore, ICachedDataStore & ISerializableObjectLayer providers allow you to easily tunnel your data via WCF services.

Zoom [+]

Accessing data using eXpress Persistent Objects for .NET (XPO).

eXpress Persistent Objects for .NET (XPO) represents a bridge between the object world and the world of relational databases. eXpress Persistent Objects for .NET gives developers the freedom to build true business objects without having to deal with the tedious complexities of mapping them onto database tables. eXpress Persistent Objects for .NET completely abstracts the database layer from a developer, leaving him or her fully in the object-oriented realm. With DevExpress XPO, you can build applications that work with multiple database systems (presently supports MS Access, MS SQL Server, MySQL, Oracle, PostgreSql, Firebird, PervasiveSQL, VistaDB, SQL Anywhere, Advantage, DB2 and Sybase) without making any changes to your code. DevExpress XPO Source Code Licenses Available.

Updates in v2011 vol 1

• Extended Support for WCF Services – DevExpress have implemented IDataStore, ICachedDataStore, and ISerializableObjectLayer providers allowing you to easily tunnel your data via WCF services. Generally, all you have to do is derive your service from a corresponding XPO service class (DataStoreService, CachedDataStoreService, or SerializableObjectLayerService), modify service binding settings and pass the service's URL to your client application. Creating distributed applications with XPO is now a breeze.
• Default Sorting Options for Data Sources - DevExpress have added a DefaultSorting property allowing you to specify how XpoDataSource, XPInstantFeedbackSource, and XPServerCollectionSource contents are sorted by default, when sort order is not specified by the bound control.
• Support for In-line Parameters - Int32, Boolean, string, and enum constant values passed as criteria operands are automatically embedded as in-line parameters to resulting SQL queries. This improves performance when you query for data using multiple criteria with matching constant parameters.
• Support for OUTER APPLY Operators - DevExpress have implemented support for OUTER APPLY operators found in MS SQL Server (version 2005 and later) and MS SQL Server Compact (version 3.5 and later). You can now calculate nested aggregates and group by aggregates – the SQL query generator will automatically exploit OUTER APPLY operators for subqueries.
• LINQ to XPO Enhancements - You can now use custom functions in LINQ to XPO expressions.
• VistaDB Provider Assembly Dynamic Loading - DevExpress have continued their ADO.NET provider assembly dynamic loading initiative started in v2010 vol 2 and removed references to the VistaDB provider assembly. XPO now has references only to .NET Framework assemblies - System.Data.SqlClient (for MS SQL Server support) and System.Data.OleDb (for MS Access support).
• Improved Persistent Classes Wizard - The wizard stores the most recently used connection settings in a file located within a user's local AppData folder. The corresponding wizard page will be automatically populated with stored connection settings each time you invoke the wizard.
• Enhanced Smart Tag Menu for XPDataView and XPView - Smart Tag menus for XPDataView and XPView controls have been extended with a Populate Properties item allowing you to automatically populate the control with columns based on a persistent class selected via ObjectClassInfo.

About DevExpress (Developer Express)

Developer Express is a software development company based in the United States. It produces coding assistance tools and components for Delphi, C++ Builder and Microsoft Visual Studio developers. The major part of its product line is VCL, .NET WinForms and ASP.NET components that replicate the UI of Microsoft Windows and Microsoft Office applications. Developer Express has won many industry awards for its products.