search

win7user10 / Laraue.EfCoreTriggers

Library to write triggers in C# with EF.Core
MIT License
112 stars 20 forks source link

Writing boolean constant to nullable boolean field in SqlServer trigger #86

Open lb-udes opened 1 year ago

lb-udes commented 1 year ago

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'