Simple.Data

Simple.Data defines a number of commands for retrieving data from a data store. These can then be daisychained in a LINQ-like fashion with further methods to modify the basic query.

GetScalar

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);