How Do I Ignore Null Values In Linq?

Question

4.00/5 (1 vote)

See more:

i want to take first name and last as fullname using linq query, but if any value is null in last name column just take firstname at that field,how can i solve this?
i have written like this

C#

var info=(from r in spe.contacts select new 
{
fullname=r.firstname+" "+r.lastname
});
return info;

it is working fine, but when ever last name value is null it is not displaying even firstname also , please help me how to solve this????

Posted 13-Sep-14 2:40am

pavan_ kumar

Updated 13-Sep-14 2:52am

Andrius Leonavicius

v2

Add a Solution

4 solutions

Solution 2

Try this

C#

var info=(from r in spe.contacts select new 
{
fullname = (r.fristname== DBNull.Value ? "":r.fristname)+" "+(r.lastname== DBNull.Value ? "":r.lastname);
});
return info;

Posted 13-Sep-14 3:12am

ChauhanAjay

Updated 15-Sep-14 4:28am

v3

Comments

pavan_ kumar 15-Sep-14 10:20am

it is not working, it is showing the error "cannot implicitly convert dbnull to bool"

Solution 3

you can use ternary operators for this.
try this:

C#

var info=(from r in spe.contacts select new
{
fullname=r.firstname+" "+ (r.lastname != null) ? r.lastname : "";
});
return info;

Posted 14-Sep-14 1:03am

Codes DeCodes

Comments

pavan_ kumar 15-Sep-14 10:21am

working fine,thanks

Solution 4

Use the Null coalescing operator[^]:

C#

var info=(from r in spe.contacts select new
{
fullname=(r.firstname?? string.Empty) + " " + (r.lastname ?? string.Empty)
});
return info;

Posted 15-Sep-14 7:40am

Matt T Heffron

Updated 15-Sep-14 7:41am

v2

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

George Jonsson · Accepted Answer · 2014-09-13T03:08:00

Not sure exactly what you want to do.

1. If you want display the first name even if last name is null

C#

var info = (from r in spe.contacts select new
{
    fullname = r.firstname + " " + (r.lastname != null) ? r.lastname : "";
});
return info;

(You can do the same for first name.

2. If you want to ignore null names

C#

var info = (from r in spe.contacts select new
{
    if ((r.firstname != null) && (r.lastname != null))
        fullname = r.firstname + " " + r.lastname;
});
return info;

How Do I Ignore Null Values In Linq?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

How Do I Ignore Null Values In Linq?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us