It's that time of year again. A quick note on some of the sessions/panel discussions I'll be presenting at, and some others that relate to SQL Server Compact.
Code | Session |
DAT325 | Unlocking the Power of Microsoft SQL Server Compact 3.5 Location: S220 E Presenters: Ginny Caughey and Steve Lasker |
|
|
TEO Panel _24 | Building Offline Enabled Applications Panel Discussion Location: Open Spaces on the main floor |
|
|
TEO Panel _33 | LINQ in the UI Layer Location: Open Spaces on the main floor |
|
|
MBL403 | Building Custom Sync Providers for the Microsoft Sync Framework |
|
|
WIN202 | Introduction to Microsoft Sync Framework |
|
|
MBL404 | Microsoft SQL Server 2005 Compact Ultimate Performance Tuning |
|
|
MBL07-TLC | Microsoft Synchronization Services for ADO.NET: From Desktops to Devices |
|
|
MBL01-TLC | Taking Data Offline: Introduction to Microsoft Synchronization Services for ADO.NET |
Road Trip
The week after Tech Ed Developers we'll be doing our next Road Trip. We still have some time in a few of the cities, so if you've got something interesting, let me know and we might be able to swing by.
- Tampa Florida, Monday-Tuesday, June 9th-10th
- Los Angeles , Wednesday, June 10th
- San Francisco, Friday, June 13th
PowerPoint Presentation
The following links were posted prior to Tech Ed. In typical fashion the content will continue to evolve until we actually present. I'll leave a note here when these have been updated post the session.
Tech Ed US 08 DAT325 - Unlocking the Power of SQL Server Compact
The following demos were presented either as part of the Unlocking the Power of SQL Server Compact session Ginny and I gave, shown at the booth, or shown at other presentations for our June '08 Road Trip
Demos
- Creating & Versioning Local Databases
- Database Viewer Utility
- Managed Stored Procedures
- SQL Server Compact Performance Testbed
- Enabling SQL Server Compact under ASP.NET
- Using SQL Server Compact as a Synchronized Trace Listener
- SQL Server Compact as a Custom Document Format - Recipe Manager
- Running SQL Server Compact from Read Only Media
- Integrating SQL Server Compact into Excel - By Ginny Caughey
- Logical Queuing
- SQL Server Compact ISAM APIs
- Updateable, Scrollable Cursors w/SqlCeResultSet
We'll be spending a lot of time at the booth hearing from all of you that have started to work with Compact. We continue to hear about cool scenarios, so come on by, and tell us what you like and what you think we need to do in our 4.0 release.
Thanks,
Steve
Hello Steve,
When I use the local db cache feature I would like to be able to use a VIEW from the main server to actually sync with my local cache because SQLCE does not support views, but the variables I am pulling to populate local db is coming from one or more tables from the server. How do I accomplish this?
I understand it gets a bit complicated when the sync is on both ends (Client/Server), but I am synchronizing only the client db then why isn’t views being supported to pull data from server?
Thanks,
Ram
Hi Ram,
I think you’re asking to enable “download only” data from Views on SQL Server. If that’s correct, this isn’t enabled through the designer, but can be done in code relatively easily. It’s effectively the same as a standard table for a view over a single table The challenge is actually in calculating “what changed” when you’re joining multiple tables. Since the view could represent rows from multiple tables, you have to actually ask the server “where T1.LastEdit > @anchor, or T2.LastEdit > @anchor, or T3.LastEdit > @anchor.
This extra logic isn’t incorporated into the SyncAdapterBuilder, which is what the designer is based upon, so you’d have to hand author the queries to get the deltas.
You could of course to a download each time, but then you’re really not getting the benefits of sync.
Hope that helps,
Steve