system.data

What is the purpose of using CommandType.Tabledirect?

by

CommandType contains names that specifies how a command string is interpreted. CommandType.Text for an SQL text command. (Default.) CommandType.StoredProcedure for the name of a stored procedure. CommandType.TableDirect for the name of a table. All rows and columns of the named table will be returned when you call one of the Execute methods. NOTE: TableDirect is … Read more

Why use a using statement with a SqlTransaction?

by

A using statement should be used every time you create an instance of a class that implements IDisposable within the scope of a block. It ensures that the Dispose() method will be called on that instance, whether or not an exception is thrown. In particular, your code only catches managed exceptions, then destroys the stack … Read more