GetStoredProcCommand, SQL user-defined function

Topics: Data Access Application Block
May 22, 2007 at 6:01 PM
Just wondering if there are any plans to provide an equivalent of the GetStoredProcCommand method for use with SQL Server user -defined functions. Since calling a user defined function requires the SELECT keyword, the GetStoredProcCommand method doesn't work. My current workaround is to use the GetSQLStringCommand, but it would be much nicer to have something like "GetFunctionCommand", which would handle tacking on the SELECT to the front, etc.

How are others handling this problem (assuming you have the need to call user-defined functions from code)?

Thanks,
Brian Scarboro
May 23, 2007 at 1:59 PM
I haven't heard of any plans for this feature. You will probably be better off adding it yourself as the next version of EntLib will probably not be out until next year and this feature sounds a bit custom that I don't think they would do it unless there was a lot of demand.

Regards,

Dave

_______________________________

David Hayden
Microsoft MVP C#

May 27, 2007 at 6:20 AM
hi,

I do not exactly what you are looking for.

but this may help

http://www.codeproject.com/useritems/Parameter_DiscoveryV292.asp

I am still working on this, if it helps can you please let me know