search

pradeepkumart / dapper-dot-net

Automatically exported from code.google.com/p/dapper-dot-net
Other
0 stars 0 forks source link

Mapping falls if we don't return any data from stored procedure #169

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
First of all I want to apologize for the way stored procedures were written in 
our project, but can do nothing with enormous legacy code.

What steps will reproduce the problem?
1.Create stored procedure that returns multiple record sets, but only in case 
it can find necessary data. In other words select is executed within [if .. 
begin .. end] statement. 
2. Call this miserable proc using Dapper QueryMultiple
3. Enjoy error that tells we need to specify splitOn parameter

What is the expected output? What do you see instead?
In fact, if reader has no fieldcolumns to provide it is better to return empty 
collection of elements.

What version of the product are you using? On what operating system?

Please provide any additional information below.

Original issue reported on code.google.com by CWall...@gmail.com on 20 Feb 2014 at 9:34