我試圖寫一個Linq查詢來生成以下SQL
。SELECT
[t1].[Id], [t2].[value3] 。
FROM[/span
[Table1] AS [t1] 。
行內 JOIN
[Table2] AS [t2] ON [t1].[Id] = [t2].[value1] 。
OR [t1].[Id] = [t2].[value2]。
我看到了很多關于如何進行多重連接的例子，但沒有看到如何進行這種 "一個或另一個 "的連接。
uj5u.com熱心網友回復：
var result = from t1 in context.table1
from t2 in context.Table2
where (t1.Id == t2.value1 || t1.Id == t2.value2)
select new
{
t1.Id。
t2.value3
};
uj5u.com熱心網友回復：
INNER JOIN
var query =
from t1 in context.Table1
from t2 in context.Table2.Where(t2 => t1.Id == t2.value1 || t1.Id == t2.value2)
selectnew
{
t1.Id。
t2.value3
};
LEFT JOIN
var query =
from t1 in context.Table1
from t2 in context.Table2.Where(t2 => t1.Id == t2.value1 || t1.Id == t2.value2)
.DefaultIfEmpty()
selectnew
{
t1.Id。
t2.value3
};
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/327603.html
標籤：