scalar function call

[=?Utf-8?B?cm9kY2hhcg==?=]

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

thanks,
rodchar

[Jeroen Mostert]

rodchar wrote:

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

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.

--
J.

[Peter Duniho]

On Fri, 21 Mar 2008 12:16:01 -0700, rodchar
<ro*****@discussions.microsoft.comwrote:

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

Seems like DbCommand.ExecuteScalar() would do what you want. Right?

[=?Utf-8?B?cm9kY2hhcg==?=]

thanks all for the help,
rod.

"rodchar" wrote:

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

thanks,
rodchar