Practical Information

Question 1

How do you start a transaction?

Answer 1

SqlTransaction transaction = connection.BeginTransaction();

Question 2

How do you create SQL command Objecs when dealing with transactions?

Answer 2

SqlCommand command = connection.CreateCommand() ;
 command.Transaction = transaction;

Question 3

What control block must be used with transactions?

Answer 3

try and cactch block

Question 4

How do you use parametized queries?

Answer 4

string query = "SELECT * FROM products WHERE Name = @Name";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@Name", userInput);

Question 5

How do you see if a reader object has rows?

Answer 5

reader.HasRows