Sams Teach Yourself ADO.NET in 21 Days

Workshop

This workshop will help reinforce the concepts covered in today's lesson.

Quiz

1:	Why would you use stored procedures rather than dynamic or inline SQL?
A1:	If stored procedures are supported by your data store, you should consider using them because they can be used to implement a layer of abstraction for your applications, as well as increase both performance and security. However, you might want to use inline SQL if your application needs to supports multiple data stores.
2:	Which execute method might you use when executing a SQL statement that uses an aggregate function?
A2:	Typically, SELECT statements that use aggregate functions such as SUM, MIN, MAX, COUNT, and AVG can be easily executed using the ExecuteScalar method. This method ...