Thanks everyone for feedback.. Joseph, SQL Server, yes, version either 2008 or 2008 R2.. More than likely R2, but not nailed down yet. Client type is a DAL DLL.. I want the DAL to know when the data changes, and the client will subscribe to DAL events, and then DAL can fire off event when data is changed, and App can decide what to do about it. Kind of like a publisher / subscriber model implementation.
I'm not 100% sure I'm going about it the right way or have the events in the right place (ie in the DAL).. On Tue, Mar 29, 2011 at 1:55 AM, Joseph Cooney <[email protected]>wrote: > What type of client is it? Do you control the means by which data is > written to the table? Are clients deployed to the internet or intranet? What > kind of database are we talking about here (I assume you mean SQL Server, > since you mention SqlDependency) but which version? > > Joseph > > > On Mon, Mar 28, 2011 at 8:33 AM, Grant Molloy <[email protected]> wrote: > >> Hi list, >> >> I'm looking to have an application automagically update it's view of the >> data when the data in the connected database table changes. >> I've seen two main ways to do this so far. >> 1. Poll the database every n seconds >> 2. Use the System.Web.Caching.SqlDependancy object. >> >> Does anyone else know of any other better or smarter way of doing this ? >> >> thanks >> Grant >> > > > > -- > > w: http://jcooney.net > t: @josephcooney > >
