| |
| .NET DotNet Forum Index » ADO .NET Forum » Linq... |
|
Page 1 of 1 |
|
| Author |
Message |
| NUKZ... |
 Posted: Wed Jul 01, 2009 10:51 pm |
|
|
|
Guest
|
Hi,
Im wondering how to convert the following sql statement to Linq. Due to the
approach taken with the project every thing is cached so we have to use Linq
or do the bad way for foreach loops within each other, which I dont want to
use.
---------------------------
select
make.makename, model.modelname,
product.Longdescription, product.productID
FROM
Core.Product product
INNER JOIN (
Core.Model model INNER JOIN (
web.modelattribute modelattribute
INNER JOIN
web.attribute attribute ON
attribute.attributeID = modelattribute.attributeID
) ON modelattribute.modelrefcode = model.modelrefcode
) ON model.modelrefcode = product.modelrefcode
INNER JOIN
core.make make on make.makerefcode =product.makerefcode
where
attributeName in ('1.3 MP Camera','3G') AND
make.makerefcode = 13
--------------------------------
Thanks,
NS. |
|
|
| Back to top |
|
|
|
|
|
All times are GMT - 5 Hours
The time now is Sun Nov 22, 2009 5:08 am
|
|
