How We Used Data in GiveAQuiz.com

  • Jul 19, 2010 at 11:53 AM
  • Shawn Wildermuth
  • 4 Comments

Url: http://msdn.microsoft.com/en-us/library/ff84745...

Silverlight Logo

As many of you may have heard, I recently launched http://GiveAQuiz.com as a new web site for creating and taking quizzes. The Data Team at Microsoft were great in helping me build this site. I've written a whitepaper detailing how we used the Microsoft data stack to accomplish it. This whitepaper shows how we used these data technologies to build the site:

  • SQL Server 2008
  • Entity Framework 4
  • WCF Data Services 4
  • Visual Studio 2010’s SQL Server Database Project
  • SQL Server Reporting Services 

If you are using Microsoft's Data stack for your own web-based and/or Silverlight site, give a look...hopefully some lessons learned you can use:

http://msdn.microsoft.com/en-us/library/ff847451.aspx

 

 

Comments

Gravatar

Raghuraman Tuesday, July 20, 2010

Wow !!! Another Great Post.

Thank you.

KRK

Gravatar

George Thursday, July 22, 2010

Shawn this is an error that i received after 2 minutes playing with the application.

Server Error in '/' Application.
--------------------------------------------------------------------------------

Violation of UNIQUE KEY constraint 'Quizzes_Unique_Password'. Cannot insert duplicate key in object 'GiveAQuiz.Quizzes'.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'Quizzes_Unique_Password'. Cannot insert duplicate key in object 'GiveAQuiz.Quizzes'.
The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Gravatar

Shawn Wildermuth Thursday, July 22, 2010

Sorry George. This was supposed to be fixed in the last drop. Its on our list to address. The fix was to catch the problem and tell the user to try an other quiz password (they have to be unique).


Leave a Comment

*
*
*