Linq FromSqlRaw - Data is Null. - Comments Field Varchar Null

Question

User-893002196 posted

Hi All,

I got this;

var result = _context.Set<spCallResult>().FromSqlRaw("exec [dbo].[spCallVal] @XX={0}", xx).ToList();

System.Data.SqlTypes.SqlNullValueException: 'Data is Null. This method or property cannot be called on Null values.'

My Comments field is varchar(max) null

How to resolved this in FromSqlRaw?

Thanks

Regards,

Micheale