Laraue.EfCoreTriggers icon indicating copy to clipboard operation
Laraue.EfCoreTriggers copied to clipboard

Published 20 hours ago • verified publisher icon win7user10

Writing boolean constant to nullable boolean field in SqlServer trigger

Open lb-udes opened this issue 1 year ago • 0 comments

When writing a boolean constant to a nullable boolean field, the SQL generated is CASE WHEN 0 THEN 1 ELSE 0 END which is invalid and cause an exception An expression of non-boolean type specified in a context where a condition is expected, near 'THEN'

lb-udes avatar Aug 01 '23 20:08 lb-udes