Stored Procedures missing from interfered schema

[davidmoss]

Hey Josh,

Some of my stored procedures were not showing up and I got around by adding an initial dummy call as explained here:

Using complex stored procedures with Radzen

Just passing on a workaround for those complex stored procedures that Radzen (specifically the Microsoft built in function ‘sys.dm exec describe first result set for object’) does not ‘Infer’ or allow you to add to your project. If the stored procedure is primarily for server side transaction processing and not to return dataset then a simple dummy select call will allow Radzen to ‘Infer’ the procedure and be added to your project for an ‘Invoke’. For example: ALTER PROCEDURE [dbo].[usp_GetDe…

Hope it helps,
David