What is the best way for retrieving single record in LINQ?
Use the First() or FirstOrDefault() command to retrieve single row records in LINQ.
BY Best Interview Question ON 22 Apr 2020
Example
var users = (from u in dc.Users where u.UserName == usn select u).FirstOrDefault();