If your problem statement requires you to cache the DB recordset in the MiddleTier and invalidate the cached data on periodic or on certain notifications, you can take advantage of SQLDependency or Query Notifications. Ref Implementation details @:
http://support.microsoft.com/default.aspx/kb/555893
