I'm getting this error from my .NET code simply trying to issue the following SQL Server select statement to an Adapter and fill a dataset.

SELECT * from vwResultsCompare where UserId='123456' and SurveyID=3

It works fine in SQL EM, so the problem appears to be in the .NET environment. There are no EXPLICIT constraints on the view AFAIK - it simply joins two tables. The dataset has been cleared prior to the Fill call. I don't understand how there can be constraints on a Select statement for a view, or why .NET should object when SQL EM does not.

What am I doing wrong?