sqlkata/querybuilder

Assigning NULL value to column with AsUpdate throws NotSupportedException

SeanLawless opened this issue · 1 comments

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?

Expressions.UnsafeLiteral("null")