from: http://www.richardbushnell.net/2008/02/18/how-to-update-data-with-linq-to-sql/

From MSDN:

Q. Can I update table data without first querying the database?

A. Although LINQ to SQL does not have set-based update commands, you can use either of the following techniques to update without first querying:

Use ExecuteCommand to send SQL code. Create a new instance of the object and initialize [...]

From: http://social.msdn.microsoft.com/Forums/en/linqtosql/thread/f9c4a01a-195a-4f2b-a1cb-e2fa06e28b25

Error message:

“System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException was unhandled by user code   Message=”Operation is not valid due to the current state of the object.”

Reason:

LINQ to SQL objects have both association properties (references or lists of other objects) and the key fields that are used to define these associations in the database. [...]

from http://webcache.googleusercontent.com/search?q=cache:_VR7s2_orq8J:stackoverflow.com/questions/755132/how-do-i-order-a-group-result-in-linq+linq+grouping+order&cd=1&hl=en&ct=clnk&gl=au

Just add the orderby clause ;-)

Here’s how:

from a in Audits join u in Users on a.UserId equals u.UserId group a by a.UserId into g let score = g.Sum(x => x.Score) orderby score descending select new { UserId = g.Key, Score = score };