How can we call a sql server user defined function from C#?

--
Regards,
Lalit Bhatia

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

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:%(E-Mail Removed)...
> 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