Creating a master/detail

Data Abstract
1

I’m trying to use a master detail with a couple of grids.
The problem i’m having can apparently be resolved if I can get the master object to itself contain a list of the details eg :

masterObject
masterAttribute1
masterAttribute2
detailObjects[] details

Is this possible using remobjects/dataabstract ?

2

Hello,
Can you describe what you mean more detail?

3

In which respect ?

As an example, take something “normal” - customers + orders - very simplified :

create table customer (
customerId Integer,
customerAddress text
)

create table order (
customerId integer,
orderNo integer,
OrderTotal float
)

In the C# front end - It would look like :

class customer {
int customerId ;
string customerAddress;
order[] Orders;
}

(the problem I am having is that if I have a very large number of entries in a master detail relationship - I’m finding it hard to display in a devexpress grid :
http://www.devexpress.com/Support/Center/p/B221338.aspx

I originally tried to use some sort of linq query - but that doesnt work…
I tried using a “customfilter” - but thats too slow for large datasets…

What is the normal way to create and maintain data simultaneously in the two tables ?!

4

Hello,
You can use DynamicWhere feature instead of customfilter.
Read about it in wiki:
http://wiki.remobjects.com/wiki/Introduction_to_Dynamic_Select_and_Dynamic_Where_(.NET_and_Delphi)

If you want to do paging of LINQ query please use Take and Skip operators:
http://msdn.microsoft.com/en-us/library/gg334684.aspx

5

Hi, just a thought…Have you thought about not displaying the whole table worth of data. We filter our SQL by date range or what ever the data is, we never give out the whole data that exists as it is ever growing. On the listing screen we display a toolbar with filter options and search options.