Hi People,

Just wondering if anyone has managed to integrate the SQL Cache Dependency into an LLBLGEN adapter project, and if so how did you manage it? I’ve been looking into it but I'm not sure how to get access to the command object to be able to pass it into the Cache Dependency.

Thanks for you help! Alex

Did you check the following threads? http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7894 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=6580

Hi Walaa,

thank you, those helped, unfortunatly the limits on the SQL cache dependancy in the terms of what it will cache limits the options (no left outer joins, no computed fields etc).

Also I found it diffrcult to find an easy way to put items into the cache is there a cache that works for both web apps and win apps? (not really anything to do with LLBLgen but thought you might have an idea)

Thanks A

thank you, those helped, unfortunatly the limits on the SQL cache dependancy in the terms of what it will cache limits the options (no left outer joins, no computed fields etc).

Yeah it's a very long list of unsupported queries, here is the complete list for reference: Special Considerations When Using Query Notifications

Also I found it diffrcult to find an easy way to put items into the cache is there a cache that works for both web apps and win apps? (not really anything to do with LLBLgen but thought you might have an idea)

Do you mean a client server architecture, where the clients are the web and win apps, and the server os a service that has the DAL and performs the cashing within?

Do you mean a client server architecture, where the clients are the web and win apps, and the server os a service that has the DAL and performs the cashing within?

Yep thats the idea, but you cant use the web caching (System.Web.Cache) in a winapp. is there a generic caching component that people are using?

I would use the Enterprise Library for .NET Framework 3.0 which contains a caching application block.

http://www.microsoft.com/downloads/details.aspx?FamilyID=62EF5F79-DAF2-43AF-9897-D926F03B9E60&displaylang=en

This provides supporting objects which allow you to cache data and will work for both win and web forms applications

Hi Matt Adamson,

Thanks for the reply, does it support the SQL cache dependancy? And how much of a nightmare is it to configure as the previous 1.0 ones where a real real pain with the whole event log entires that needed to be added.

Thanks Heaps! A