I’m trying to change the sortorder in a database table looking like this :
id parentid sitename sortorder
1 0 home 0
2 0 about 1
3 0 product 2
4 0 contact 3
Now when i drag “home” down between “product” and “contact” using jstree, I need to change the sortorder of all 4 sites. The thing i know when I drop the “home” site is the id, parentid and the new sortorder-index, but how would my update linq sql look like to get this to work?