#12 Parameter problem with Npgsql when data type is not explicit

[Anonymous]

Here is the code

string queryString = "SELECT * FROM Calendar WHERE
\"YEAR\" = @date";
AdpCommand dbCommand = new AdpCommand(queryString,
Connection);
AdpParameter dbParam =
dbCommand.CreateParameter("@date", 2004);
dbParam.DbType = DbType.Int32;
dataReader = dbCommand.ExecuteReader();

if you comment the explicit assignment of data type a
Null reference exception appears. However, this is not
the case if the native Npgsql classes were used instead
of ADP.

Thanks and God Bless!