Share via

PDC 05 demos - Query Processing over DataSet, Fast Uploads, Caching

  • Article

First of all I’ll have to apologize because it took me several months to put this code out here. Right after PDC we were so busy that I didn’t have the chance before to sit down, clean-up the code a little bit, add a bunch of comments and write a README file.

Finally, here are the samples for the PDC session DAT408 - "ADO.NET 2.0: Advanced Data Access Patterns". The demos include:
- A small sample query processor that allows you to run queries (with projection, filter and joins) over the DataSet
- An implementation of a technique for really fast change processing against a database server
- A demonstration of a caching scheme that uses SqlDependency and DataSet for granular cache loading and expiration

You can also see the actual talk with me speaking here, you can download the slide deck here, and the whole talk for offline viewing here.

Enjoy! (and sorry again for the delay :)

Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corporation

Comments

  • Anonymous
    January 10, 2006
    I attended this talk at the PDC, and it was one of the best of the show. I've been missing the sample code -- thank you very much!

  • Anonymous
    January 10, 2006
    I had been looking forward to this. :). Thanks for making these available.

  • Anonymous
    January 10, 2006
    Thanks man! I am so glad you posted this. It was an amazing presentation.

  • Anonymous
    January 10, 2006
    w00t - I have been looking for these guys since the PDC ended (both here and on the data access insiders NG). I have to agree with Jeff, one of the best talks at the show. Thanks Pablo.

  • Anonymous
    January 12, 2006
    Just wanted to echo that this presentation and demo was the best one at the PDC.

    I presented this to the Phoenix SQL Server User Groups last night (with proper HUGE plaudits to Pablo) and everyone loved it.

    One item that I think needs to be covered in a white paper on MSDN or on a blog somewhere is EXACTLY what is required to make the SqlDependency Class work with SQL 2005 from a service, security, configuration perspective. I've heard/read all kinds of things on the requirements but I can not find it listed anywhere in a succinct manner.

    When I ran the demo from the presentation with the SQLDependency - it first it didn't work - the breakpoint in the global.asax file that starts the SqlDependency didn't fire. I can't remember what I did to get it to work - whether it was a reboot, recompile of the project or what, but all of a sudden it started to work.

    When I then tried to run it again at the presentation, it didn't work.

  • Anonymous
    January 18, 2006
    Tremendous talk, great presentation. Demos rocked! Pablo, when are you planning next talk?

  • Anonymous
    January 19, 2006
    boy i am humbled

  • Anonymous
    January 27, 2006
    The comment has been removed

  • Anonymous
    June 21, 2006
    Welcome to the Microsoft Data blog. I’m Samuel Druker and I lead a group that’s responsible for building...

  • Anonymous
    February 09, 2007
    Pablo Castro, seful echipei de ADO.NET si-a publicat prezentarea si demo-urile de la PDC: http://blogs.msdn.com/dataaccess/archive/2006/01/09/510083.asp

  • Anonymous
    April 02, 2008
    Pablo Castro, seful echipei de ADO.NET si-a publicat prezentarea si demo-urile de la PDC: http://blogs.msdn.com/dataaccess/archive/2006/01/09/510083.asp

  • Anonymous
    January 21, 2009
    PingBack from http://www.keyongtech.com/446704-what-is-the-quickest-most