Question
Dapper throws Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.' when there is no Subquery. Innerexception is also null.
My query is SELECT * FROM dbo.someTable and I use Dappers Query<T> method.
Does it look familiar to anyone ?
UPDATE: I get same error when i run query at MSSQL Server Management Studio. It's odd. I'll keep updating.
UPDATE 2: Sorry for trouble. It was a nicely concealed view.
Accepted Answer
At first I thought it was a bug of Dapper but then I realized my query target was a view. If i did this mistake someone else can too. Leaving it here.
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow