Hi all,

We are hiring a .NET C# developer and I have developed a technical test for the candidates to complete. They have an hour and it has two parts, some knowledge based questions covering asp.net, C# and SQL and a small practical test. I'd appreciate feedback on the test, is it sufficient to test the programmers ability? What would you change if anything?

Part One.

1. What the are events fired as part of the ASP.NET Page lifecycle. What interesting things can you do at each?

2. How does ViewState work and why is it either useful or bad?

3. What is a common way to create web services in ASP.NET 2.0?
4. What is the GAC?
5. What is boxing?
6. What is a delegate?
7. The C# keyword .int. maps to which .NET type?
8. Explain the difference between a Stored Procedure and a Trigger?
9. What is an OUTER Join?
10. What is @@IDENTITY?

Part Two:

You are provided with the Northwind Database and the attached DB relationship diagram. Please create a page which provides users with the following functionality. You don’t need to be too concerned with the presentation detail of the page.

1. Select a customer from a list, and see all the orders placed by that customer.

2. For the same customer, find all their orders which are Beverages and the quantity is more than 5.

I was aware of setting the right balance of difficulty on this as there is an hour's test. I was able to complete the practical test in under 30 mins using SQLDatasource and the query designer in visual studio and the test questions, I am looking to see how they approach it logically and whether they use the tools available.

Many thanks!