[gentle] Null condition in Select query

[<Dra...@ck...>]

Hi,

I have following situation:
 - string field in table that has null values because data were entered 
with legacy application, those nulls cannot be easily filled
 - new application that adds data to that table have Gentle attribute set 
to NotNull, and now users cannot set null in that field
 - try to execute Select statement that looks for those objects that have 
null in that string field - Gentle throws exception

Gentle does not allow null value for parameter in Select statement, if 
field is defined as NotNull.
We traced problem down to SqlStatement.cs, method GetParameterValue, line 
222:

if( val == null && ! fm.IsValueType && ! ( fm.IsPrimaryKey && 
fm.IsAutoGenerated ) )
     Check.Verify( fm.IsNullable, Error.NullProperty, fm.MemberName, 
map.Type );

I think that it can be allowed to have null query if statement type is 
Select (we tested this on our apps), so line 222 can be modified like this:

if( val == null && ! fm.IsValueType && ! ( fm.IsPrimaryKey && 
fm.IsAutoGenerated )  &&  stmtType != StatementType.Select)


What do you think?


Drazen