Cache database linked to Sql server with Silverlight 4.0 and WCF RIA

This is interesting project, We have a Cache Database for specific application and the database design and control was proprietary for this application. We were allowed to used the data but no modification were allowed on the server. After carefully review of the situation I came up with the idea to add a cache database linked with sql server.. Linking to SQL Server gave us three fundamental advantages..

1) Writing SP's in SQL Server while utilizing data from Cache database.
2) Writing Views
3) No changes in the Cache database.

After successfully linked with cache database we built the application on state of the art platform Silverlight 4.0 and WCF RIA Services.

Proxy Authehtication Issues With SQL Server Reporting Services

It is always a mess when try to deploy a report on a Secured Proxy Enabled Network. We faced this issues many time and every time the answer was same just add the following lines of code in your development studio config file or "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe.config"

<system.net>
<settings>
<ipv6 enabled="true">
</ipv6>
<defaultproxy enabled="true" usedefaultcredentials="true">
<proxy bypassonlocal="True" proxyaddress="http://dhsproxy.hsa.org">
</proxy>
</defaultproxy>

</settings></system.net>


Just replace the proxyaddress to your proxy address and everything will work like a charm...
to get the proxy address goto

IE->Tools->Internet Options->Connections(tab)->Click LanSettings button-> Copy text from Address text box.

Code is Published with the help of www.blogcrowds.com

Cheerz
Jaweed Sarfraz