What is the best way for retrieving single record in LINQ?

1.	What is the best way for retrieving single record in LINQ?
Answer» Use the FIRST() or FirstOrDefault() COMMAND to retrieve SINGLE row records in LINQ. Example var USERS = (from U in dc.Users where u.UserName == usn select u).FirstOrDefault();

Answer»

Use the FIRST() or FirstOrDefault() COMMAND to retrieve SINGLE row records in LINQ.

Example

var USERS = (from U in dc.Users where u.UserName == usn select u).FirstOrDefault();

Discussion