I need to convert the following sql query to linq.
I am having trouble in using left outer join in LINQ. Any help will be appreciated
select
LTRIM(RTRIM(SKU.SELLER_SKU)) AS "SKU Number",
LTRIM(RTRIM(SKU.DESCRIPTION)) as "Description",
LTRIM(RTRIM(SOURCING.SOURCING_CATEGORY)) as "Product Category",
LTRIM(RTRIM(SKU.UOM_CODE)) as "Seller UOM",
LTRIM(RTRIM(SKU.LEAD_TIME)) as "Lead Time",
CASE
WHEN CONRT.CONVERSION_RATE is null THEN
'1'
else
LTRIM(RTRIM(conrt.CONVERSION_RATE)) end as "Converstion Rate",
LTRIM(RTRIM(SKU.QTY_MEASURE)) as "Qty UOM",
LTRIM(RTRIM(SKU.START_DATE)) as "Seller Start Date",
LTRIM(RTRIM(SKU.END_DATE)) as "Seller End Date",
CASE
WHEN SKU.END_DATE >= getdate() or SKU.END_DATE is null THEN
'Published'
else
'Unpublished' end as "Web Status",
LTRIM(RTRIM(SUPP.SUPPLIER_NAME)) as "Supplier",
LTRIM(RTRIM(SUPPSKU.SUPPLIER_SKU)) as "Supplier SKU",
LTRIM(RTRIM(SUPP.BLANKET_PO)) as "Blanket Number",
LTRIM(RTRIM(SUPPSKU.UOM_CODE)) as "Supplier UOM",
LTRIM(RTRIM(SUPPCOST.UNIT_COST)) as "Supplier Unit Cost",
LTRIM(RTRIM(SUPPSKU.START_DATE)) as "Supplier Start Date",
LTRIM(RTRIM(SUPPSKU.END_DATE)) as "Supplier End Date",
LTRIM(RTRIM(SKU.MANUFACTURER_NAME)) as "Manufacturer Name",
LTRIM(RTRIM(SKU.MANUFACTURER_SKU)) as "Manufacturer Part Number"
from [dbo].[SELLER_ITEMS] as SKU
LEFT OUTER JOIN [dbo].[SUPPLIER_ITEMS] as SUPPSKU
ON SKU.ITEM_ID = SUPPSKU.SELLER_ITEM_ID
LEFT OUTER JOIN SOURCING_CATEGORY AS SOURCING
ON SKU.SOURCING_CATEGORY_ID = SOURCING.SOURCING_CATEGORY_ID
LEFT OUTER JOIN [dbo].[SUPPLIERS] as SUPP
ON SUPPSKU.SUPPLIER_ID = SUPP.SUPPLIER_ID
LEFT OUTER JOIN [dbo].[CONVERSION_RATES] AS CONRT
ON SUPPSKU.SUPPLIER_ITEM_ID = CONRT.SUPPLIER_ITEM_ID
LEFT OUTER JOIN DBO.SUPPLIER_ITEM_COSTS SUPPCOST
ON SUPPSKU.SUPPLIER_ITEM_ID = SUPPCOST.SUPPLIER_ITEM_ID
Need conversion of above query to linq...
Aucun commentaire:
Enregistrer un commentaire