SQL Caching

Caching is a very useful way for you to retain pages or data across HTTP requests, so that you can reuse them without the recreating them.
In ASP.net 2.0, it makes you easier to implement data caching. SQL cache dependencies are one of ASP.net 2.0 coolest features, which allows you to create dependencies between cached items [...]

Protecting web.config Connection strings

It is recommended that store your database connection strings in the Web.config file and encrypt the connection strings. In the .NET Framework 2.0, you have the option to enable the configuration encryption in the <protectedData> section in the web.config file.
For example:
<protectedData>
<protectedDataSections>
<add name=”connectionStrings” provider=”RSAProtectedConfigurationProvider”/>
</protectedDataSections>
</protectedData>
There are two predefined providers that you can find in the .NET Framework [...]