Linq 多項 OrderBy...

Var movies = _db.Movies.Orderby(c => c.Category).ThenBy(n => n.Name)

不同sql...原來用ThenBy

還可以
var movies = from row in _db.Movies  orderby row.Category, row.Name select row;

OptimisticConcurrencyException

C兄教的...
處理save入db時出現concurrency的問題...
記低先...
                           
try
{
    int Indict = db.SaveChanges();
}
    catch (OptimisticConcurrencyException)
{
    db.Refresh(System.Data.Objects.RefreshMode.ClientWins, add);
    db.SaveChanges();
}