ASP.NET 在 SQL 中对报表进行排队然后在可用时更新用户的最佳方法
我想允许网站上的用户对报告进行排队（在 SQL 表中输入请求）。该队列将由 Windows 应用程序处理，该应用程序将从 SQL Server 读取队列、运行报告并更新记录中的 reportcomplete 字段。我需要能够发布一条消息，内容类似于“生成报告”，然后在报告可用时提醒用户。我已经玩过 SQLDependency 并且可以触发 onchange 事件，但当然我无法返回到已经在浏览器中加载的页面。关于如何实现这一点几乎没有想法，我认为 SQLDependency 可能是错误的途径。有什么想法吗？
I want to allow users on the website to queue a report (enter the request in a sql table). The queue will be processed by a windows app that will read the queue from the sql server, run the reports, and update the reportcomplete field in the record. I need to be able to post a message saying something similar to "Generating report" and then alert the user when the report is available. I have toyed with SQLDependency and I can get the onchange event to fire, but of course I can't get back to the page that has already loaded in the browser. Pretty much out of ideas on how to accomplish this, and I'm thinking SQLDependency might be the wrong avenue. Any ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
HTTP 无法连接回客户端。唯一的解决方案是让客户端进行轮询，通常通过长尾（例如 Comet Ajax ）请求。因此，原始页面请求返回，脚本在结果页面上启动并发布后台请求，该请求输入 ASP.Net 代码并阻止事件。 SQLDependency 通知该事件，因此长尾请求重新激活并将响应返回给代理，代理现在完成了 Ajax 调用并可以更新页面。至少这是10000英尺的视野。这可以工作，但无法扩展（主要是因为 Ajax 请求占用了资源，阻塞了 ASP.Net 处理线程）。存在更具可扩展性的方法，但要复杂得多。
HTTP cannot connect back to the client. The only solution is to for the client to poll, usually via a long tail (eg. Comet Ajax) request. So the original page request returns, a script starts on the result page and posts a background request that enters the ASP.Net code and blocks on an event. The SQLDependency notifies the event, so the long tail requests re-activates and returns the response to the agent, which now completes the Ajax call and can update the page. At least this is the 10000 ft. view. This will work, but won't scale (primarily because of the resources tied up by the Ajax request, the blocked ASP.Net processing thread). More scalable approaches exists, but are significantly more complex.