Linq创建空列.... [英] Linq creating null columns....

问题描述

我在linq查询下运行..



我是什么尝试过：

Hi,

I am running below linq query..

What I have tried:

var query1 = ((TacdisCFContext)Db).VEHICLE_CUSTOMERS_TELE
                .Where(p => object.Equals(p.VCU_VEH_ID, null));

创建以下查询。



{SELECT

NULL ASC1，

NULL ASC2，

NULL ASC3，

NULL ASC4，

NULL ASC5，

NULL AS C6，

NULL ASC7，

NULL ASC8

FROM（SELECT 1 FROM DUAL）SingleRowTable1

WHERE（1 = 0）}



任何人都可以帮助它显示空列的原因..我应该能够看到列名。 。



谢谢...

it is creating the below query.

{SELECT
NULL AS "C1",
NULL AS "C2",
NULL AS "C3",
NULL AS "C4",
NULL AS "C5",
NULL AS "C6",
NULL AS "C7",
NULL AS "C8"
FROM ( SELECT 1 FROM DUAL ) "SingleRowTable1"
WHERE (1 = 0)}

Can any one please help why it showing null columns.. I should be able to see column name..

Thanks...

推荐答案

它看起来它已经决定你的查询永远不会返回任何东西，所以它创建一个只返回空行的查询。可能是由于你的object.Equals声明。 Googlelinq select where null，您将找到正确的语法，用于选择某些内容为空的位置。

It looks like it has decided your query can never return anything so it is creating a query that simply returns an empty row. Probably due to your object.Equals statement. Google "linq select where null" and you'll find the correct syntax for selecting where something is null.

这篇关于Linq创建空列....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！