Improve sproc and function experience

[ErikEJ]

Is there anyway that we could see the schema name in the list of stored procedure when typing:

Entities.Procedures........ etc?

This would be a great help

@paulatmonarch FYI

[ErikEJ]

Thinking about just prefixing store procedure and function method names with schema (based on new option)

public virtual async Task<List<CustOrderHistResult>> CustOrderHistAsync(string CustomerID, OutputParameter<int> returnValue = null, CancellationToken cancellationToken = default)

public virtual async Task<List<CustOrderHistResult>> Dbo_CustOrderHistAsync(string CustomerID, OutputParameter<int> returnValue = null, CancellationToken cancellationToken = default)

[paulatmonarch]

That would be perfect

[kerwinc]

I can't tell if this is currently possible, but it would be great to be able to apply renaming conversions by defining them in the efpt.renaming.json file. Example:

{
"SchemaName": "special",
"TablePatternReplaceWith": "",
"TableRegexPattern": "^tb_",
"StoredProcedurePatternReplaceWith": "ExecuteSpecial",
"StoredProcedureRegexPattern": "^pr_",
"Tables": [
],
"UseSchemaName": false
},

As well as renaming and storing the related stored proc models in a Results directory under the schema folder.

[ErikEJ]

@kerwinc Renaming is supported, and feel free to script file movements after code generation

If you like my free tools, I would be very grateful for a rating/review on Visual Studio Marketplace and/or a one-time or monthly sponsorship