SqlMetal wrongly generates the return type of my stored proc (LINQ)

Question

Hi,

Hi have a stored proc that always returns a single row depending of a parameter:

IF @bleh = 1
  SELECT TOP 1 Xyz FROM Abc
ELSE
  SELECT TOP 1 Def FROM Abc

I must use SqlMetal to generate the DataContext but this stored procedure returns a IMultipleResults, which is an error. Instead it should return a ISingleResult...

If I remove the if (putting a single SELECT call), an ISingleResult return type is generated.

Any ideas?

Answer 1

These work arounds are interesting, but doesn't help for my situation.

sqlmetal wrongly generates code for my sproc as ISingleResult. I need multiple results! Check this out. SqlMetal actually generates ISingleResult for a sproc like this:

CREATE PROCEDURE GetDetailReportData AS BEGIN
select * from Log END

This is unbelievable. Does anyone ever use sprocs with sqlmetal? it appears to simply not work. Please help steer me in the direction of a work around if there is one.

Thanks, willgroove