Welcome to MSDN Blogs Sign in | Join | Help

First look at the Visual Studio Orcas Sync Designer

Here's part 1 of the new Sync Designer.  In this screen cast I walk through how to cache lookup tables locally.  In this screencast I use the 2 tier sync, starting simple.  In the next screencast I'll show how to take the same designer, and split it across N tier to keep the intimate knowledge of the server, connection string, queries, passwords, etc. from the client. 

http://channel9.msdn.com/posts/SteveLasker/Visual-Studio-Orcas-Sync-Designer-for-Caching-Data-in-SQL-Server-Compact-Edition/

Just as a note, this screencast shows an internal build of Visual Studio Orcas between the Feb CTP and Beta 1. 

Steve 

Published Thursday, March 22, 2007 1:32 AM by Steve.Lasker

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Screencast de Sync Designer

Thursday, March 22, 2007 4:36 AM by Byteabyte

Steve Lasker acaba de publicar un screencast sobre el nuevo motor de sincronización de datos para la

# SQL Server CE Site Update

Thursday, March 22, 2007 8:11 PM by Nick Randolph's .NET Travels

If you are looking at the Microsoft Sync Services which is likely to be part of Visual Studio Orcas you

# Sync Designer in Oracs

Thursday, March 22, 2007 9:07 PM by The Synchronizer

Cool stuff gets attention from everyone! This is especially true with the Sync Designer in Orcas. The

# Sync Designer in Orcas

Thursday, March 22, 2007 10:32 PM by RSS It All

Cool stuff gets attention from everyone! This is especially true with the Sync Designer in Orcas. The

# Going N Tier w/WCF, Synchronizing data using Sync Services for ADO.NET and SQL Server Compact Edition

Thursday, March 22, 2007 10:52 PM by Steve Lasker's Web Log

In part 1 , I used the Visual Studio Orcas Sync Designer to configure and synchronize 3 lookup tables

# Orcas enables easy offline client apps

Saturday, March 24, 2007 11:14 PM by Brad Abrams

I just saw that steve does a couple of very cool screen casts showing off how easy it will be for WinForms

# re: First look at the Visual Studio Orcas Sync Designer

Thursday, March 29, 2007 11:15 AM by Shawn Cicoria

Steve, the video's are great (the WMV versions).  Your presentations are direct and get the technology concepts clearly presented.

The Live meeting versions however, are poor in that the slide builds don't show in the stream.

Chance you have the decks somewhere else to download - also, sample code as well?

# re: First look at the Visual Studio Orcas Sync Designer

Sunday, April 15, 2007 1:28 PM by RajeshPR

Hi Steve..

Can I make use of Microsoft Synchronization Services on Windows Mobile 5.0 pocket pc project.

I tried to, but some of the sync classes wouldn't work on the project. Is there any else that I should do or am I missing on some thing.

I need to perform sync action between the Windows Mobile data (SQL CE) and SQL Server 2005 database. (I don't want to use publish/subscribe model, I want to use the ADO Sync services)

# re: First look at the Visual Studio Orcas Sync Designer

Tuesday, April 24, 2007 12:48 AM by Steve.Lasker

Hi Rajesh,

Glad to hear your interest.  Unfortunately we don’t yet have a CTP available for devices.  We have this working internally, and have designed it to run on devices, with the limited overloads and types of devices, but we just don’t have all the testing done.  Sync Services for Devices will be available post Orcas.  We’re still working out when and how, but unfortunately it won’t be “in” Orcas.

Hang in there with us, it’s coming…

Steve

# Going Occasionally Connected with Orcas

Wednesday, April 25, 2007 8:44 PM by Nick Randolph's .NET Travels

Visual Studio vNext (aka Orcas) has a number of features that is set to make building occasionally connected

# re: First look at the Visual Studio Orcas Sync Designer

Friday, June 22, 2007 1:57 AM by Miguel Madero

Too bad, I tought this could be a solution to our problems.

Is there anyway we could SyncServices working on .NET CF?

# re: First look at the Visual Studio Orcas Sync Designer

Friday, June 22, 2007 5:05 PM by Steve.Lasker

Hi Miguel,

Sync Services for devices is coming.  It will be shortly after Orcas ships, and I hope to make a commitment to exactly when soon.  But have no fear, this was always our intention, was designed from the beginning, is regularly compiled against the .NET CF to assure we're not using missing overloads or types etc.  We're simply working through the test matrix needed for the device platform.  

Steve

# re: First look at the Visual Studio Orcas Sync Designer

Friday, October 05, 2007 2:29 PM by Miguel Madero

Steve:

Orcas' release date is closer now, is there an official release for SyncService's .NET CF version?

We would be glad to test that in a project and give you feedback.

# re: First look at the Visual Studio Orcas Sync Designer

Tuesday, November 20, 2007 10:35 AM by kclawrence@hotmail.com.hk

Steve:

Since VS2008 RTM by end of this month, I also looking forward to test and feeback this through my coming .NET CF data sync project.

# re: First look at the Visual Studio Orcas Sync Designer

Thursday, January 10, 2008 6:30 AM by stanley_

Hi! Is there any resource/tutorial/sample app including LINQ available.

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

# re: First look at the Visual Studio Orcas Sync Designer

Tuesday, January 15, 2008 2:27 AM by Steve.Lasker

Hi Stanley,

This is exactly the type of scenarios we’ve targeted with Sync Services and SQLce.  Today, Sync Services and LINQ are separate technologies.  LINQ to SQL(ce) works over the local store.  Sync Services brings data from the server to the local store (SQLce).  So, you can use these together to get what you’re looking for, but they’re not “coupled”.  When LINQ doesn’t give you what you need, you can use DataSets, or even direct data access with the SqlCeResultSet.

There are docs for LINQ to SQL(ce).  The big difference is we don’t have designer support for LINQ to SQLce.  You’ll need to use the SQLMetal command line utility to generate the LINQ to SQL Classes.

Was there a particular place you were looking to use these technologies together?  Does this give you what you need?

Steve

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker