Building N-Tier Applications in Visual Studio 2008

In this interview
Milind Lele, Program Manager on the Visual Basic Team, shows us his favorite features - the new Data Synchronization designer in Visual Studio 2008 and how the sync services for ADO.NET work to support occasionally connected
scenarios. He shows us how to set up a local database cache using SQL Compact Edition and how to use it to store read-only data caches as well as how to add the code to support two-way synchronization.
If anyone's ever tried to implement an occasionally connected smart client, they'll very much appreciate this new tooling and framework in Visual Studio 2008. For more information on sync services catch up on The
Synchronizer blog.
First of all this all seems a little too good to be true so hopefully i will be able to use this feature, i just have a few questions.
My first question is that right now i am developing a system in which users will not always be connected, which will require them to be able to work off their laptops, so i have been working on a windows app that will use sql express, then have a seperate
service running that will look after my synchronization, how ever one of our biggest problems here is that our data base is constantly changing which as i'm sure you know is a major pain when you have to write publications and renew all subscriptions everytime,
What i am wondering is if there is an easy way that my database changes can automatically appear in the local database cache? Or will i also have to create a new local cache with every database change?
So basically my question is this, for everychange that is made to the database structure, will this result in recreating the local database cache object?
My next question is will it be available for developers to use the tables in the local database cache in the LINQ to SQL Classes? Since the two main features i would like to use by switching to 2008 would be built in synchronization and LINQ then i was hoping
that it would have the ability to be laid over each other, however when ever i try to do this i am getting errors when i drag and drop from the server explorer.
Anyway Thanks in advance
Jeremy
Very good presentation!
I have one question, I have a centralserver with lots of user specific data. And I only want to get userspesific data synced to the client. For instance if you have several salespersons and one salesperson are only interested in customerdata, orders etc for his customers. How will I proceed to sync only subsets of data?
Hi! Great video about sync Services. I saw it when it came out on channel9. Thought I would return to the subject when any resource/tutorial/sample app including LINQ was available.
But now it's January and I haven't been able to find anything on LINQ to SQL classes together with Sync Services.
We're using mergereplication on the SQL2005 server right now.
Would love to switch to an easier approach since we're going to implement local datacahce on all our WPF client apps and take some load and traffic of the SQL2005 server when clients sorting, filtering and still using the most recent data available.
LINQ together with SyncService will allow us to stay flexible when new demands comes in from the customers.
Any tip on samples,tutorials,videos.. is appreciated.
rgds, Stanley
stanley.broo@gbo.se wrote:Hi! Great video about sync Services. I saw it when it came out on channel9. Thought I would return to the subject when any resource/tutorial/sample app including LINQ was available.
But now it's January and I haven't been able to find anything on LINQ to SQL classes together with Sync Services.
We're using mergereplication on the SQL2005 server right now.
Would love to switch to an easier approach since we're going to implement local datacahce on all our WPF client apps and take some load and traffic of the SQL2005 server when clients sorting, filtering and still using the most recent data available.
LINQ together with SyncService will allow us to stay flexible when new demands comes in from the customers.
Any tip on samples,tutorials,videos.. is appreciated.
rgds, Stanley
mackern wrote:Very good presentation!
I have one question, I have a centralserver with lots of user specific data. And I only want to get userspesific data synced to the client. For instance if you have several salespersons and one salesperson are only interested in customerdata, orders etc for his customers. How will I proceed to sync only subsets of data?
Thanks for the great video.
Question: We are developing a offline system in which users will not always be connected. We were thinking of using sync services but the main concern is our backend database which is Oracle. How will Oracle schema migration happen with SQL Server Compact. Are there any compatibility issues.
Hi,
I have one question.
I want to do the synchronization using vs 2015. But the features of 2008 is not available in 2015 and by using 2008 I cannot connect my mysql database.
Any solution?