Hi Joseph, I wasn't really looking at any particular single client solution..
If Paul Stovell is listening, what did you use in Bindable Linq.. I am downloading now to have a look, but thought you may be able to put into words for larger audience.. thanks On Tue, Mar 29, 2011 at 9:59 AM, Joseph Cooney <joseph.coo...@gmail.com>wrote: > 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 <graken...@gmail.com> 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 < <joseph.coo...@gmail.com> > joseph.coo...@gmail.com> 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 < <graken...@gmail.com> >> graken...@gmail.com> 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>http://jcooney.net >> t: @josephcooney >> >> >