Hi,
IIRC you need to include the owner of the function:
@"select dbo.userDefinedFunction(@param, @param)"
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jesse Houwing" <jesse.houwing@------.nl> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Lalit Bhatia wrote: How can we call a sql server user defined function from C#?
Create a SqlCommand and set the commandtext to
@"select userDefinedFunction(@param, @param)"
Now add these parameters to the SqlCommand aswell and you're all set.
Alternatively you could wrap the UDP in a stored procedure and call that
instead.
Jesse Houwing