设置DataLoadOptions时,LINQ返回错误的项数
本文关键字:错误 返回 LINQ DataLoadOptions 设置 | 更新日期: 2023-09-27 18:09:59
下面是一个代码示例:
MyDataContext context = new MyDataContext();
Symbol symbol = (from s in context.Symbols where s.ID = 3257 select s).First();
ProtocolVariable[] variables = symbol.ProtocolVariables.ToArray();
context.Dispose();
使用调试器,我看到变量的数量等于3(变量)。长度== 3)。现在我稍微改变一下代码:
MyDataContext context = new MyDataContext();
DataLoadOptions dlo = new dataLoadOptions();
dlo.LoadWith<Symbol>(s => s.ProtocolVariables);
context.LoadOptions = dlo;
Symbol symbol = (from s in context.Symbols where s.ID = 3257 select s).First();
ProtocolVariable[] variables = symbol.ProtocolVariables.ToArray();
Context.Dispose();
调试器现在显示变量的数量等于1。
这怎么可能?
这里是一些附加信息(我不知道它是否重要):
- "符号"是一个表
- 协议变量是一个视图
- "Symbols"answers"ProtocolVariables"的关联,我用*添加。dbml文件。
下面是第一个代码示例后面的SQL查询:
SELECT
[t0].[ID],
[t0].[SubsystemID],
[t0].[GenericName],
[t0].[LocalName],
[t0].[TypeID],
[t0].[Array],
[t0].[Array2],
[t0].[UnitID],
[t0].[Description],
[t0].[ProtocolID]
FROM [dbo].[Symbols] AS [t0]
WHERE [t0].[ID] = 3257
下面是第二个代码示例后面的SQL查询:
SELECT
[t0].[ID],
[t0].[SubsystemID],
[t0].[GenericName],
[t0].[LocalName],
[t0].[TypeID],
[t0].[Array],
[t0].[Array2],
[t0].[UnitID],
[t0].[Description],
[t0].[ProtocolID],
[t1].[ID] AS [ID2],
[t1].[SymbolID],
[t1].[SubsystemID] AS [SubsystemID2],
[t1].[GenericName] AS [GenericName2],
[t1].[LocalName] AS [LocalName2],
[t1].[TypeID] AS [TypeID2],
[t1].[Array] AS [Array3],
[t1].[Array2] AS [Array22],
[t1].[UnitID] AS [UnitID2],
[t1].[Description] AS [Description2],
[t1].[ProtocolID] AS [ProtocolID2],
[t1].[VariableTypeID],
(
SELECT COUNT(*)
FROM [dbo].[ProtocolVariables] AS [t2]
WHERE [t2].[SymbolID] = [t0].[ID]
) AS [value]
FROM [dbo].[Symbols] AS [t0]
LEFT OUTER JOIN [dbo].[ProtocolVariables] AS [t1] ON [t1].[SymbolID] = [t0].[ID]
WHERE [t0].[ID] = 3257
ORDER BY [t0].[ID], [t1].[ID]
我设法解决了这个问题:"ProtocolVariables"视图中的ID字段必须是唯一的。
我无法熟练地解释它。我只能描述一下,希望能帮你节省时间。- 我添加了表"符号"到*。dbml文件。
- 我在*中添加了视图"ProtocolVariables"。dbml文件。
- 我想添加符号之间的关联。ID ->协议变量。SymbolID
- 我制作了ProtocolVariable。ID主键(否则VS显示我警告)
- 我添加了关联
- 我使用NEWID函数为ProtocolVariable生成唯一的值。ID
没有最后一步(NEWID函数),我观察到我在问题中描述的行为