
Signature
Ginny Caughey
Device Application Development MVP
Thanks Ginny
I was thinking that the Sync Services (?) was a subset and included in
VS2008 but that the Sync Framework was the bigger piece. Apparantly if I'm
developing a product for sale in the next few months I can't use the new
mobile connection bits anyhoo since they aren't released per se.
think we need a wise wizard to direct our use of these technologies.....as
to prioritizing them.
Thanks again
Harry
> Harry,
>
[quoted text clipped - 13 lines]
>> Lost in the technical woods again....
>> Harry
Ginny Caughey [MVP] - 19 Dec 2007 15:23 GMT
Harry,
I'm not completely clear myself where the lines are drawn between Services
and Framework, but it seems to need both. And you're right that if you need
to deploy pretty soon, the mobile piece isn't there yet so you'll have to
roll your own or use RDA, Merge, etc.

Signature
Ginny Caughey
Device Application Development MVP
> Thanks Ginny
> I was thinking that the Sync Services (?) was a subset and included in
[quoted text clipped - 23 lines]
>>> Lost in the technical woods again....
>>> Harry
Harry Simpson - 19 Dec 2007 15:56 GMT
Welp I already have a RDA pull and Web service upload sync process but it is
synchronous and requires the user to wait the 11-20 seconds required to
get/give data. Happens every 5 minutes in the cradle (Ethernet) or if
wireless the user must now manually initiate.
Need a solution where the user just uses the app and the data sync is
completely transparent.
I suppose I could just wrap all that into a background thread that just
fires when it can periodically and replaces the database SDF on the device.
Problem has always been that the SDF might be being used when the new SDF is
generated so there's got to be a smooth switch of fresh(less stale)
databgase for the more stale one.
> Harry,
>
[quoted text clipped - 30 lines]
>>>> Lost in the technical woods again....
>>>> Harry
Ginny Caughey [MVP] - 19 Dec 2007 16:11 GMT
Harry,
Since SQL Compact supports multiple simultaneous connections to the database
from the same machine, you should be able to update the sdf file from a
separate thread or process if you use perhaps Web Services and read/write
the data yourself rather than using RDA. Sync Services would really be
ideal, but then we've discussed that already.

Signature
Ginny Caughey
Device Application Development MVP
> Welp I already have a RDA pull and Web service upload sync process but it
> is synchronous and requires the user to wait the 11-20 seconds required to
[quoted text clipped - 43 lines]
>>>>> Lost in the technical woods again....
>>>>> Harry
Harry Simpson - 19 Dec 2007 22:30 GMT
Really would not need to connect but once at a time. The local app would
use the SDF on the device for "current" data.
Looking at the Mobile Client Application block's Disconnected Application
Block too. Every messed with that Ginny?
> Harry,
>
[quoted text clipped - 53 lines]
>>>>>> Lost in the technical woods again....
>>>>>> Harry
Ginny Caughey [MVP] - 19 Dec 2007 23:09 GMT
Harry,
I haven't used the Disconnected Application Block in my code, but I am
familiar with it.

Signature
Ginny Caughey
Device Application Development MVP
> Really would not need to connect but once at a time. The local app would
> use the SDF on the device for "current" data.
[quoted text clipped - 58 lines]
>>>>>>> Lost in the technical woods again....
>>>>>>> Harry
Harry Simpson - 21 Dec 2007 16:11 GMT
Thanks Ginny and Daniel,
I'm just looking to jump into use of these tools and want to make sure I'm
jumping into the right pool. Its confusing to me to say the least - Even
the Code article intermengles Sync Services for ADO.NET and Sync Framework
as if they were the same thing. The way i understand it, the only bits I
can use are Sync Services for ADO.NET v.1 which is "included in VS2008" but
when I try to find reference to this in the help it's like it doesn't exist.
Now my boss tells me that he doesn't think it will work with smart device
projects at all.
So from a Windows Mobile 5 developer standpoint none of this can be used -
correct?
I've also had a terrible head cold/flu which doesn't help either.
I'm just trying to get the big picture before I dive deeper into any
particular technology.
Thanks and Merry Christmas to all
Harry
> Harry,
>
[quoted text clipped - 63 lines]
>>>>>>>> Lost in the technical woods again....
>>>>>>>> Harry
Ginny Caughey [MVP] - 21 Dec 2007 20:36 GMT
Harry,
Your boss is correct for now, but this will be changing sometime in the new
year. Merry Christmas to you too! Hope you'll be feeling better soon.

Signature
Ginny Caughey
Device Application Development MVP
> Thanks Ginny and Daniel,
>
[quoted text clipped - 84 lines]
>>>>>>>>> Lost in the technical woods again....
>>>>>>>>> Harry
Harry Simpson - 27 Dec 2007 14:53 GMT
Thanks Ginny,
Barely survived.....
I'll put this on hold and see what comes about. Guess for now I can just try
to move the whole sync that I'm already doing to a background thread. And
suppose it would be possible to copy the recently synced SDF over the
existing one on the device in a split second right?
So the app may be calling the stale database and then after syncing in the
background thread I just copy one SDF (just synced) over the working one the
app uses? Is this what most are doing now?
Thanks!!
Harry
> Harry,
>
[quoted text clipped - 89 lines]
>>>>>>>>>> Lost in the technical woods again....
>>>>>>>>>> Harry
Ginny Caughey [MVP] - 27 Dec 2007 15:03 GMT
Harry,
The only problem I see with that plan would be if the SDF file you want to
replace is in use by another thread, but probably you've already thought of
that.
I think in practice people are using a variety of syncing techniques
depending on the situation.

Signature
Ginny Caughey
Device Application Development MVP
> Thanks Ginny,
> Barely survived.....
[quoted text clipped - 106 lines]
>>>>>>>>>>> Lost in the technical woods again....
>>>>>>>>>>> Harry
Harry Simpson - 27 Dec 2007 16:15 GMT
That's "the problem" partially solved by at least just updating a separate
SDF database which is the duplicate of the working one the app is actually
using.
The trick would be to "copy" the updated one over the working one in a
locked fashion.
Anyone doing this?
Harry
> Harry,
>
[quoted text clipped - 117 lines]
>>>>>>>>>>>> Lost in the technical woods again....
>>>>>>>>>>>> Harry
Ginny Caughey [MVP] - 27 Dec 2007 16:23 GMT
Harry,
The only way I can see to update the database already in use would be to
write code that determines when a row needed updating, similar to what the
Sync Framework does under the covers using a TimeStamp or LastEditDate
column.

Signature
Ginny Caughey
Device Application Development MVP
> That's "the problem" partially solved by at least just updating a
> separate SDF database which is the duplicate of the working one the app is
[quoted text clipped - 127 lines]
>>>>>>>>>>>>> Lost in the technical woods again....
>>>>>>>>>>>>> Harry
Harry Simpson - 27 Dec 2007 16:52 GMT
Ginny,
Could you not "lock the app" in some way and simply make the IO copy of the
one SDF over the other SDF on the device. Just copy the updated database
into the active directory where the SDF the app actually hits is located?
Harry
> Harry,
>
[quoted text clipped - 134 lines]
>>>>>>>>>>>>>> Lost in the technical woods again....
>>>>>>>>>>>>>> Harry
Ginny Caughey [MVP] - 27 Dec 2007 17:00 GMT
Harry,
Well yes I guess you could but since I haven't done it I couldn't recommend
the exact best way to do it. I tend to think more along the lines of
multi-user access to the same data rather than somehow locking one user out
while another does an update, but just because my brain is prejudiced that
doesn't mean it's necessarily the best approach here.

Signature
Ginny Caughey
Device Application Development MVP
> Ginny,
>
[quoted text clipped - 144 lines]
>>>>>>>>>>>>>>> Lost in the technical woods again....
>>>>>>>>>>>>>>> Harry
Harry Simpson - 27 Dec 2007 19:07 GMT
For the most part I'd just be doing a RDA PULL - the only uploading would be
logs via Web service.
> Harry,
>
[quoted text clipped - 153 lines]
>>>>>>>>>>>>>>>> Lost in the technical woods again....
>>>>>>>>>>>>>>>> Harry
Daniel Moth - 19 Dec 2007 22:33 GMT
Please note that I have nothing to offer to this thread beyond the URLs
below:
> I was thinking that the Sync Services (?) was a subset and included in
> VS2008 but that the Sync Framework was the bigger piece.
That's correct. ADO.NET Sync Services v1.0 shipped with VS2008. It is the
first step towards the Sync Framework.
Articles on each one of those in the CODE magasine issue distributed at Tech
Ed Europe:
http://www.code-magazine.com/Article.aspx?quickid=990712092
http://www.code-magazine.com/Article.aspx?quickid=990712102
The official home page:
http://msdn2.microsoft.com/en-gb/sync/default.aspx
HTH
Cheers
Daniel
--
http://www.danielmoth.com/Blog
> Thanks Ginny
> I was thinking that the Sync Services (?) was a subset and included in
[quoted text clipped - 23 lines]
>>> Lost in the technical woods again....
>>> Harry
Ginny Caughey [MVP] - 19 Dec 2007 23:14 GMT
Hi Daniel,
Thanks for jumping in! The CODE magazine articles are defnitely worth a
read. I also like The Synchronizer blog posts:
http://blogs.msdn.com/synchronizer/archive/2007/12/13/what-s-new-in-sync-service
s-for-ado-ne-2-0.aspx

Signature
Ginny Caughey
Device Application Development MVP
> Please note that I have nothing to offer to this thread beyond the URLs
> below:
[quoted text clipped - 47 lines]
>>>> Lost in the technical woods again....
>>>> Harry