nullable types when querying the db

[Okku Touronen]

I have a hard time with the new nullable types in .Net 2.0 when querying the db. (Yes I know IBatis is designed for 1.1)   I have got most things to work by using custom type handlers. To use the custom typehandlers I have to write a parameterMap and use the typeHandler attribute.   But sometimes I don’t want to mess with parameter maps, for instance when I have dynamic sql.   For example if I have a nullable int (System.Nullable<Int32>) property in a parameterClass object,  I would like some way to tell the parameter object (System.Data.SqlClient.SqlParameter) that the “type=int” and “IsNullable=true”.   Is there a way? Or is this something I have to implement myself? Where should I start then?   Regards Okku Touronen