XPO is a DevExpress ORM library for .NET.
Questions tagged [xpo]
100 questions
0
votes
1 answer
Get data from old column in DevExpress XPO
I'm trying to develop a migration system for when the database changes. I'm using DevExpress XPO as my ORM so that I can target multiple database types.
For column additions, the ORM works fine - but when a column is removed it's a little more…

Chris
- 1,118
- 8
- 24
0
votes
1 answer
Getting the type of properties which belong to an XPO Object
Is there a way to get the type of a property of an XPO Object.
Example : my class is User with properties User_name and User_age.
I want to get the type of the User_name which is string in that case,
and User_age which is int.
How can I get this…

M.Othman
- 40
- 6
0
votes
1 answer
Application Design: Create and persist image thumbnails in XAF/XPO application
I'm developing an application with XPO/XAF and I need to manage photos together with some additional information.
This is the simplified (pseudo) code I use for my Photo entity:
public class Photo
{
public Photo()
{
CreationDate =…

krombi
- 504
- 1
- 4
- 15
0
votes
1 answer
How to define a custom Validation for a property in DevExpress?
Please consider that I have in an entity a property
public double RealVolume
{
get
{
return _RealVolume;
}
set
{
…

Alexa Adrian
- 1,778
- 2
- 23
- 38
0
votes
1 answer
C# XAF XPO Add category to listview
Im new and working with DevExpress/XAF/XPO frameworks, library added: businessobjects, and I got a question.
I want to 'simply' add a category to a listview item. In my BusinessObjects I created a tasks.cs file containing this code:
using alot
…

Terry
- 3
- 2
0
votes
1 answer
XPODataSource: Select from TableValuedFunctions
Is it possible to select from a tabled-valued function using xpoDataSource instead of selecting from a table.
note: Im using xpoDatasource with serverMode = true

Sepehr Davarnia
- 97
- 9
0
votes
1 answer
Complex rule for XPO class
I want to accomplish a simple rule for an XPO class.
The situation is as :
- I have a Vehicle class :
public class Vehicle : BaseObject
{
public Vehicle(Session session)
: base(session)
{
}
public override void…

Ismail
- 190
- 11
0
votes
1 answer
Why the planner does not execute joins participating in WHERE clause first?
I'm experimenting with PostgreSQL (v9.3). I have a quite large database, and often I need to execute queries with 8-10 joined tables (as source of large data grids). I'm using Devexpress XPO as the ORM above PostgreSQL, so unfortunately I don't have…

Zoltán Tamási
- 12,249
- 8
- 65
- 93
0
votes
1 answer
Enumerable.Count after Take returns Take-number instead of actual number
I have a weird situation going on.
I have following query using Devexpress XPO to MS SQL.
var _elements = (from n in new XPQuery( XpoDefault.Session )
select n).Take(100);
int count = _elements.Count();
foreach ( var e…

GigaKatowice
- 551
- 1
- 6
- 14
0
votes
1 answer
How to create dupplicate Key after old key deleted on Devexpress XPO?
This is my product Class:
public class Product : XPLiteObject
{
public string productId {get;set;}
}
i use Gridview to control Data.
When i delete a row with productId = "id-5";
gridview1.deleteSelectedRows();
then Add new row…

Ly Nam
- 23
- 4
0
votes
0 answers
Is it possible to avoid the IIF expression when using AutoMapper's Project with nested object?
I have the following viewmodels (example for simplicity).
public class ProductVM {
public int ID { get; set; }
public string Name { get; set; }
}
public class OrderVM {
public ProductVM Product { get; set; }
public double Price { get;…

Zoltán Tamási
- 12,249
- 8
- 65
- 93
0
votes
1 answer
DevExpress XPO Persistent Object implement a Save and New method
in my Winform Project, i have a simple detail form where we can add new, edit and save persistent Object, until here everything is fine.
Edit Controls are binded by code in the from constructor, and the first new object is also passed by the form…

Ait Yahia Idir
- 370
- 4
- 18
0
votes
1 answer
XAF/XPO How to integrate legacy database
We are experimenting with DevExpress XAF & XPO in order to use it for our further devlopment of an existing small business ERP system. We have a SQL database, where the existing tables must not be changed. What we are trying to do is to add new…

user3162602
- 1
- 1
0
votes
2 answers
DevExpress XPO with subselects
I've broke my mind trying to write next MSSQL query using XPO:
SELECT Gate.Name, grp.maxDate as 'Latest pass', a.Type, a.ReceivedTime as 'Imported at'
FROM Access AS a INNER JOIN
(SELECT GateId, MAX(OpenTime) AS…

Vadim Cebanu
- 1
- 3
0
votes
2 answers
How to do free (non-associated) join for one specific row with XPO?
let's say I have a pesistent class called DailyVisitorSummary, which describes for each web page how many visitors it had per day. For simplicitzy, assume that we represent the day as a pure integer.
Now I would like to create a query to retrieve a…

Zoltán Tamási
- 12,249
- 8
- 65
- 93