LINQ Queries

The following example performs a simple query for every MySpreadsheets record whose Column2 equals "Bob":

using System.Linq;

//...

GoogleSheetsEntities context = new GoogleSheetsEntities();
var MySpreadsheetsQuery = from MySpreadsheets in context.MySpreadsheets
                   where MySpreadsheets.Column2 == "Bob"
                   orderby MySpreadsheets.Column1
                   select MySpreadsheets;

foreach(var result in MySpreadsheetsQuery) {
  Console.WriteLine("{0} {1} ", result.Id, result.Column1);
}