• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

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

i need LINQ query like this

select * from tablename where col1 = value and col2 = value
0
ravindra333
Asked:
ravindra333
  • 2
1 Solution
 
naspinskiCommented:

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

Open in new window

0
 
naspinskiCommented:
Curious to why this didn't get an A?  I answered your exact question...
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now