Preparing Statements in Connector/Net
To prepare a statement, create a command object and set the .CommandText
property to your query.
After entering your statement, call the .Prepare
method of the MySqlCommand
object. After the statement is prepared, add parameters for each of the dynamic elements in the query.
After you enter your query and enter parameters, execute the statement using the .ExecuteNonQuery()
, .ExecuteScalar()
, or .ExecuteReader
methods.
For subsequent executions, you need only modify the values of the parameters and call the execute method again, there is no need to set the .CommandText
property or redefine the parameters.