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.