How to return the 3 minimum scores in SQL Linq?

user_4590485 0
Viewed 27

I have a table name called Scores with column name (Total_Score) in SQL server. now my question is how to get the 3 manimum numbers using min function in Linq?.

Total_Score    Result Should be
-----------   -----------------
    23             21
    21             22
    25             23
    40         
    24         
    22
sql-server linq
1 Answers
Scores.OrderBy(c => c.Total_Score).Take(3);
user_12080340
Related