怎么处理生成列

[fine-linx]

表里面有一列的值是其他两列计算得来的，要把IsIgnore设为true插入的时候才不会报错，但是查询的时候查不到这一列的值，不在查询语句里

[2881099]

[Column(CanInsert = false, CanUpdate = false)]

[fine-linx]

测试了一下，AutoSyncStructure开启的时候就会报错，关闭了就好了

[ApiExplorerSettings(GroupName = "测试FreeSql")]
[AllowAnonymous]
[Route("/test/[controller]/[action]")]
public class TestFreeSqlController(IFreeSql<DbScm> freeSql) : BaseController
{
    [HttpPost]
    [SwaggerOperation("插入")]
    public async Task<RspCommon> Insert(TestFreeSqlTable model)
    {
        await freeSql.Insert(model).ExecuteAffrowsAsync();
        return RspCommon.Ok();
    }

    [HttpGet]
    [SwaggerOperation("查询")]
    public async Task<RspCommon> Query(long id)
    {
        var data = await freeSql.Select<TestFreeSqlTable>()
            .Where(x => x.Id == id)
            .ToOneAsync();
        return RspCommon.Ok(data);
    }
}

[Table(Name = "test_freesql")]
public class TestFreeSqlTable
{
    [Column(IsPrimary = true, IsIdentity = true)]
    public long Id { get; set; }

    public int Item1 { get; set; }

    public int Item2 { get; set; }

    [Column(CanInsert = false, CanUpdate = false)]
    public int Item3 { get; set; }
}

[2881099]

你这种不是计算列啊，就是不映射了，IsIgnore = true 即可

[fine-linx]

是计算列啊

CREATE TABLE `test_freesql` (
  `Id` bigint NOT NULL AUTO_INCREMENT,
  `Item1` int NOT NULL,
  `Item2` int NOT NULL,
  `Item3` int GENERATED ALWAYS AS ((`Item1` + `Item2`)) STORED,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

第一个图是关闭了AutoSyncStructure的，设置了

 [Column(CanInsert = false, CanUpdate = false)]
 public int Item3 { get; set; }

之后可以正常插入，查询也能查得到Item3。第二个图是开启AutoSyncStructure的，一插入就报错

[2881099]

[Column(CanInsert = false, CanUpdate = false, DbType = "int GENERATED ALWAYS AS ((Item1 + Item2)) STORED")]
public int Item3 { get; set; }

[fine-linx]

可以了，谢谢大佬