Re: client type - I was more wondering is it a web app? Windows app? Silverlight? Windows intranet app could do udp broadcast of changes from the server or something like that.
Sent from my iPhone On 29/03/2011, at 8:18 AM, Grant Molloy <[email protected]> wrote: > 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 > >
