Developer Assessment

Show how you would convert DateTime.UtcNow into central time zone.

Describe the result of this statement: IMyInterface proxy = Factory.Create<IMyInterface>();

A database table called ‘Listing’ exists with the following fields: ID (int, pk), Name (varchar), IsPromoted (bit). Write a SELECT statement that accepts @Query as input, and returns all entries from this table with a partial match on this. Promoted listings, if they exist in the results, should be boosted so that they appear in every odd result, starting with position #1.

Write the HTML for a form, asking the user for their name, email and phone number.