LINQ2SQL detecting null returned null value and convert it

Question

I want to detect NULL value returned from LINQ2SQL query and convert it to something for example if :

public static String[] getAllStudents(string n)
{
var ret = from p in db.students

select p.st_fname + " " + p.st_mname +" " +p.st_lname ;

string[] st = ret.ToArray<String>();
return st;
}

if(p.st_lname== NULL ) from The database I want to cast it into something like "This is empty" so if I have in my table :

-------------------------------------------------
st_fname|| st_maname || st_lname 
-------------------------------------------------
x       || y         || NULL
-------------------------------------------------

I want to apply what I explained above on it .

Steve Morgan · Accepted Answer · 2011-07-15 18:47:41Z

1

In that case:

select (p.st_fname ?? "This is empty") + " " + (p.st_mname ?? "This is empty") + 
        " " + (p.st_lname ?? "This is empty");

Or if it's just the last name that can be null:

select p.st_fname + " " + p.st_mname + 
        " " + (p.st_lname ?? "This is empty");

The ?? operator (the null-coalescing operator) means take the value on the left-hand-side, unless it's null, in which case take the right-hand-side.

answered Jul 15, 2011 at 18:47

Steve Morgan

13.1k2 gold badges44 silver badges49 bronze badges

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

Comments

Yaroslav Bigus · Accepted Answer · 2011-07-21 11:24:07Z

1

try write something like:

var ret = from p in db.students
select string.Format("{0} {1} {2}",p.st_fname,p.st_mname, p.st_lname==null?"Undefined":p.st_lname);

edited Jul 21, 2011 at 11:24

answered Jul 15, 2011 at 19:03

Yaroslav Bigus

6787 silver badges24 bronze badges

Collectives™ on Stack Overflow

LINQ2SQL detecting null returned null value and convert it

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related