In a C#.asp.net 2010 web form application that connects to a sql server 2008 r2 database, I would like to write a linq to sql
statement that will translate to:
Select field1 from testtable
where column1='customer' and column2 = 'statename'.
The sql would run using an existing datacontext object.
Can you should me some code that would accomplish this task?