title: two conditions checking in where clause using linq 2 entites
body: <p>hi i have table called products with columns</p>
  
  <pre><code>                 product_id
                   prodcut_name
                   prodcut_price( values like 1200,2000,3000,100)
                   prodcut_desc
                   category_id(1,2,3,.....) 
  </code></pre>
  
  <p>anorther table  categories with columns</p>
  
  <pre><code>              category_id(1,2,3.......)
                category_name(a,b,c....)
  </code></pre>
  
  <p>and entity name is dbcontext...</p>
  
  <p>How can i get the products with category name   "a" and product price is  >500 and &lt;10000</p>
  
  <p>i am using linq to enitities...</p>
  
  <p>would any pls help on this..one ....</p>
  
  <p>Many thanks....</p>