sqldependency
How to track changes in many SQL Server databases from .NET application?
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)[详细]
2022-12-27 23:25 分类:问答Elect one web application instance to perform a task triggered by an external event?
I have an ASP.NET application running on multiple IIS6 web servers, with a SQL Server 2005 database back-end.[详细]
2022-12-22 08:29 分类:问答SqlDependency query with WHERE clause not allowed. How can I modify it to be valid?
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 "[详细]
2022-12-21 16:52 分类:问答How to apply Sql Dependency in ASP.NET MVC?
H开发者_StackOverflow社区ow can we apply Sql Dependency in Asp.Net MVC for cached objects?MSDN says:[详细]
2022-12-18 19:22 分类:问答SQL Server Notifications - My OnChange does not fire
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[详细]
2022-12-14 04:31 分类:问答Cache drop if query has WHERE Clause
I am using SqlDependency and CacheManager class(Enterprise library Cachcing block) to create a cache in one of vb.net project.[详细]
2022-12-13 18:52 分类:问答Windows Application SqlDepedency Calling Onchange infinitely
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[详细]
2022-12-12 13:12 分类:问答Returning data from SqldDependency
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[详细]
2022-12-10 09:54 分类:问答
加载中,请稍侯......