Afternoon!

I have an issue with 3 of my tables. These three tables are called Tbl_Docket (PK DocketId), Tbl_Installation (PK InstallationId FK DocketId), Tbl_Withdrawal ( PK WithdrawalId, FK DocketId).

The docket table has a column called "Actioned" which is what I use on the PDA to determine whether or not to upload it to the server (if new/changes made).

I need to get the three collections and serialize them using the Proxy Stub to send up to my webservice. So, I can generate the Tbl_Docket records using the simple query dockets.Query.Where(dockets.Query.Actioned.Equal("0"));

How can I generate the collections of Tbl_Withdrawal and Tbl_Installation that correspond to those Dockets with the actioned value of 0? I.e. I don't want to send up all the installations and withdrawals everytime, I only want to send the collections that related to Dockets that are going to be uploaded.

Thanks in advance.

Mike,

since I am still learning the API, can you review and make sure that this is right? (This is good practice for me as well as maybe helping someone else)

 Dockets dockets = new Dockets();

Installations installations = new Installations();

Withdrawals withdrawals = new Withdrawals(); 

dockets.Select(your docket columns here);

installations.Select(your installation columns here);

withdrawals.Select(your withdrawl columns here); 

dockets.InnerJoin( installations).On(installations.DocketId == docket.DocketId);

dockets.InnerJoin(withdrawals).On(withdrawals.DocketId == docket.DocketId);

dockets.Where( dockets.Query.Actioned == "0");

 Yeehaw? Or no dice?

martinmizzell,

In the main Page

http://www.entityspaces.net/Portal/Default.aspx

there is a example with join sintax.

I think you want to serialize each collection separately. You would use Joins to limit the rows included in the InstallationsCollection and WithdrawalsCollection. This should be fine for inserts/updates. I'm not sure how you are handling deletes. I cannot compile or test the code below, but it should be close.

DocketsCollection dockets = new DocketsCollection();
dockets.Query.Where(dockets.Query.Actioned == "0");
dockets.Query.Load();

InstallationsQuery iq = new InstallationsQuery("i");
DocketsQuery dq = new DocketsQuery("d");

iq.Select(iq);
iq.InnerJoin(dq).On(iq.DocketId == dq.DocketId);
iq.Where(dq.Actioned == "0");

InstallationsCollection installations = new InstallationsCollection();
installations.Load(iq);

WithdrawalsQuery wq = new WithdrawalsQuery("w");
dq = new DocketsQuery("d");

wq.Select(wq);
wq.InnerJoin(dq).On(wq.DocketId == dq.DocketId);
wq.Where(dq.Actioned == "0");

WithdrawalsCollection withdrawals = new WithdrawalsCollection(); 
withdrawals.Load(wq);

How can I do the same thing, but through a link table?

I.e. Measurements > LnkReportMeasurements > Reports, where Reports has an archived flag of "S"?

I can get the Reports and LnkReportMeasurements, but I cannot seem to pull back measurements that relate to the reports with the required archived flag?

Thanks.