Data Access Layer Calls

[Nemisis]

Hi everyone,

Maybe a silly question but if i have DataService1 - 5 in my data access
layer, and DataService3 returns a dataset that contains many fields,
one of which is a foreign key. The foreign key belongs to a table that
i retrieve using DataService 4.

Is it ok, to call the DataService4 retrieve method, from within
DataService3, or should i write it as part of the SQL for
DataService3??

If this doesnt make sense, i am sorry.lol

[sloan]

When I am "merging" data. I usually do this in the business layer.

Lets say I have Orders in one database, and ProductStock in another.

BizLayer
DataObject1 do1 = new DataObject();
DataSet ordersDs = do1.GetOrders();

DataObject2 do2 = new DataObject2();
DataSets inventoryDs = do2.GetProducts();

DataSet masterDs = null;
masterDs = ordersDs;
masterDs.Merge(inventoryDs);
Something like that.

..Merge can merge tables. It can merge ~different rows. You'll have to
experiment with overlapping rows, its not very friendly.

But I would keep my datalayer objects seperated. datalayer objects should
be pretty dumb.

http://sholliday.spaces.live.com/?_c...26ayear%3d2006
I might check my May and June 2006 blog entries.


"Nemisis" <da*********@hotmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...

Hi everyone,

Maybe a silly question but if i have DataService1 - 5 in my data access
layer, and DataService3 returns a dataset that contains many fields,
one of which is a foreign key. The foreign key belongs to a table that
i retrieve using DataService 4.

Is it ok, to call the DataService4 retrieve method, from within
DataService3, or should i write it as part of the SQL for
DataService3??

If this doesnt make sense, i am sorry.lol