vendredi 9 octobre 2015

I need help in converting this sql query to linq

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