B
Bhavesh
Hi Experts
I'm Newbie to asp.net application development, i'm currently creating
basic application using asp.net 1.x and sql server 2000.
I have noticed some problems with my application, when a record on the
database is update using web apps e.g. customer change of address. Now
if i search for the customer on web app it shows old address and when
check on the database (SQL Server), i can see a new address.
So here the solution i found was to close the IE Browser and load
again, now i can view the new address.
After doing some sort of research i found its asp.net and sql server
cache that cause this behaviour.
Please can someone explain about this cache and what is the default sql
cache timeout and what is workaround to refresh cache after such
updates.
Regards
Bhavesh
I'm Newbie to asp.net application development, i'm currently creating
basic application using asp.net 1.x and sql server 2000.
I have noticed some problems with my application, when a record on the
database is update using web apps e.g. customer change of address. Now
if i search for the customer on web app it shows old address and when
check on the database (SQL Server), i can see a new address.
So here the solution i found was to close the IE Browser and load
again, now i can view the new address.
After doing some sort of research i found its asp.net and sql server
cache that cause this behaviour.
Please can someone explain about this cache and what is the default sql
cache timeout and what is workaround to refresh cache after such
updates.
Regards
Bhavesh