I have a c# application that needs to write into a postgresql table
using a stored procedure.
The stored procedure is developed and tested. It is working correctly when i tested
it manually using the select script facility in postgresql
When tried to insert from my C# application i got the error below:
System.InvalidCastException: 'Can't write CLR type System.Int32 with handler type TextHandler'
My guess is that there is probably a disconnect between the data been inserted and the
respective datatypes in the database.
I have tried to check the datatypes for the 7 parameters but cant resolve it
I attach a word file that contains the details of ALL that i have done step by step
I will be grateful to have any input that can help to resolve the issue
Olukay