The way its implemented on SQL Server is that the caching infrastructure on the client keeps a connection open to the server, and there's basically a stored procedure that it calls which only returns when there is a change notification on the server.
The tricky part is the implementation of the notifications on the server - the client is relatively easy. Dean. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > paul.mercea > Sent: Tuesday, 12 December 2006 5:20 am > To: 'For users and developers of the Firebird .NET providers' > Subject: Re: [Firebird-net-provider] Caching is possible? > > > >> Entire system will fire database only when update will apear. > >That is an Sql Server 2005 specific feature. > It could be implemented using events from database. > Probably best way is to use web service for that. > > Thanks, > Paul > > -- > Carlos Guzmán Álvarez > Vigo-Spain > > http://carlosga.wordpress.com > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's > Techsay panel and you'll get the chance to share your opinions on IT & > business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
