I have two temp tables, storing the output results from two different sp's.Finally I union two temp table and shows the final output.
But when i called it from Entity framework, it doesn't returns the table instead it's return int. What is happening here.
If i use the data contract , then its work. I have a solution but i like to know is there any other method to fix it apart introducing the faux data contract for the result set.What is the root cause behind this.I want to fix this issue from EF and not to provide the workareound solution.
Link helped me fixed the issue :