问题描述
我的"Work_Table"表中有一个列workid,appid,stepno. Workid是主键.
我的桌子是这样的.
workid appid,stepno
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2
6 2 3
7 2 4
9 2 5
10 3 1
11 3 2
每个appid都有重复的stepno's.好吧,我的问题是,当我通过使用workid删除一个stepno时,stepno的其余部分应该在该appid中自动递减.
例如:如果我删除workid-5,则该appid-2中的stepno将减少,例如1,2,3,4
我想通过使用linq做到这一点.
谁能帮助我.
I have a columns workid,appid,stepno in my table "Work_Table". Workid is primary key.
my table like this.
workid appid , stepno
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2
6 2 3
7 2 4
9 2 5
10 3 1
11 3 2
Every appid has repeated stepno''s. Well my problem is ,when i delete one stepno by using workid, the rest of stepno''s should be auto decrement in that appid.
ex: if i delete workid- 5, then stepno''s in that appid-2 would decrement like 1,2,3,4
I want to do this in by using linq.
Can anyone help me.
推荐答案
delete from your table name where workid=@workid and stepno=(select max(stepno) from test where workid=@workid)
希望这会有所帮助....
Hope this helps....
这篇关于Linq +删除行时自动减少ID的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!