Calling sql server user defined function from C#

J

Jesse Houwing

Lalit said:
How can we call a sql server user defined function from C#?
Click to expand...

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
 
I

Ignacio Machin \( .NET/ C# MVP \)

Hi,

IIRC you need to include the owner of the function:

@"select dbo.userDefinedFunction(@param, @param)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access ConcatRelated() Function Not Working 0
Calling user-defined function from adp 1
scalar function call 2
C#/Mono namespaces 3
Handle table of user-defined type, passed from Oracle, in C# 1
Calling C# DLL function from COBOL 3
Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 2
Send struct between a C# DLL and a C# application 3

Top