Questions tagged [xpo]

XPO is a DevExpress ORM library for .NET.

100 questions
1
vote
1 answer

Saving object take long time in Devexpress, why?

I don't know whether it's my mistake or a bug in Devexpres XPO? (Version 12.1.5) take a look at the following sample: static void Main(string[] args) { var dxs = Session.DefaultSession; var sw = new Stopwatch(); using…
Ehsan Zargar Ershadi
  • 24,115
  • 17
  • 65
  • 95
1
vote
2 answers

Creating complex XPQuery - LINQ to SQL with nested lists

any hint on what's wrong with the below query? return new ItemPricesViewModel() { Source = (from o in XpoSession.Query() select new ItemPriceViewModel() { …
Mauro
  • 2,032
  • 3
  • 25
  • 47
0
votes
1 answer

Find Primary Key From Persistent Class in Devexpress

I have Added Persistent Class in in my webapplication. It contains 20 classes.., In my Default.aspx.cs, I want to get list of Primary key name from all classes in Persistent class.. How can i find it?
ghanshyam.mirani
  • 3,075
  • 11
  • 45
  • 85
0
votes
1 answer

Issue related to getting data from persistance class in XPO

I have added persistance classes in my web application using XPO from DevExpress. Now I want to get data dynamically using XPQuery. Dynamically means: I have got all the class names for particular assembly: Type[] typelist =…
ghanshyam.mirani
  • 3,075
  • 11
  • 45
  • 85
0
votes
2 answers

Save time like TimeSpan and parse it

I using xaf and xpo for my app. I have TimeSpan field for time: private TimeSpan showTime; public TimeSpan ShowTime { get { return showTime; } set { SetPropertyValue("ShowTime", ref showTime, value); } } In the DB it saves like float. In…
user348173
  • 8,818
  • 18
  • 66
  • 102
0
votes
1 answer

Duplicate mapping to column 'CustomerID' in class 'xCustomers'

I get the error Duplicate mapping to column 'CustomerID' in class 'xCustomers' in the following class, but i do not know what am i doing terribly wrong. Public Class xCustomers Inherits XPBaseObject Public Sub New(ByVal session As Session) …
OrElse
  • 9,709
  • 39
  • 140
  • 253
0
votes
1 answer

DevExpress XPO NonPersistentAttribute vs ObjectProperties

All properties of XPObject descendant class which are foreign keys pointing to another XPObject entities are easily available under ObjectProperties property. I have manually added a custom property to my class which type is a XPObject child and…
Kuba D
  • 93
  • 1
  • 7
0
votes
0 answers

Why is Sqlcipher not encrypting a Sqlite database through a .NET Core app?

Newbie here trying to hook up Sqlcipher into a .NET Core (Windows) Sqlite application. We are also using DevExpress XPO. I've tried mirroring the steps outlined in SQLCipher documentation page. It runs without errors or exceptions, but it doesn't to…
JohnB
  • 3,921
  • 8
  • 49
  • 99
0
votes
0 answers

PostgreSQL: Creating case insensitive database supporting three languages (Arabic, English and French)

I am using PostgreSQL 15 01-Is it possible to change the case insensitive of a database after it has been created without losing data (using Collations) 02-How can I be creating case insensitive database (using Collations) that supports three…
M.Bouabdallah
  • 530
  • 10
  • 29
0
votes
0 answers

DevExpress XPO makes the COLUMNS_UPDATED() function of the SQL server unusable

I experienced that a DevExpress XPO object belonging to a SQL table updates all columns in the table regardless of whether it has been changed. This has been a problem in our software since we moved from System.Data.SqlClient.SqlDataAdapter and…
mma
  • 381
  • 2
  • 15
0
votes
0 answers

Abp with Xpo ORM from DevExpress

Is there any possible to add another Data Access for Abp? I want to utilized the Xpo from DevExpress which is required by my client. My problem here is that I'm having a hard times of manually configure and build a context of it. Is there any…
0
votes
1 answer

unitofwork data in Blazor project is always cached, how to I get the data from the database?

I have inherited a VisualStudio 2019 C# DevExpress Blazor XPO web project with SQL Server database running under IIS and have issues with page data always being cached. The project itself is defined as a .NET 5.0 Console application built for 64bit…
0
votes
1 answer

Transact Sql Query with double quotes and field names containing spaces?

I have the following code that produces sql with field names delimited by quotes using DevExpress.Data.Filtering with CriteriaOperator criteria = StockFilter.GetCriteria(); string sWhere =…
Kirsten
  • 15,730
  • 41
  • 179
  • 318
0
votes
1 answer

Is there a way to track when a method of some metadata has been called?

I'm using a NuGet Package called DevExpress.Xpo and its classes are uneditable because they're locked as "metadata". The package contains a class called DataStorePool, and, during runtime, I need to somehow be able to log whenever one of its methods…
0
votes
1 answer

Devexpress (v21.2): Could not find assembly Npgsql (during using 'DevExpress ORM Data Model Wizard')

The database is Postgresql and I wanted to use DevExpress ORM Data Model Wizard v21.2. I got this error during the process: Could not find assembly 'Npgsql'. I have installed Npgsql already in my project module. How can I fix it?
x19
  • 8,277
  • 15
  • 68
  • 126