Feature: Stored Procedure

[VinayShiva]

This could be an enhancement or a feature,

Scripting from Yml file was awesome. and thank you for giving us a clean way to script back form database. how do we include the stored procedures in the database?

generating code to call the sp's also would be great.

Thank you.
V

[pwelter34]

I'm not sure if there is a clean way to know which stored procedure goes with which entity? If you have a good design, we could see if it could be done.

[BartBr]

Seems like a great idea to me,
Entity Framework 6.3 generates a class for each result of a stored procedure.
result model naming: {StoredProcedure}.Name_Result

Generated code to execute those stored procedures would make it awesome.
with all params as method parameters. (this could also be encapsulated in a request object)

[MichaelDenwood]

This is a great idea, and to be honest I was disappointed it wasn't already here. However the Code Generation from this product is excellent and is why I use it. You can check out https://github.com/ErikEJ/EFCorePowerTools/wiki for possible tips at how to achieve this. I don't know enough about either product to know if it will be helpful.