C#發現之旅第十二講：基於反射與動態編譯的快速ORM框架（下）第11部分

新增/刪除/更新核心操作實作

框架對外暴露簡潔 API，內部統一透過 GetHelper 取得輔助器，再委派具體命令構建：

InsertObject

public int InsertObject(object RecordObject) {
    CheckConnection();
    if (RecordObject == null) throw new ArgumentNullException(nameof(RecordObject));
    var helper = GetHelper(RecordObject.GetType());
    using (var cmd = Connection.CreateCommand()) {
        int fields = helper.FillInsertCommand(cmd, RecordObject);
        return fields > 0 ? cmd.ExecuteNonQuery() : 0;
    }
}

DeleteObject

public int DeleteObject(object RecordObject) {
    CheckConnection();
    if (RecordObject == null) throw new ArgumentNullException(nameof(RecordObject));
    var helper = GetHelper(RecordObject.GetType());
    using (var cmd = Connection.CreateCommand())
        return helper.FillDeleteCommand(cmd, RecordObject) > 0 ? cmd.ExecuteNonQuery() : 0;
}

UpdateObject

public int UpdateObject(object RecordObject) {
    CheckConnection();
    if (RecordObject == null) throw new ArgumentNullException(nameof(RecordObject));
    var helper = GetHelper(RecordObject.GetType());
    using (var cmd = Connection.CreateCommand()) {
        int fields = helper.FillUpdateCommand(cmd, RecordObject);
        return fields > 0 ? cmd.ExecuteNonQuery() : 0;
    }
}

另提供 InsertObjects、DeleteObjects、UpdateObjects 批次版本，原理相同。

WinForm 測試介面

使用 Access 建立 Employees 表，對應 DB_Employees 實體，介面包含清單、明細編輯對話框，驗證框架易用性與效能。