The GetScalar
method returns a single scalar value as a simple type given values for the primary key columns of that table. For example, the following return the album title where the primary key of the Album table equals 1
db.Albums.Select(db.Albums.Title).GetScalar(1);