How to call a SQL function in SQL server from C#?

[Andy Li]

I know how to call a stored procedure in SQL server from C# using SQLCommand
class. Could someone tell me how to call a SQL function in SQL sever from
C#?

Thanks,

Andy

 

[Nicholas Paldino [.NET/C# MVP]]

Andy,

You can call a function just like a stored procedure. However, I
believe that for the name, you can not use just the function name, but
rather, you have to use the function name prefixed by the database name.

Hope this helps.

 

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

Hi Nicholas,

At least from the Query Analizer you need to prefixe the function with the
owner of it.
I have never called a function from a .NET app. but I would try it like
this if not work then prefixed completly beggining with the DB name like:
dbname.dbo.functionName


Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

Andy,

You can call a function just like a stored procedure. However, I
believe that for the name, you can not use just the function name, but
rather, you have to use the function name prefixed by the database name.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I know how to call a stored procedure in SQL server from C# using SQLCommand
class. Could someone tell me how to call a SQL function in SQL sever from
C#?

Thanks,

Andy