修改
2021-11-15 Less than 1 minute
# Demo
本次分表的demo源码：SqlServerShardingDataSource (opens new window)
# 自动追踪修改
public async Task<IActionResult> Update()
{
var sysUser = await _myDbContext.Set<SysUser>().Where(o => o.Id == "1").FirstOrDefaultAsync();
sysUser.Name = "new name";
var i=await _myDbContext.SaveChangesAsync();
return Ok(i);
}
1
2
3
4
5
6
7
2
3
4
5
6
7
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (13ms) [Parameters=[@p1='?' (Size = 50) (DbType = AnsiString), @p0='?' (Size = 50) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [SysUser] SET [Name] = @p0
WHERE [Id] = @p1;
SELECT @@ROWCOUNT;
1
2
3
4
5
6
2
3
4
5
6
# 非自动追踪修改
public async Task<IActionResult> Update1()
{
var sysUser = await _myDbContext.Set<SysUser>().AsNoTracking().Where(o => o.Id == "1").FirstOrDefaultAsync();
sysUser.Name = "new name";
_myDbContext.Update(sysUser);
var i = await _myDbContext.SaveChangesAsync();
return Ok(i);
}
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (1ms) [Parameters=[@p2='?' (Size = 50) (DbType = AnsiString), @p0='?' (Size = 50) (DbType = AnsiString), @p1='?' (Size = 50) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [SysUser] SET [Area] = @p0, [Name] = @p1
WHERE [Id] = @p2;
SELECT @@ROWCOUNT;
1
2
3
4
5
6
2
3
4
5
6
结论
追踪情况下sharding-core依然可以对结果进行修改，修改的字段是被修改过后的字段
非追踪情况下sharding-croe也支持查询修改，但是修改的字段是全字段