In ADO.NET, what are the different ways to call a stored procedure?
- Call() method, Invoke() method, ExecuteProcedure() method, Run() method
- CommandText property, ExecuteNonQuery() method, ExecuteReader() method, ExecuteScalar() method
- ExecuteNonQuery() method, ExecuteScalar() method, ExecuteReader() method, Execute() method
- ExecuteStoredProc() method, ExecuteStoredProcedure() method, ExecuteSP() method, CallStoredProc() method
In ADO.NET, you can call a stored procedure using the ExecuteNonQuery() method to execute a command that doesn't return any result set, ExecuteScalar() method to execute a command that returns a single value, and ExecuteReader() method to execute a command that returns a result set. The Execute() method can also be used to execute any type of command.
Loading...
Related Quiz
- To perform an outer join in LINQ, you can use the DefaultIfEmpty() method in conjunction with the ___________ clause.
- Scenario: You want to update an existing order's shipping address in a SQL Server database using LINQ to SQL. Which LINQ to SQL method or operation is appropriate for this situation?
- In ADO.NET, what is the role of parameters in non-query commands?
- When using data binding in WinForms, what is the role of the BindingSource component?
- DataViews are particularly useful when you want to present a ___________ of your data to the user.