MegaMind MegaMind - 1 month ago 7
C# Question

Implicit convert List<int?> to List<int>

I am using Linq to Entities.

Have an entity "Order" which has a nullable column "SplOrderID".

I query my Orders list as

List<int> lst = Orders.where(u=> u.SplOrderID != null).Select(u => u.SplOrderID);


I understand it is because SplOrderID is a nullable column and thus select method returns nullable int.

I am just expecting LINQ to be little smart.

How should i handle this?

Answer

As you are selecting the property, just get the value of the nullable:

List<int> lst =
  Orders.Where(u => u.SplOrderID != null)
  .Select(u => u.SplOrderID.Value)
  .ToList();