Retrieving Last Insert ID in MySql Using Connector .NET

In MySql, the last insert ID refers to the identifier assigned to the newly inserted row. This value can be valuable in certain scenarios, such as populating foreign key relationships.

Originally, the ExecuteNonQuery method of the MySqlHelper class was assumed to return the last insert ID. However, this assumption is incorrect; it merely indicates the number of rows affected by the query. To retrieve the actual last insert ID:

1. Establish a MySql Connection:
   Create a MySql connection and open it explicitly.

MySqlConnection conn = new MySqlConnection(Global.ConnectionString);
conn.Open();

2. Execute the Query:
   Create a MySql command and execute the insert query using it.

MySqlCommand dbcmd = conn.CreateCommand();
dbcmd.CommandText = "INSERT INTO test SET var = @var";

3. Retrieve the Last Insert ID:
   After executing the query, access the LastInsertedId property of the command object to obtain the last insert ID.

long insertID = dbcmd.LastInsertedId;

Using this method, you can accurately retrieve the last insert ID generated by your MySql queries.