Re: NTier Develpoment

From: Paul Glavich [MVP - ASP.NET] (glav_at_aspalliance.com-NOSPAM)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 22:30:36 +1000

Option 3 will be hard to do as the class will typically exist in a different
application domain therefore the notification will only occurr on those
applications registeed to receive notifications within the same app domain.
So basically, 3 apps, 3 app domains, 1 copy of the data tier in each app
domain. You would need to use a common notification point (ie. register the
data tier to call a web service on each app) or a .Net remoting entry point
into each app.

The 1st 2 scenarios are probably easier but less real-time. 

-- 
- Paul Glavich
Microsoft MVP - ASP.NET
"richlm" <rich_lm@h0tmai1.com> wrote in message
news:ezBLjj0nEHA.536@TK2MSFTNGP11.phx.gbl...
> There are several alternatives, depending largely on how "real-time" your
> solution needs to be - and how much you want to avoid coupling between
your
> different apps.
>
> 1. Poll the data in the relevant tables - for example by using a timestamp
> column. This is the simplest solution and works just fine in many
scenarios.
>
> 2. SQL Server notification services. This is really targetted more towards
> mobile device scenarios but it might just be useful in some client/server
> scenarios.
>
> 3. Establish some sort of event/callback mechanism from your business tier
> or from the SQL server using extended SPs and triggers.  Avoid this route
> unless you really do need that real-time performance, as it introduces
> strong coupling between your apps and can bring in all sorts of problems
> with scaleability, manageability etc.
>
> There are probably many other solutions...but a general advice - don't try
> to re-invent stuff that SQL server can already do for you - you can save
> yourself a whole load of code to write & maintain.
>
> Richard.
>
>
> "Ldraw" <Ldraw@discussions.microsoft.com> wrote in message
> news:C0355FA2-50A4-49F6-B616-BE3E2B94AAF6@microsoft.com...
> >I have three applications that will use the services of a busines tier
> >class
> > to gain acces to an SQL database. If one of the applications updates the
> > data
> > how can I notify the other two applications that the data has been
> > modified.
> > What would be the best approach considering that each application is
> > running
> > in its own process?
>
>

Relevant Pages

  • Errors and erros
    ... My clients are encountering errors on applications which have been in place ... On has SQL Server as a back end for one app and Access as the ... Each app has different issues. ...
    (microsoft.public.access.formscoding)
  • Re: Bad performance with SQL Application when connecting from client
    ... what kind of conection do you use in the app.? ... > I've a problem with a application witch uses SQL Server 2000 STD. ... > applications on the same SQL instance have no problems. ...
    (microsoft.public.sqlserver.server)
  • Re: Simple SQL Server Question (I think)
    ... >> Is SQL Server 2000 usually run on a dedicated server ... >> perhaps one app that requires it, or can you put it on ... >applications can be CPU intensive and SQL Server relies ... on available CPU ...
    (microsoft.public.sqlserver.server)
  • RE: More on Shatter
    ... Latency for the WM_TIMER message is irrelevant. ... load, and you code an app to fire WM_TIMER's at every 50ms, your WM_TIMERS ... > try to do real-time things (as I wager most applications ...
    (Vuln-Dev)
  • Re: Safely SHUTDOWN Device from Application
    ... If you have only specific applications then you could designate one to be ... How you handle suspend is very much hardware dependent, ... It's then up to the app to take ... By 'Safe Shutdown', I meant that any application writing/reading to/ ...
    (microsoft.public.windowsce.platbuilder)
Loading