[Mono-dev] Error passing DBNull to SQLClient AddParameter method

[T Senganal]

Hi

> System.Data.SqlClient.SqlException: Disallowed implicit conversion 
> from data type sql_variant to data type varchar, table 'tablename', 
> column 'columnname'. Use the CONVERT function to run this query.

This is a bug.. fixed in svn (r61156)..

> The same thing i .NET works correctly, I'm doing something's wrong?.

well, its safer to set the datatype explicitly.. if u do not set the
datatype explicitly then
the datatype is inferred from the value assigned to the parameter and
that might not
always be the desired type..

Regards
Senga