Calling sql server user defined function from C#

  • Thread starter Thread starter Lalit Bhatia
  • Start date Start date
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
 
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

scalar function call 2
SQL Server 2000 and 2005 threads 1
Send struct between a C# DLL and a C# application 3
Call stored procedure with paremeter output in c# 7
Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 2
C# DLL with non .NET clients, getting ESP errors 8
Getting Started With C# 12
Calling user-defined function from adp 1

Back
Top