Question Return Types for XSD Functions

[njsokalski]

I have an XSD file for all the tables in my SQL Server database. In the TableAdapters in the XSD file, some of my queries return scalar values, but the code for the functions generated by Visual Studio 2010 return an Object rather than a typed value. I know how to manually add functions using Partial classes, and even though this works, the functions that I manually create do not show up in the XSD file (so it's easy to forget that I have them) and they are not generated automatically. Shouldn't there be a way to specify what the return type should be for scalar functions? Thanks.

 

[jmcilhinney]

Are we talking about stored procedures in the database? Are these queries added during the initial wizard or in the designer at a later time?

 

[njsokalski]

I am talking about stored procedures in the database. The stored procedures may or may not have existed when the table & table adapter were added to the XSD, but the methods were added to the table adapter afterwards.