SqlServerCE and SOA - an architecture question

Tech-Archive recommends: Fix windows errors by optimizing your registry



In the MSDN article 'Architecting Disconnected Mobile Applications Using a
Service Oriented Architecture' found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/develop_disconnect_mob_apps.asp,
the author states that "complete encapsulation of data access is one of the
most important tenets of a service...Services guard their data by enforcing
all business and data integrity rules and do not allow outside clients to
participate in any ACID transactions that would put a service at the mercy
of the client in terms of possible concurrency and locks...Services are
responsible for the state of data in their control; they are the final word
for their data." Also in the article the author acknowledges that
Service-oriented architecture (SOA) is one way to solve the problem of
disconnected mobile application development. The article also goes on to
describe the implementation of data synchronization which looks like a lot
of work. Something that does not come for free with the architecture but is
a loosely-coupled solution.

I'm looking into SQL Server 2005 Mobile Edition as another way to solve the
problem of disconnected mobile application development. It looks great as a
disconnected data store and SqlCeRemoteDataAccess and SqlCeReplication seem
to make the problem of synchronizing data a snap. Something that comes for
free with the architecture but is a tightly-coupled solution.

My question is:
Is SqlServerCE's merge replication and remote data access functionality
unuseable in a Service Oriented Architecture? I would like to architect my
smartphone apps as web service clients but I don't see how (if I develop
them according to the theory) how SqlServerCE's synchronization mechanisms
could fit in.

Any thoughts? Any real world experiences?

Thanks...Ron Lemire


.



Relevant Pages

  • Re: Is OO a tradeable commodity/skill?
    ... oriented technique to program their service oriented architecture? ... is just a distributed process architecture for some functional ... told that OO was old hat and SOA is the new big thing. ...
    (comp.object)
  • Re: SqlServerCE and SOA - an architecture question
    ... but not a web services approach per se. ... flesh out your own synchronization strategy between SQL Mobile and a larger ... architecture may be the simplest thing available to get the job done. ... > the problem of disconnected mobile application development. ...
    (microsoft.public.sqlserver.ce)