Wednesday, May 12, 2010

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.

No comments:

Post a Comment