Hi all;
We have a commercial library that supports pulling data via ADO.NET. This includes a template designer where our U.I. assists the user in writing the selects. A select that calls a stored procedure obviously needs to support passing in the parameters, in the type expected.
We have code to get all the parameter types from the database metadata. We then type the parameters based on that metadata type info. And it all works fine for all the standard types that are strings, numbers, & dates.
But for custom types (the PostgreSQL pagilua DB has a type of mpaa_rating) and the DB specific standard types (Sql Server has the guid type), we're at a loss of what to do.
Is there a way to get an allowable standard type that can be passed in for that parameter? For example, would mpaa_rating and guid types accept a string as the parameter value? Yes it has to be an acceptable string, but that part is not our problem. Our problem is to give the user a way to pass the parameter. It's on them for the parameter value to be correct.
Or is there some other way to handle this?
thanks - dave