1

I've a question regarding SqlCacheDependency configuration. Every resource I've read requires the developer to define the polled databases into web.config. This is not a good scenario for our application that connects to different databases, because we don't want to edit web.config each time we add / remove a database.

We tried to configure it using SqlCacheDependency and SqlCacheDependencyAdmin in application startup but it seems that you must anyway configure everything in web.config.

Do you know a possible solution? Thanks, Marco

Marconline
  • 1,108
  • 12
  • 30
  • 1
    I've been trying to work out how to answer this question but I'm not sure I understand your scenario correctly - can you add some more detail? Your application uses multiple databases - do you let your uses enter a connection string, or do you have multiple connection strings defined in your web.config? – PhilPursglove Aug 05 '10 at 14:47
  • 1
    Hi and thanks for your interest into my issue. I've just one connection string changed at runtime based on username. Each user has a different db. thanks, Marco – Marconline Aug 19 '10 at 13:40
  • 1
    Marco - I'm trying to do this now, have you figured out anything yet? I have a connection string which holds a variable that we replace - I can't change this, hoping I can somehow set this up. Thanks! – Neil M. Oct 08 '12 at 22:14
  • 1
    No, sorry Neil :-( I've given up on this ! – Marconline Oct 17 '12 at 13:27

0 Answers0