Building the solution

Here is the high-level architecture of the solution:

The solution built using Windows Server AppFabric Cache along with SQL Server as the durable store will scale for WinOrBow needs. The application will use a cache-aside pattern the application accesses the cache for lookup data and if it is not found, would execute the query against the database server. After the application receives the object, it would populate the cache server for the subsequent set of accesses. In some cases, the cache can be front loaded with the common reference data, such as finished game information and news feed data, prior to any user request coming into the system. When games complete, the history can be updated in the cache tier. Updates to a user profile that needs to be durable can be made directly against the database server. Another approach could be leveraging notifications in the cache cluster when items are modified—the recipient of the notification can then store the object in...