How to invoke SQL Function through SqlCommand class

[ElCachubrey]

Hi all! How i can to invoke SQL Function through SqlCommand class, what syntax i should use in CommandText and what value i should define in CommandType THANK

[led mike]

Are you using an Article or tutorial? If not you should, there are many Database related articles here on Code Project. Use the Site Menu on the left side of the page to find them.

[andyharman]

For scalar UDFs (which return a single value) use: select dbo.MyUdfName() For table-valued UDFs (that return a resultset) use: select * from dbo.MyUdfName() Regards Andy