开发者

ASP.NET & Entity Framework 4.0 data not refreshing on screen

开发者 https://www.devze.com 2023-01-14 02:25 出处：网络

I\'ve written a 2-tier C# asp.net application. Everything works OK, but if I modify the SQL Server data using the management console, the changes are not displayed on screen. It seems the applicatio

相关专题：asp.net caching entity-framework sql

I've written a 2-tier C# asp.net application.

Everything works OK, but if I modify the SQL Server data using the management console, the changes are not displayed on screen. It seems the application reads the data from a cached instance.

I have tried everything to make sure it's not a browser cache issue... t开发者_如何转开发he data remains static until I restart the app or restar the web site. even clearing IIS cache doesn't help. If the data is updated by the application, it works ok... Any info about a default setting on the EF that caches data automatically?

I'm running Win Server 2k8 and SQL Server 2008, but the problem was there also for SQL2005.

I have no experience with this, but maybe the SqlCacheDependency can help you. See this article for more info: http://davidhayden.com/blog/dave/archive/2006/04/29/2929.aspx