Solved

How to use "and " operator in where clause using LINQ

Posted on 2009-04-01
2
431 Views
Last Modified: 2013-11-11
i need LINQ query like this

select * from tablename where col1 = value and col2 = value
0
Comment
Question by:ravindra333
  • 2
2 Comments
 
LVL 21

Accepted Solution

by:
naspinski earned 500 total points
ID: 24037154

var results = from p in DataContext.tablename where col1 == value && col2 == value select p;

Open in new window

0
 
LVL 21

Expert Comment

by:naspinski
ID: 24037376
Curious to why this didn't get an A?  I answered your exact question...
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Normally the drop down box control found in the .Net framework tools is able to select just one data and value at a time, which is displayed on the text area.   But what if you want to have multiple values to be selected in the drop down box? As …
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now