471,071 Members | 1,487 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

Disconnected DataSets and DataViews

For scalability we wish to use disconnected DataSets and hold them in
the application cache.

This means that multiple concurrent users will be reading the data (its
read only)

The DataSet is fairly complicated and contains many tables and many
relationships

What we would like to do is create a DataView that flattens the in
memory DataSet so that we can bind this single view to a control

We need to hold the separate tables in memory because there are some
tables that have parent child relationships where the parent has many
thousands of children (and grand children)

think Products and Orders and we want to hold Products and Orders in
Memory, the reason is that each Product row is large enough not to
warrant holding it multiple times

OK, the problem is that a DataView can only have one table and the row
filter can only be for that table,

what we want to do is an equivalent of a sql select (with a join) but
from disconnected a DataSet

e.g.

Select Product.ID, Product.Code, Product.Image, Order.FirstName,
Order.Price
from tbl_Product PRoduct
join tbl_Order Order
on Order.ProductID = Product.ID

Any help would be appreciated

Nov 23 '05 #1
0 956

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

45 posts views Thread by cody | last post: by
1 post views Thread by Andrew | last post: by
5 posts views Thread by J | last post: by
9 posts views Thread by Steven Nagy | last post: by
4 posts views Thread by Bernie Hunt | last post: by
5 posts views Thread by Anil Gupte | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.