SQL Group By sorting in LINQ

An error in the previous project is that when you write a LinqTOSQL statement, first write the conditions, then sort them, and then group them. Naturally, the grouped data is sorted in order.

Actually not. You need to sort the group again.

The Code is as follows:	Copy code
Using (DBDataContext db = new DBDataContext ()){ Var matches = from t in db. tProjectOutlays Where (! String. IsNullOrEmpty (key1.Text )? T. Name. Contains (key1.Text. Trim (): true) Group t by t. CostingID into p Select new { ID = t. id, Name = t. Name, }; Gv. DataSource = matches. OrderByDescending (t => t. ID ); Gv. DataBind (); }