Visual Studio Team Interviews

SQL 2008 & Occasionally Connected Client Support in Visual Studio SP1

Download this episode

Download Video

Description

In this interview, Milind Lele, a PM on the Visual Studio Pro Tools team shows us the improvements made to the tooling in Visual Studio SP1 for occasionally connected clients as well as the new data type support for SQL Server 2008. Using SQL 2008 built-in change tracking, you don't need to make modifications to your table schemas like you have to do with SQL 2005. Additionally he shows off a "smarter" DataSet designer where you can have tables coming from server and client data stores all contained within one model.

Enjoy,
-Beth Massi, VS Community

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • Gregory

      The moment the tables are synchronized (13:21) the order data changes! The customer jumps from "Vins et alcools Chevalier" to "Alfreds Futterkiste", employee from "Buchanari" to "Davolio.", and shipper from "Federal Shipping" to "Speedy Express"... But I guess we didn't change that after our sync... How come?

      Sincerely, Greg.

    • vesuvius
      I really enjoyed the first video on sync, but this does make things so much easier.Having an employees table, suppliers etc. on a local machine does reduce the amount of hits on a server significantly. This is another reason why (for me at least) using the Linq to SQL ORM instead of datasets is a no brainer. Even the Entity framework will not have this level of support and I predict it will be some time before it does.

      Keep up the great work!
    • aL_
      again with the letterboxing.. :/

      the small pip of the interview during on screen demos are awsome though Smiley
    • aL_
      btw does the syncing stuff work other databases as well? the sql server spesific stuff dosnt work of course, but there was some mention of another technique with tables that vs generated? that would be awsome Smiley
    • Murtaza
      @Gregory:

      Its possible that when the dataset got repopulated, the current record was reset to the first record.
    • MilindL
      >> The moment the tables are synchronized (13:21) the order data changes
      Indeed. Smiley

      This is because after the sync I did a fill for the datasets. This clears and refills that dataset.
      A better approach is to use merge.

      Me.NorthwindDataSet.Shippers.Merge(Me.ShippersTableAdapter.GetData())

    • MilindL
      >>btw does the syncing stuff work other databases as well?
      Unfortunately, no. The Sync Services runtime does not support non-SQL Server databases.
    • michael1047
      Javascript error on page, cannot see video

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.