>

>insertCommand.Parameters.Add("@accessPassNo", SqlDbType.Decimal, 17).Value = (this.passTable == PassTable.Access) ? passNo : null;
>

>
>it may have to be DbNull
>
>
>>Can you show what do you mean? I can not use inline IIF but I believe with that new code it should work. I'm going to test my new code in a few minutes.

No, without (Int64?) the top line doesn't compile.

If you check the link I found

http://stackoverflow.com/questions/4555935/how-to-assign-null-to-a-sqlparameter

it explains that the problem is with inline IIF that expects both parts of expression to be the same type.

BTW, I tested my new code and it worked fine.