for RuBoard |
The command object, which inherits from the IDbCommand interface, is perhaps the heart of a .NET data provider. Command objects encapsulate the SQL “ or data store “specific syntax that is executed through a connection object. In ADO.NET, command objects are used to feed data readers, populate and synchronize DataSet objects, and execute commands that don't return result sets to the client. Commands can also be populated with parameters to enable dynamic execution.
Today you'll learn about all aspects of command objects and how they work in both the SqlClient and OleDb providers. Specifically, we'll cover the following concepts:
How to call stored procedures and inline SQL using commands
How to use the various execute methods to return different types of results through a command
How to modify data using commands
How to pass input parameters to a command and return output parameters and return values
for RuBoard |