Problem: There are a lot of different databases, which is populated by many different applications directly (without any common application layer). Data can be accessed only through SP (by policy)
I have an ASP.NET application running on multiple IIS6 web servers, with a SQL Server 2005 database back-end.
I have a SqlDependency set up using the following query: string sql = "SELECT dbo.Case.CMRID, dbo.Case.SolutionID, dbo.Case.CreateDT, dbo.Case.ModifyDT "
H开发者_StackOverflow社区ow can we apply Sql Dependency in Asp.Net MVC for cached objects?MSDN says:
I would like to make use of SQL Server notifications to capture insert events at my database within a winforms app. I am attempting to use the SQLDependency object. The MSDN articles make this seem pr
I am using SqlDependency and CacheManager class(Enterprise library Cachcing block) to create a cache in one of vb.net project.
I have console application in which I am doing sqldependency. My problem is when I set commandType as Text, it is working fine. But if I use commandType as StoredProcedure, onchange method is calling
I\'m trying to write a vb.net application that usesSqlDependency. The dependency will be triggered when data is added to the database.I\'m wondering开发者_运维技巧 if it\'s possible to have the depend