TableAdaptor's auto-generated method is returing the wrong type.

Question

I have created a table adaptor method that I would like return a int or an ?int or something useful, however, it is returning an object.

I created the method in the wizard and chose "SELECT which returns a scalar value"

The sql is:

SELECT    COUNT(*)
FROM      myTable
WHERE     (firstID= @firstID) AND (secondID= @secondID)

The auto generated method then returns an object

I have had it working in the past...