CODEWITHSUNDEEP
linq
tweety
tweety

Reputation: 31

linq condition in select statement

I have a linq query

from c in db.Custommer
join m in db.Membership on c.ID equals m.CustomerID
select (c.LastName + ", " + c.FirstName + " " + c.MiddleName);

The MiddleName could be NULL, how do I replace that null with a space or ignore it? If I leave it this way, the query does not return any records for customers who don't have middle names.

Upvotes: 0

Views: 41

Answers (1)

Shannarra
Shannarra

Reputation: 559

You can do as such:

from c in db.Custommer
join m in db.Membership on c.ID equals m.CustomerID
select (c.LastName + ", " + c.FirstName + " " + (c.MiddleName ?? "");

This should do the trick :)

Upvotes: 1

Related Questions