'Lambda expression: Second row column data is coming as NULL if first row column is null when retrieve as list

I have the example data.

Name address email
Tony Singapore
Tony [email protected]

List E = _ctx.EMP.Where(x => x.name== 'Tony').ToList();

I am getting below result when retrieve below data format from above code.

Name address email
Tony Singapore
Tony Singapore

So in my list , Email column is coming as empty in both rows. Can anyone help ? Thanks in Advance.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source