C# 2010 linq to sql

scampercat

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?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
LINQ to SQL automatically parameterizes queries before passing them to the database so there's no need to worry about this aspect.

See, for example, this FAQ:

http://www.hookedonlinq.com/LINQToSQLFAQ.ashx

However, if you're directly executing the query using the ExecuteQuery method, then you need to follow the procedure in this MSDN link to allow for parameters:

http://msdn.microsoft.com/en-us/library/bb399403.aspx
0
Vulpes14y ago
In that case the query would return an empty IEnumerable i.e query.Count() would be zero.

There's no need to allow for this specifically in the query though you may, of course, need to deal with it in subsequent processing.
0
Nattudurai Eswaramurthy14y ago
try this below query by replacing appropriate items like table name,column, param1,2

var result = from s in context.tablename
where s.column1 == param1 && s.column2 ==param2
select s.columnname;

Hope this will help u
0
scampercat14y ago
how would you change this statement to use parameters instead of hard-coded values?
0
Vulpes14y ago
The LINQ to SQL query will be something like this:

var query = from row in context.testtable where row.column1 == "customer" && row.column2 == "statename" select row.field1;
0