[Request, T4 template] Support for ParameterDirection.ReturnValue

[ig-sinicyn]

Current version of l2db template has no support for return parameters.
Can you add an option like

Procedures["SomeProc"].UsesReturn = true;

?

Use case: we have a legacy MS SQL db with a lot of SPs that use RETURN someValue;.

We've workarounded it with c# helper methods that wrap QueryProc() calls but having such feature will be a real time-saver:)

Environment details

linq2db version: 2.9.0
Database Server: MS SQL 2017
Database Provider: System.Data.Sql
Operating system: Windows 10
Framework version: .NET Core 3

[sdanyliv]

@MaceWindu, it looks like a bug. Please clarify. We have have to process at leas IsResult parameteter.
@ig-sinicyn, can you post sample of such procedure?

[ig-sinicyn]

@sdanyliv it's not a bug, really. As example.

CREATE PROCEDURE dbo.GetRandomNumber
AS
BEGIN
	RETURN 4 -- chosen by fair dice roll.
                 -- guaranteed to be random.
END;

SP may use output parameter(s), result set(s) or result code. It's up to developer to specify which one should be treated as return value in generated code.