我需要使用Linq to Entity重写下面的查询。有没有人知道怎么做才是最充分的呢?UNION ALL FROM OpportunityAssignment OAINNER JOIN OpportunityByApp OBA WITH (NOLOCK) ON
OBA.OpportunityId = OA.OpportunityIdWHERE OA.
[OA_ID] FROM [Operating_Authority_Table] WHERE [OA_Name] = [@OA_Name]";
但是,当我将“@OA_Name”更改为在表中找到的简单值时command.CommandText = "SELECT [OA_ID] FROM [Operating_Authority_Table] WHERE [OA_Name] = ['OA 101']";我已经使用<