Что нам делать, если у нас есть условие Or во INNER JOIN с EF Linq? ⇐ C#
-
Anonymous
Что нам делать, если у нас есть условие Or во INNER JOIN с EF Linq?
I the code below I have a TSql query which has Or condition in its join. If I want to convert it to Linq in C# how can I rewrite it.
SELECT P.Id AS ProductId FROM generalinv.InventoryTypeProductTypeMapping AS ITM INNER JOIN master.Product AS P ON (P.ProductCategoryId = ISNULL(ITM.ProductCategoryId, 0)) OR (P.ProductTypeId = ISNULL(ITM.ProductTypeId, 0))
Источник: https://stackoverflow.com/questions/780 ... th-ef-linq
I the code below I have a TSql query which has Or condition in its join. If I want to convert it to Linq in C# how can I rewrite it.
SELECT P.Id AS ProductId FROM generalinv.InventoryTypeProductTypeMapping AS ITM INNER JOIN master.Product AS P ON (P.ProductCategoryId = ISNULL(ITM.ProductCategoryId, 0)) OR (P.ProductTypeId = ISNULL(ITM.ProductTypeId, 0))
Источник: https://stackoverflow.com/questions/780 ... th-ef-linq
