Skip to main content

Posts

Showing posts from April, 2011

Selecting a Single value using LINQ to SQL

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;