views:

49

answers:

0

Hi, I have a subsonic version 2.2.0.0. I have a SQL Server 2005 table "Items" with column

CategoryId uniqueidentifier null.

For this table Subsonic has generated a class with property Guid? CategoryId First I insert an record with some valid CategoryId value. Next I try to update (set to NULL) CategoryId of same record

item.CategoryId = null;
  • the intercepted SQL statement by SQL Profiler does not include directive for this column to set NULL. So the problem is - this column can't be reset to NULL if someone has previosly assigned value to such column.