![]() |
C# objects and Postgresql
Hi, this is my first post, I'm pretty new to all this stuff, infact I haven't really tried programming in 4 years so please excuse if this is easy because for me it's stupid hard .... anyway
I'm having a problem, I'm using PostgreSQL V8.3.3-1, Npgsql and Visual studio 2008 c#. I'm passed a dictionary of key, value (key been a string, value been an object). The code works fine with key and value both been strings but postgresql doesn't seem to like it when the value is an object. How can I correct my code to work when passed an object? I realise that rowsaffected is currently only storing the first value, that's fine. I just want to be able to run a query using an object datatype for now. I feel DbType.Object might be the problem. current error is: "InvalidCastException is unhandled by user code" sql is a query "SELECT username FROM users WHERE age = :Value1" Code:
public static string GetSql(string sql, Dictionary<string, object> d)Thanks |
Re: C# objects and Postgresql
For clarity, when I say both key and value are strings I mean I change the datatype to string for the value as well.
|
| All times are GMT +5.5. The time now is 19:01. |