iBatis Data Mapper如何判断SQL命令执行完成及获取任务完成通知

Great question! Let's break down exactly how iBatis.NET (the .NET flavor of iBatis) knows when an INSERT operation has fully wrapped up when using your C# data objects. At its core, iBatis leans on ADO.NET's synchronous execution model to get clear confirmation from the database.

Here's the step-by-step breakdown:

• Parameter Mapping & Command Setup
  When you call iBatis's Insert() method (like sqlMap.Insert("InsertUser", userEntity)), it first parses your SQL mapping file to map your C# object's properties to the INSERT statement's parameters. It then creates a SqlCommand object, binds it to an active database connection (either pulled from the connection pool or a new one), and loads all the parameter values.

• Synchronous Execution & Blocking Wait
  The critical piece: iBatis runs the command using SqlCommand.ExecuteNonQuery(). This method is synchronous and blocking—it sends the SQL to the database server, then waits until the server has fully processed the insert: that includes writing data to storage, enforcing constraints, running any triggers, and finalizing the entire operation. Only when the database sends back a confirmation (with the count of affected rows) does ExecuteNonQuery() hand control back to iBatis.

• Transaction Context Handling
  If your insert is part of a transaction (started via sqlMap.BeginTransaction()), the insert only gets persisted to the database when you call CommitTransaction(). This method also blocks until the database finishes committing the transaction. Once it returns, you can be 100% sure all operations in the transaction (including your INSERT) are fully completed.

• Exception-Based Failure Notification
  If anything goes wrong during the insert—like a constraint violation, dropped connection, or invalid data—ExecuteNonQuery() will throw an ADO.NET exception. iBatis wraps this exception and passes it up to your C# code. So if your code doesn't catch an exception after calling Insert(), you can safely assume the insert succeeded.

Example C# Code #

using (var sqlMap = SqlMapClientBuilder.BuildSqlMapClient("SqlMap.config"))
{
    try
    {
        // Execute INSERT and wait for completion
        int affectedRows = sqlMap.Insert("InsertCustomer", new Customer 
        { 
            FirstName = "Jane", 
            LastName = "Smith" 
        });

        // At this point, the INSERT is fully completed
        Console.WriteLine($"Inserted {affectedRows} record successfully!");
    }
    catch (SqlException ex)
    {
        // An exception means the insert failed
        Console.WriteLine($"Insert failed: {ex.Message}");
    }
}

For async operations (using InsertAsync()), the same logic applies—you'll await the returned Task<int>, which only completes once the database has finished processing the insert.

内容的提问来源于stack exchange，提问作者Abhishek