Guy Burstein's Blog : Sync Services

Building an Occasionally Connected ADO.Net Data Service with “Astoria Offline” Preview

Guy Burstein — Sat, 07 Mar 2009 17:46:24 GMT

Building an Occasionally Connected ADO.Net Data Service with “Astoria Offline” Preview

This is a step by step walkthrough of creating a new ADO.Net Data Service that support offline and synchronization with the recently released “Astoria Offline” alpha preview.

1. Create an ADO.Net Data Service that Allows Synchronization

Create a new standard Web Application project.

Add a new Entity Data Model. This time, make sure you select the [Offline Preview] ADO.Net Data Model template. Also notice that the extension of the file is now .edmxpreview instead of .edmx.

Continue with the wizard to create the data model. When the wizard completes, notice that the project has a new reference to System.Data.Entity.Preview.dll.

Add a new ADO.Net Data Service to the project, but make sure you select the [Offline Preview] ADO.Net Data Service template.

In the “Choose what to publish wizard” select Existing Entity Model. We could have started from this wizard from the beginning and create a new Entity Data Model from here.

Select the Entity Container that is part of the Entity Data Model you created earlier. In my sample it is BankEntities. Also notice the new “Enable Synchronization” checkbox – make sure it is checked.

This adds several things to your project:

1. Several new references were added to the project: Microsoft.Data.Entities.Synchronization is the extension for Sync Services that enables entity Synchronization. System.Data.Services.Preview and System.Data.Services.Client.Preview are the ones that does the magic of Astoria Offline.

2. Two new SQL Scripts were added to the Entity Data Model (notice the Bank.create.sql and the Bank.drop.sql scripts in the image). These contain the DDL statements needed to change the database schema in order to support synchronization.

To actually enable synchronization, you’ll have to run the create script. To do that, open it in Visual Studio, and execute it against your database.

3. The ADO.Net Data Service is added to the project and it is now empty. It is already connected the the entity data model, but right now does not support anything.

Set the access rules to the resources of the data model (in this sample I give full access to all the resources). In addition to that, tell the data service that it supports synchronization. To do that, cast the config object to IDataServiceConfiguration2 interface (new in this preview) and assign true to the AllowSynchronization property.

public class BankDataService : DataService<BankEntities>

  // This method is called only once to initialize service-wide policies.

  public static void InitializeService(IDataServiceConfiguration config)

    config.SetEntitySetAccessRule("*", EntitySetRights.All);

    ((IDataServiceConfiguration2)config).AllowSynchronization = true;

The ADO.Net Data Service is now ready to run. Press F5 to run it and play with the URL in the address bar to navigate through the resources.

2. Create a Occasionally Connected Client Application

Add a standard Windows Forms Application to the solution.

Add a Service Reference to the project and let visual studio discover the data service in your solution. When you add the reference Visual Studio will tell you that this ADO.Net Data Service is offline enabled.

Click Yes to enable offline scenarios in the client application.

A scary dialog should appear and tell you that an error has occurred. You can disregard it by pressing Cancel.

Adding this service reference has added not only the client side proxy for consuming this service, but also a local database with the database schema that matches your model.

Open the Data Sources window (Shift + Alt + D), and add a new data source of type Object. Select one of the object types in your client application that matches the model and click OK.

Drag the list of objects onto your form and let Visual Studio create all the necessary controls for navigating through the data.

Double click the window title to add an event handler to the form’s loaded event. In this event handler we will load the data from the Local Database. Add a new for the context, and in the Load event handler – use it to get the data and bind it to the binding source.

public partial class CustomersForm : Form

  public CustomersForm()

    InitializeComponent();

  BankEntities db;

  private void CustomersForm_Load(object sender, EventArgs e)

    db = new BankEntities();

    var query = from c in db.Customers

                select c;

    this.customersBindingSource.DataSource = query;

In order to support saving changes to the local database – enable the Save button on the Form and double click it to add an event handler. In the handler – simply apply the changes to the database.

private void customersBindingNavigatorSaveItem_Click(object sender, EventArgs e)

  db.SaveChanges();

Add another menu item the the binding navigator that will do the actual synchronization. For it click event handler – implement the synchronization logic:

Add a Microsoft.Data.Entities.Synchronization.DataServiceSyncProvider instance, and point to the the ADO.Net Data Service URL.

Create a Microsoft.Data.Entities.Synchronization.ObjectContextSyncProvider instance, which is the client-side wrapper for the BankEntities’s ObjectContext.

Create a new Microsoft.Synchronization.SyncOrchestrator instance and set the local and remote providers.

Then, do the actual synchronization. Notice that the sync operation sync between the service and the local database, therefore the data needs to be fetched from the local database again.

private void syncItem_Click(object sender, EventArgs e)

  DataServiceSyncProvider dsp = new DataServiceSyncProvider(

            new Uri("http://localhost:8474/BankDataService.svc/"), "global");

  ObjectContextSyncProvider esp = new ObjectContextSyncProvider(

      () => new BankEntities());

  SyncOrchestrator so = new SyncOrchestrator();

  so.RemoteProvider = dsp;

  so.LocalProvider = esp;

  so.Direction = SyncDirectionOrder.UploadAndDownload;

  so.Synchronize();

  // Load the data again

  CustomersForm_Load(null, null);

Finally, set the client application as the startup project and run it. Sync it for the first time to get the data from the remote server to your local database, and then sync it occasionally to upload changes and download changes to your client.

Enjoy!

ADO.Net Data Services Offline (“Astoria” Offline) – Alpha Preview

Guy Burstein — Sat, 07 Mar 2009 16:11:40 GMT

ADO.Net Data Services Offline (“Astoria” Offline) – Alpha Preview

While only a week ago, the Astoria team has announced ADO.NET Data Services v1.5 CTP1. Today, an alpha preview of Astoria Offline just became available.

ADO.NET Data Services v1.5 CTP1 is a tech preview of the next release of ADO.NET Data Services. It will initially target the .NET Framework 3.5 SP1 and Silverlight 2 platforms in a future version support the .NET Framework 4.0 platform.

“Astoria Offline” enables developers to add data-synchronization behavior between a client application and an ADO.NET Data Service, allowing the client to be offline without an interruption in use. The offline project is very early, and is still largely in the incubation stage therefore it is not currently committed to any upcoming product, and it is just a preview.

The two will be separate releases, and will initially be incompatible with each other (Offline will only work with ADO.NET Data Services 1.0).

Enjoy!

Download PDC 2008 Sessions and Watch Offline

Guy Burstein — Wed, 05 Nov 2008 08:58:00 GMT

Download PDC 2008 Sessions and Watch Offline

personally prefer watching sessions regardless of my Internet connection status, so I decided to download PDC08 sessions and watch offline.

I collected the list of available sessions from PDC 08, and they are easy to download. I personally use Free Download Manager for simultaneous efficient downloads - you can try it yourself. Just select all the text in this post, right click and select “Download Selected with Free Download Manager”.

For a full list of downloads and links, you can download this excel file that contains all the information.

KYN01 - Day 1 Morning Keynote
Ray Ozzie, Amitabh Srivastava, Bob Muglia, David Thompson
Video

KYN02 - Day 2 Morning Keynote
Ray Ozzie, Steven Sinofsky, Scott Guthrie, David Treadwell
Video

KYN03 - Day 2 Afternoon Keynote
Chris Anderson, Don Box
Video

KYN04 - Day 3 Morning Keynote
Rick Rashid
Video

BB01 - A Lap Around the Azure Services Platform
John Shewchuk
Video PowerPoint

BB02 - Architecture of the .NET Services
Dennis Pilarinos, John Shewchuk
Video PowerPoint

BB03 - SQL Services : Under the Hood
Gopal Kakivaya, Tony Petrossian
Video PowerPoint

BB04 - Live Services: A Lap around the Live Framework and Mesh Services
Ori Amiga
Video PowerPoint

BB05 - Live Services: Building Applications with the Live Framework
Raymond Endres
Video PowerPoint

BB06 - Live Services: Mesh Services Architecture and Concepts
Abolade Gbadegesin
Video PowerPoint

BB07 - SQL Server 2008: Developing Large Scale Web Applications and Services
Hala Al-Adwan, Jose Blakeley
Video PowerPoint

BB08 - Microsoft Dynamics CRM: The Appealing Business Application
Humberto Lezama Guadarrama
Video PowerPoint

BB09 - Microsoft Office Communications Server and Exchange: Platform Futures
Chris Mayo, David Ollason
Video PowerPoint

BB10 - Live Services: Deep Dive on Microsoft Virtual Earth
Mark Brown
Video PowerPoint

BB11 - Identity Roadmap for Software + Services
Bertocci Vittorio, Kim Cameron
Video PowerPoint

BB12 - .NET Services: Messaging Services - Protocols, Protection, and How We Scale
Clemens Vasters
Video PowerPoint

BB13 - SharePoint 2007: Creating SharePoint Applications with Visual Studio 2008
Chris Johnson
Video PowerPoint

BB14 - SQL Services: Futures
Patric McElroy
Video PowerPoint

BB15 - SQL Server: Database to Data Platform - Road from Server to Devices to the Cloud
David Campbell, Zach Skyles Owens
Video PowerPoint

BB16 - SQL Server 2008: Beyond Relational
Michael Rys
Video PowerPoint

BB18 - "Dublin": Hosting and Managing Workflows and Services in Windows Application Server
Dan Eshner
Video PowerPoint

BB19 - Live Services: Live Framework Programming Model Architecture and Insights
Ori Amiga
Video PowerPoint

BB20 - Live Services: Making your Application More Social
Angus Logan
Video PowerPoint

BB22 - Identity: Live Identity Services Drilldown
Jorgen Thelin
Video PowerPoint

BB23 - A Lap around SQL Services
Soumitra Sengupta
Video PowerPoint

BB24 - SQL Server 2008: Deep Dive into Spatial Data
Isaac Kunen
Video PowerPoint

BB25 - SQL Server 2008: New and Future T-SQL Programmability
Michael Wang
Video PowerPoint

BB26 - SQL Server 2008: Business Intelligence and Data Visualization
Stella Chan
Video PowerPoint

BB27 - .NET Services: Orchestrating Services and Business Processes Using Cloud-Based Workflow
Moustafa Ahmed
Video PowerPoint

BB28 - .NET Services: Access Control Service Drilldown
Justin Smith
Video PowerPoint

BB29 - Identity: Connecting Active Directory to Microsoft Services
Lynn Ayres, Tore Sundelin
Video PowerPoint

BB30 - Live Services: Building Mesh-Enabled Web Applications Using the Live Framework
Arash Ghanaie-Sichanie
Video PowerPoint

BB31 - Live Services: FeedSync and Mesh Synchronization Services
Steven Lees
Video PowerPoint

BB32 - Microsoft Dynamics CRM: Building Line-of-Business Applications
Andrew Bybee
Video PowerPoint

BB33 - Dynamics Online: Building Business Applications with Commerce and Payment APIs
Adam Wilson
Video PowerPoint

BB34 - Live Services: Notifications, Awareness, and Communications
John Macintyre
Video PowerPoint

BB35 - Live Services: The Future of the Device Mesh
Jeremy Mazner
Video PowerPoint

BB36 - FAST: Building Search-Driven Portals with Microsoft Office SharePoint Server 2007 and Microsoft Silverlight
Jan Helge Sagefl?t, Stein Danielsen
Video PowerPoint

BB37 - SQL Server 2008: Developing Secure Applications
Il-Sung Lee
Video PowerPoint

BB38 - .NET Services: Connectivity, Messaging, Events, and Discovery with the Service Bus
Clemens Vasters
Video PowerPoint

BB39 - .NET Services: Logging, Diagnosing, and Troubleshooting Applications Running Live in the Cloud
Mark Gilbert, Steve Garrity
Video PowerPoint

BB40 - Sync Framework: Enterprise Data in the Cloud and on Devices
Liam Cavanagh
Video PowerPoint

BB41 - Live Services: What I Learned Building My First Mesh Application
Don Gillett
Video PowerPoint

BB42 - Identity: "Geneva" Server and Framework Overview
Caleb Baker, Stuart Kwan
Video PowerPoint

BB43 - Identity: "Geneva" Deep Dive
Jan Alexander
Video PowerPoint

BB44 - Identity: Windows CardSpace "Geneva" Under the Hood
Rich Randall
Video PowerPoint

BB45 - Office Communications Server 2007 R2: Enabling Unified Communications
David Ollason, Oscar Newkerk
Video PowerPoint

BB46 - Exchange Web Services Managed API: Unified Communications Development for Exchange
Jason Henderson
Video PowerPoint

BB47 - SharePoint 2007: Advanced Asynchronous Workflow Messaging
Alex Malek
Video PowerPoint

BB48 - Microsoft Advertising Platform: A Lap Around
Erynn Petersen
Video PowerPoint

BB49 - Microsoft Advertising Platform: A Day in the Life of a Click
Robert Devine
Video PowerPoint

BB51 - Live Services: Programming Live Services Using Non-Microsoft Technologies
Nishant Gupta
Video PowerPoint

BB52 - SQL Services: Tips and Tricks for High-Throughput Data-Driven Applications
David Robinson
Video PowerPoint

BB53 - SharePoint Online: Extending Your Service
Troy Hopwood
Video PowerPoint

BB54 - Designing Your Application to Scale
Max Feingold
Video PowerPoint

BB55 - .NET Services: Access Control In Microsoft .NET Services
Justin Smith
Video PowerPoint

BB56 - Showcase: Industry Leaders Moving to the Cloud
Brandon Watson, Erik Johnson, Jitendra Thethi, Larry Beck
Video PowerPoint

BB57 - Microsoft Dynamics AX: Building Business Process into Your Application
Josh Honeyman
Video PowerPoint

BB58 - Case Study: Bridging On-Premises with the Cloud
David Shutt
Video PowerPoint

BB59 - Behind the Scenes: How We Built a Multi-Enterprise Supply Chain Application
Jack Greenfield, Wade Wegner
Video PowerPoint

ES01 - Developing and Deploying Your First Windows Azure Service
Steve Marx
Video PowerPoint

ES02 - Windows Azure: Architecting & Managing Cloud Services
Yousef Khalidi
Video PowerPoint

ES03 - Windows Azure: Cloud Service Development Best Practices
Sriram Krishnan
Video PowerPoint

ES04 - Windows Azure: Essential Cloud Storage Services
Brad Calder
Video PowerPoint

ES06 - Developing with Microsoft .NET and ASP.NET for Server Core
Andrew Mason, Ian Robinson
Video PowerPoint

ES07 - Windows Azure: Modeling Data for Efficient Access at Scale
Niranjan Nilakantan, Pablo Castro
Video PowerPoint

ES09 - Enabling Test Automation Using Windows Server 2008 Hyper-V
Taylor Brown
Video PowerPoint

ES10 - Developing Solutions for Windows Server 2008 Hyper-V Using WMI
Nihar Shah
Video PowerPoint

ES11 - Developing Connected Home Applications and Services for Windows Home Server
CJ Saretto, Fabian Uhse
Video PowerPoint

ES12 - Exposing Connected Home Services to the Internet via Windows Home Server
Brendan Grant, CJ Saretto
Video PowerPoint

ES13 - How to Develop Supercomputer Applications
Jeff Baxter, Sean Mortazavi
Video PowerPoint

ES14 - IIS 7.0 and Beyond: The Microsoft Web Platform Roadmap
Vijay Sen
Video PowerPoint

ES15 - Web Application Packaging and Deployment
Saad Ladki
Video PowerPoint

ES16 - A Lap Around Windows Azure
Manuvir Das
Video PowerPoint

ES17 - Windows Azure: Programming in the Cloud
Daniel Wang, Stefan Schackow
Video PowerPoint

ES19 - Under the Hood: Inside the Windows Azure Hosting Environment
Chuck Lenzmeier, Frederick Smith
Video PowerPoint

ES20 - Developing Applications for More Than 64 Logical Processors in Windows Server 2008 R2
Arie van der Hoeven
Video PowerPoint

ES21 - Windows 7 Presentation Virtualization: Graphics Remoting
RDP
Video PowerPoint

ES22 - Extending Terminal Services and Hyper-V VDI in Windows 7
Christa Anderson, Niraj Agarwala
Video PowerPoint

ES23 - Windows 7: Optimizing Applications for Remote File Services over the WAN
Mathew George
Video PowerPoint

ES24 - PowerShell: Creating Manageable Web Services
Jeffrey Snover
Video PowerPoint

ES25 - Showcase: Windows Azure Enables Live Meeting
John Shriver-Blake, Michael Conrad
Video PowerPoint

ES29 - Showcase: Windows Azure Enables /Nsoftware and Full Armor
Danny Kim, Gent Hito, Steve Marx
Video PowerPoint

ES30 - Datacenters and Resilient Services
Benjamin Ravani
Video PowerPoint

ES31 - Showcase: How HP Built their Magcloud Service on Windows Azure
Andrew E Fitzhugh, Steve Marx
Video PowerPoint

ES32 - Microsoft Application Virtualization 4.5
Elsie Nallipogu, John Sheehan
Video PowerPoint

PC01 - Windows 7: Web Services in Native Code
Nikola Dudar
Video PowerPoint

PC02 - Windows 7: Extending Battery Life with Energy Efficient Applications
Pat Stemen
Video PowerPoint

PC03 - Windows 7: Developing Multi-touch Applications
Anson Tsao, Reed Townsend
Video PowerPoint

PC04 - Windows 7: Writing Your Application to Shine on Modern Graphics Hardware
Anantha Kancherla
Video PowerPoint

PC05 - Windows 7: Unlocking the GPU with Direct3D
Allison Klein
Video PowerPoint

PC06 - Deep Dive: Building an Optimized, Graphics-Intensive Application in Microsoft Silverlight
Seema Ramchandani
Video PowerPoint

PC07 - WPF: Extensible BitmapEffects, Pixel Shaders, and WPF Graphics Futures
David Teitlebaum
Video PowerPoint

PC10 - Microsoft Silverlight 2 for Mobile: Developing for Mobile Devices
Amit Chopra, Giorgio Sardo
Video PowerPoint

PC11 - Microsoft Silverlight Futures: Building Business Focused Applications
Jamie Cool
Video PowerPoint

PC12 - Deep Dive: The New Rendering Engine in Microsoft Internet Explorer 8
Alex Mogilevsky
Video PowerPoint

PC13 - Windows 7: Building Great Audio Communications Applications
Larry Osterman
Video PowerPoint

PC14 - Windows 7 Scenic Ribbon: The next generation user experience for presenting commands in Win32 applications.
Nicolas Brun
Video PowerPoint

PC15 - Windows 7: Benefiting from Documents and Printing Convergence
Adrian Ford
Video PowerPoint

PC16 - Windows 7: Empower users to find, visualize and organize their data with Libraries and the Explorer
David Washington
Video PowerPoint

PC17 - Developing for Microsoft Surface
Brad Carpenter, Robert Levy
Video PowerPoint

PC18 - Windows 7: Introducing Direct2D and DirectWrite
Kam VedBrat, Leonardo Blanco
Video PowerPoint

PC19 - Windows 7: Designing Efficient Background Processes
Vikram Singh
Video PowerPoint

PC20 - ASP.NET 4.0 Roadmap
Scott Hunter
Video PowerPoint

PC21 - ASP.NET MVC: A New Framework for Building Web Applications
Phil Haack
Video PowerPoint

PC22 - Windows 7: Design Principles for Windows 7
Samuel Moreau
Video PowerPoint

PC23 - Windows 7: Integrate with the Windows 7 Desktop
Rob Jarrett
Video PowerPoint

PC24 - Windows 7: Welcome to the Windows 7 Desktop
Chaitanya Sareen
Video PowerPoint

PC25 - Windows 7: The Sensor and Location Platform: Building Context-Aware Applications
Dan Polivy
Video PowerPoint

PC26 - Microsoft Visual Studio: Building Applications with MFC
Damien Watkins
Video PowerPoint

PC27 - Microsoft Silverlight, WPF and the Microsoft .NET Framework: Sharing Skills and Code
Ian Ellison-Taylor
Video PowerPoint

PC29 - Microsoft Silverlight 2: Control Model
Karen Corby
Video PowerPoint

PC30 - ASP.NET Dynamic Data
Scott Hunter
Video PowerPoint

PC31 - ASP.NET and JQuery
Stephen Walther
Video PowerPoint

PC32 - ASP.NET AJAX Futures
Bertrand Le Roy
Video PowerPoint

PC33 - Microsoft Visual Studio: Easing ASP.NET Web Deployment
Vishal Joshi
Video PowerPoint

PC34 - Open XML Format SDK: Developing Open XML Solutions
Eric White, Zeyad Rajabi
Video PowerPoint

PC35 - Silverlight Controls Roadmap
Shawn Burke
Video PowerPoint

PC39 - Inside the Olympics: An Architecture and Development Review
Eric Schmidt, Jason Suess
Video PowerPoint

PC40 - SQL Server Compact: Embedding in Desktop and Device Applications
Steve Lasker
Video PowerPoint

PC41 - ASP.NET: Cache Extensibility
Stefan Schackow
Video PowerPoint

PC42 - Windows 7: Deploying Your Application with Windows Installer
MSI
Video PowerPoint

PC43 - Deep Dive: What's New with user32 and comctl32 in Win32
Raymond Chen
Video PowerPoint

PC44 - Windows 7: Programming Sync Providers That Work Great with Windows
Jason Roberts, Moe Khosravy
Video PowerPoint

PC45 - WPF: Data-centric Applications Using the DataGrid and Ribbon Controls
Mark Wilson-Thomas, Samantha Durante
Video PowerPoint

PC46 - WPF Roadmap
Anson Tsao, Kevin Gjerstad
Video PowerPoint

PC47 - Microsoft Expression Blend: Tips & Tricks
Douglas Olson, Peter Blois
Video PowerPoint

PC48 - Research: Designing the World Wide Telescope
Jonathan Fay
Video PowerPoint

PC49 - Microsoft .NET Framework: CLR Futures
Ian Carmichael, Joshua Goodman
Video PowerPoint

PC50 - Windows 7: Using Instrumentation and Diagnostics to Develop High Quality Software
Kevin Woley, Ricky Buch
Video PowerPoint

PC51 - Windows 7: Best Practices for Developing for Windows Standard User
Crispin Cowan
Video PowerPoint

PC52 - Windows 7: Writing World-Ready Applications
Erik Fortune, Yaniv Feinberg
Video PowerPoint

PC53 - Building High Performance JScript Applications
Sameer Chabungbam
Video PowerPoint

PC54 - Mono and .NET
Miguel de Icaza
Video PowerPoint

PC55 - Oomph: A Microformat Toolkit
Karsten Januszewski
Video PowerPoint

PC56 - Windows Embedded "Quebec": Developing for Devices
Shabnam Erfani
Video PowerPoint

PC58 - Framework Design Guidelines
Brad Abrams, Krzysztof Cwalina
Video PowerPoint

PC59 - Commerce Server "Mojave": Overview
Kerry Havas, Tom Schultz
Video PowerPoint

PC60-V - Driving for software quality through customer feedback
Kevin Hill
Video PowerPoint

PC61-V - Developing compatible applications for Windows
Uday Shivaswamy
Video PowerPoint

PC62-V - Hands On Analysis with Windows Performance Toolkit
General
Video PowerPoint

SYMP01 - Parallel Symposium: Addressing the Hard Problems with Concurrency
David Callahan, Lynne Hill
Video PowerPoint

SYMP02 - Parallel Symposium: Application Opportunities and Architectures
Jerry Bautista, John Feo
Video PowerPoint

SYMP03 - Parallel Symposium: Future of Parallel Computing
David Detlefs, James Reinders, Niklas Gustafsson, Sean Nordberg, Selena Wilson
Video PowerPoint

SYMP04 - Services Symposium: Expanding Applications to the Cloud
Gianpaolo Carraro, Simon Guest
Video PowerPoint

SYMP05 - Services Symposium: Enterprise Grade Cloud Applications
Eugenio Pace
Video PowerPoint

SYMP06 - Services Symposium: Cloud or No Cloud, the Laws of Physics Still Apply
Gianpaolo Carraro
Video PowerPoint

TL01 - Office Business Applications: Enhanced Deployment
Andrew Whitechapel, Saurabh Bhatia
Video PowerPoint

TL02 - Under the Hood: Advances in the .NET Type System
Andrew Whitechapel, Misha Shneerson
Video PowerPoint

TL03 - Microsoft Visual Studio Team System: Software Diagnostics and Quality for Services
Habib Heydarian, Justin Marks
Video PowerPoint

TL04 - Microsoft Visual Studio Team System Team Foundation Server: How We Use It at Microsoft
Stephanie Saad
Video PowerPoint

TL06 - WCF 4.0: Building WCF Services with WF in Microsoft .NET 4.0
Ed Pinto
Video PowerPoint

TL07 - Developing Applications Using Data Services
Mike Flasko
Video PowerPoint

TL08 - Offline-Enabled Data Services and Desktop Applications
Pablo Castro
Video PowerPoint

TL09 - Agile Development with Microsoft Visual Studio
Lori Lamkin, Sunder Raman
Video PowerPoint

TL10 - Deep Dive: Dynamic Languages in Microsoft .NET
Jim Hugunin
Video PowerPoint

TL11 - An Introduction to Microsoft F#
Luca Bolognese
Video PowerPoint

TL12 - Future Directions for Microsoft Visual Basic
Lucian Wischik, Paul Vick
Video PowerPoint

TL13 - Microsoft Visual C++: 10 Is the New 6
Boris Jabes
Video PowerPoint

TL14 - Project "Velocity": A First Look
Murali Krishnaprasad
Video PowerPoint

TL15 - Architecture without Big Design Up Front
Peter Provost
Video PowerPoint

TL16 - The Future of C#
Anders Hejlsberg
Video PowerPoint

TL17 - WF 4.0: A First Look
Kenny Wolf
Video PowerPoint

TL18 - "Oslo": Customizing and Extending the Visual Design Experience
Don Box, Florian Voss
Video PowerPoint

TL19 - Microsoft Visual Studio: Bringing out the Best in Multicore Systems
Hazim Shafi
Video PowerPoint

TL20 - Entity Framework Futures
Tim Mallalieu
Video PowerPoint

TL21 - WF 4.0: Extending with Custom Activities
Matt Winkler
Video PowerPoint

TL22 - Concurrency Runtime Deep Dive: How to Harvest Multicore Computing Resources
Niklas Gustafsson
Video PowerPoint

TL23 - A Lap around "Oslo"
Douglas Purdy, Vijaye Raji
Video PowerPoint

TL24 - Improving .NET Application Performance and Scalability
Ed Glas, Steve Carroll
Video PowerPoint

TL25 - Parallel Programming for C++ Developers in the Next Version of Microsoft Visual Studio
Rick Molloy
Video PowerPoint

TL26 - Parallel Programming for Managed Developers with the Next Version of Microsoft Visual Studio
Daniel Moth
Video PowerPoint

TL27 - "Oslo": The Language
David Langworthy, Don Box
Video PowerPoint

TL28 - "Oslo": Repository and Models
Chris Sells, Martin Gudgin
Video PowerPoint

TL29 - Live Labs Web Sandbox: Securing Mash-ups, Site Extensibility, and Gadgets
Dragos Manolescu, Scott Isaacs
Video PowerPoint

TL30 - Microsoft Sync Framework Advances
Lev Novik
Video PowerPoint

TL31 - "Oslo": Building Textual DSLs
Chris Anderson, Giovanni Della-Libera
Video PowerPoint

TL32 - Microsoft Visual Studio: Customizing and Extending the Development Environment
Tim Wagner
Video PowerPoint

TL33 - Managed Extensibility Framework: Overview
Glenn Block
Video PowerPoint

TL34 - Managed and Native Code Interoperability: Best Practices
Jesse Kaplan
Video PowerPoint

TL35 - WCF: Developing RESTful Services
Steve Maine
Video PowerPoint

TL36 - Microsoft .NET Framework: Declarative Programming Using XAML
Daniel Roth, Rob Relyea
Video PowerPoint

TL37 - Microsoft Visual Studio Team System: Leveraging Virtualization to Improve Code Quality with Team Lab
Ram Cherala
Video PowerPoint

TL38 - WCF: Zen of Performance and Scale
Nicholas Allen
Video PowerPoint

TL39 - Coding4Fun: Windows Presentation Foundation Animation, YouTube, iTunes, Twitter, and Nintendo's Wiimote
Brian Peek, Clint Rutkas, Dan Fernandez, Scott Hanselman
Video PowerPoint

TL40 - "Dublin" and .NET Services: Extending On-Premises Applications to the Cloud
Jacob Avital
Video PowerPoint

TL42 - Microsoft SQL Server 2008: Powering MSDN
Mark Johnston
Video PowerPoint

TL43 - Microsoft XNA Game Studio: An Overview
Frank Savage
Video PowerPoint

TL44 - IronRuby: The Right Language for the Right Job
John Lam
Video PowerPoint

TL45 - Microsoft Visual Studio Team System Database Edition: Overview
Gert Drapers
Video PowerPoint

TL46 - Microsoft Visual C# IDE: Tips and Tricks
Dustin Campbell
Video PowerPoint

TL47 - Microsoft Visual Studio Team System: A Lap Around VSTS 2010
Cameron Skinner
Video PowerPoint

TL48 - Microsoft Visual Studio: Web Development Futures
Jeff King
Video PowerPoint

TL49 - Microsoft .NET Framework: Overview and Applications for Babies
Scott Hanselman
Video PowerPoint

TL50 - Research: BAM, AjaxScope, and Doloto
Emre Kiciman, Ethan Jackson
Video PowerPoint

TL51 - Research: Contract Checking and Automated Test Generation with Pex
Mike Barnett, Nikolai Tillmann
Video PowerPoint

TL52 - Team Foundation Server 2010: Cool New Features
Brian Harry
Video PowerPoint

TL54 - Natural Interop with Silverlight, Office, and Python in Microsoft Visual C# and Microsoft Visual Basic
Alex Turner
Video PowerPoint

TL55 - The Concurrency and Coordination Runtime and Decentralized Software Services Toolkit
George Chrysanthakopoulos
Video PowerPoint

TL56 - Project "Velocity": Under the Hood
Anil Nori
Video PowerPoint

TL57 - Panel: The Future of Programming Languages
Anders Hejlsberg, Douglas Crockford, Erik Meijer, Gilad Bracha, Jeremy Siek, Wolfram Schulte
Video PowerPoint

TL58 - Research: Concurrency Analysis Platform and Tools for Finding Concurrency Bugs
Madan Musuvathi, Thomas Ball
Video PowerPoint

TL59 - Visual Studio Debugger Tips & Tricks
John Cunningham
Video PowerPoint

TL60 - Improving Code Quality with Code Analysis
Ravs Kaur
Video PowerPoint

TL61 - Panel: The Future of Unit Testing
Euan Garden, Jim Newkirk, Nikolai Tillmann, Peter Provost
Video PowerPoint

Enjoy!

Visual Studio 2008 SP1: Sync Services for ADO.Net with SQL Server 2008 Change Tracking

Guy Burstein — Tue, 13 May 2008 00:00:00 GMT

Visual Studio 2008 SP1: Sync Services for ADO.Net with SQL Server 2008 Change Tracking

One of the main pillars of Visual Studio 2008 and .Net Framework 3.5 Service Pack 1 if the better integration with SQL Server 2008. Service Pack 1 now uses the Change Tracking capabilities of SQL Server 2008 in order to identify the incremental changes.

During the process of writing this post, I am building a simple application with both Visual Studio 2008 and Visual Studio 2008 + SP1 in order to spot the changes in Sync Services for ADO.Net in SP1.

The first thing you notice when you add a new Local Database Cache item, is the Use SQL Server change tracking checkbox. The wizard knows that the connection on the server side was a SQL 2008 connection, and then enabled this checkbox.

When this option is enabled, and you click on the add button in order to select the tables you would like to synchronize, the database schema doesn't need to be changed like it used to be in earlier versions besides enabling the change tracking at the level of the database and each table you want to synchronize.

You can notice in the screenshot above that the Script Generation section of this page is missing. This is because those script are not only at the level of each table, but also at the level of the database itself, where you'd want to enable the change tracking.

When you confirm the Configure Data Synchronization Wizard, you will get the following message:

This message replaces the missing script generation section at the table level and when you confirm it, it will generate the scripts for each table and for the database.

But the difference is, that instead of generating a long script that adds several columns and a tombstone table, it only enabled the change tracking at the database level and at the table level.

Summary

Sync Services for ADO.Net in Visual Studio 2008 SP1 now uses SQL Server 2008 Change Tracking and has the tools support for it. When you use a SQL Server 2008 connection, you don't have to change the database schema but to enable change tracking.

Enjoy!