How do I "select null as "Column" Using LINQ in C#

Question

How do I select NULL as a column option in linq.

My sql would read.

Select field1, field2, field3, null as "null", field4 
from table1

My linq query would be:

from t in table1
select new { t.field1, t.field2, t.field3, null as "null", t.field4}

The error generated by visual studio is:

Cannot assign to anonymous type property

Oded · Accepted Answer · 2013-06-21 13:01:32Z

6

Drop the as "null" and name the parameter, casting the null to its type:

from t in table1
select new { t.field1, t.field2, t.field3, someField = (string)null, t.field4}

answered Jun 21, 2013 at 12:56

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1