I have a web site that is highly dependant on a SQL Server 2008 database. I am using linq to sql to connect to the database and require the website to reflect database changes immediately. Currently the changes are only reflected once a postback occurs and the database is requeried.
Is there a way to get the asp.net page(s) to be alerted of an database change and then to reflect it immediately, or within seconds, on the display? I am aware that one can use the SQLDependency class and ADO.NET to do this, but am not aware of any linq to sql possibilities.
Any help will be greatly appreciated.
View Complete Post