Serialize entire BD and synchronise with llblgen

Posts   
 
    
Posts: 11
Joined: 27-Aug-2009
# Posted on: 03-Feb-2010 16:24:17   

Hello all, I'm working with an Sql Server Database. Some users works in disconnected mode. I would like to know if its simple to serialize the entire database on their notebook and then synchronize the data with llblGen after the job done.

Thank you verry much.

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 03-Feb-2010 16:41:43   

Better to use a local database at their local machines, e.g. SQL Server CE Desktop Edition. And then you can synchronize with the main database when the connection is available.

You can also serialize to disk, if you want to. Either in XML or binary formats.

Anyway you should consider not to copy the entire database localy, but rather the portion they need to use only.

Posts: 11
Joined: 27-Aug-2009
# Posted on: 03-Feb-2010 16:52:22   

Thanx a lot ! However i would like to know one thing please. When we serialize entities, is there a way to get a massive update like the .Net DataAdapter can do ?

Thanx a lot !

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 03-Feb-2010 17:06:03   

What do you mean by massive update?

Posts: 11
Joined: 27-Aug-2009
# Posted on: 03-Feb-2010 17:19:05   

AllEntity.Update
simple_smile

Thanx

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 03-Feb-2010 17:32:46   

You can Update an EntityCollection which contains as many entities as you want. Then the framework will only look for dirty entities, or new ones, and will INSERT or UPDATE these to the database.