Convert SQL query to linq to get max value

Question

SELECT Max(VarInvoiceNo) FROM  tbl_feesCollection

Possible duplicate of [Using Linq to SQL, how do I find min and max of a column in a table?](http://stackoverflow.com/questions/2268175/using-linq-to-sql-how-do-i-find-min-and-max-of-a-column-in-a-table) — Devraj Gadhavi, May 18 '16 at 07:07

René Vogt · Accepted Answer · 2016-05-18T14:24:44.557

2

Use the Max() method:

var result = db.tbl_feesCollection.Max(element => element.VarInvoiceNo);

edited May 18 '16 at 14:24

answered May 18 '16 at 06:53

René Vogt

var result = db.tbl_feesCollections.Max(element => element.VarInvoiceNo); it's worked – LEO221 May 18 '16 at 14:24
@LEO221 did not know how you called your datacontext instance, updated my answer to match your `db`. – René Vogt May 18 '16 at 14:25

1 Answers1