Folks,
I've been trying to put some legacy databases I have here through SqlMetal.
Most of it goes well, but in some stored procedures, I get errors for temp
tables that don't exist and so on. I don't think I can simply go and change
every single object of mine.
My question is: is there a way to have SqlMetal generate a dataset for each
stored procedure call rather than a customized result for each procedure? I
understand that SqlMetal tries to verify what the procedure does so a
personalized Result object can be generated. I would LOVE to see this
working in the same way the ExecuteDataSet method of the DAAB works. It
would solve my problems.
Any thoughts?
Regards,
Robson
I've been trying to put some legacy databases I have here through SqlMetal.
Most of it goes well, but in some stored procedures, I get errors for temp
tables that don't exist and so on. I don't think I can simply go and change
every single object of mine.
My question is: is there a way to have SqlMetal generate a dataset for each
stored procedure call rather than a customized result for each procedure? I
understand that SqlMetal tries to verify what the procedure does so a
personalized Result object can be generated. I would LOVE to see this
working in the same way the ExecuteDataSet method of the DAAB works. It
would solve my problems.
Any thoughts?
Regards,
Robson