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...
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
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.
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
Search Blog
My Courses
Ready
to start building Windows Phone 8 Applications? This is the book for you. I teach you how to build apps using Windows Phone 8. Order today!
Have the book? You can get the downloads and errata here.
Hosting provided by:
Raghuraman Tuesday, July 20, 2010
Wow !!! Another Great Post.Thank you.
KRK