How to handle null values in LINQ select statement in C#

Question

I am getting Object reference error. because of null values.

How to handle null values in LINQ Select statement

string Qtyvalues = dtQty.AsEnumerable().Select(p => p.Field<string>("KEYMATERIALS").ToString()).FirstOrDefault();

Error : object reference.

Answer 1

Try this or a variation

var Qtyvalues = dtQty
    .AsEnumerable()
    .Where(x => x["COL3"] != DBNull.Value)
    .Select(p => p.Field<string>("QTY"));