public async Task <int> SaveAsync(ExpenseRecord entity) { string commandText = DapperExtensions.InsertQuery(typeof(ExpenseRecord).Name, entity); using (var db = new MySqlConnection(_option.Value.ConnectionString)) { db.Open(); return(await db.ExecuteScalarAsync <int>(commandText, entity, null)); } }