How do I execute a sql server scalar-valued function from vb.net? Is it just like a stored procedure?

Ah...well I hope my previous example helps someone else then.



That is a very good question. I've never tried that before, calling a function from client code. My guess would be that you'd just use the above code, but for the CommandText use something like:







where fn_GetCustomersByCounty is your scalar SQL function. That should work.