scalar function call

  • Thread starter Thread starter rodchar
  • Start date Start date
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
DataContext() without using statement in inline linq-to-sql queries 0
.NET / Visual Studio: Better conditional compilation 3
Calling user-defined function from adp 1
Check for existence of server 2

Back
Top