Skip to content

Instantly share code, notes, and snippets.

@dieseltravis
Created December 3, 2009 17:34
Show Gist options
  • Select an option

  • Save dieseltravis/248358 to your computer and use it in GitHub Desktop.

Select an option

Save dieseltravis/248358 to your computer and use it in GitHub Desktop.
re-ordering items with linq
private void ReorderItem(Guid itemToMoveID, int newOrder)
{
var db = new SomeDataContext();
var selectedItems = (from b in db.SomeItems
where b.CategoryId == Category.SelectedCategoryID
orderby b.OrderBy ascending
select b).ToList();
SomeItem itemToMove = selectedItems.Find(b => b.ID == itemToMoveID);
selectedItems.Remove(itemToMove );
selectedItems.Insert(newOrder, itemToMove );
int newItemOrder = 0;
foreach (var e in selectedItems)
{
e.OrderBy = newItemOrder ++;
e.DateModified = DateTime.Now;
}
db.SubmitChanges();
someGrid.Rebind();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment