How to: Use SQL Server Change Tracking. This topic provides an overview of SQL Server change tracking and describes a console application that performs bidirectional synchronization between a SQL Server database and a SQL Server Compact database.
If the server is running SQL Server 2008, we recommend that you use SQL Server change tracking. If the server is running a different database, see How to: Use a Custom Change Tracking System. In many of the examples in this documentation, change tracking is handled by a set of columns and triggers that are added to base tables, and additional tables to track delete operations.
Query Notification using SqlDependency and SqlCacheDependency. Table of Contents Well, it's been a nice time since I last posted in CodeProject.
Meanwhile, I got CodeProject MVP for the year 2011, it's my second time; and also got Microsoft MVP for this year too. It's always nice to receive this award and without your support, I wouldn't be what I am now. .NET 4.0 MemoryCache with SqlChangeMonitor. Download SqlChangeMonitor_Example.zip - 4.1 KB Summary There isn't a lot of documentation on the internet about how to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0, so I thought I would add my example:
