Assigning NULL value to column with AsUpdate throws NotSupportedException
SeanLawless opened this issue · 1 comments
SeanLawless commented
Hi All,
When using the SqlKata query builder and assigning a column value as NULL it throws a NotSupportedException.
I have tried using (DbValue)null, DBNull.Value and null.
It will update with just "null" but it updates the column as a string containing "null" and not as the default NULL you would expect in SQL Server. How should this be handled?
SeanLawless commented
Expressions.UnsafeLiteral("null")