TablesDataContext myDB = new TablesDataContext (); String stVar = ( from table in myDB.DBTable where table.column1 == "…." && table.column2 == "….." select table.StringColumn).Single(); int intVar = ( from table in myDB.DBTable where table.column == "..." select table.intColumn).Single().Value;
Keeping track of my brain journey!