scalar function call

R

rodchar

hey all,
is it possible to call a sql server scalar function from c#?

thanks,
rodchar
 
J

Jeroen Mostert

rodchar said:
hey all,
is it possible to call a sql server scalar function from c#?
Click to expand...
Yes, but not directly. You'll have to use a statement of the form "SELECT
dbo.FunctionName(@Param1, @Param2, ...)" and you can use .ExecuteScalar() on
the command object. Be careful with the results: if it's NULL, you'll get
DBNull.Value, otherwise an object of the most appropriate type.
 

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

Operator Performance 2
calling/using a sql server scalar valued function 0
calling sql server 2005 function in access 1
Deploy CLR UDF to a different SQL Schema 4
.NET / Visual Studio: Better conditional compilation 3
Calling user-defined function from adp 1
DataContext() without using statement in inline linq-to-sql queries 0
Check for existence of server 2

Top