icon

CodeTrigger   Forum

Code Generation For C#, WPF, WCF, SQL SERVER/ORACLE/MYSQL and Visual Studio 2013-2017

HomeFAQ

Frequently Asked Questions

Does it work with Stored Procedures Messages in this topic - RSS

migrator
03/12/2017
migrator
Administrator
Posts: 63
migrator
migrator
Administrator
Posts: 63
Yes. The default is set to use inline sql (this might change between releases, and is only available for non-oracle based projects) however the Data Source configuration page gives an option to use Stored Procedures instead. Tick that option if you want to use Stored Procedures rather than inline SQL.
There is a further option to automatically script the stored procedures/sql packages into the database. Tick that option if you want the stored procedures in the database inserted and updated when you run the code generation step in CodeTrigger. This will only work if you have the right permissions to update the database.

You can also elect (by not ticking the AutoScript option) to have the stored procedures generated into a script file (look in the datasource/script.sql or similar named file), which you can then manually script into your database.

Note that CodeTrigger does NOT work with previously written or handcrafted stored procedures. You cannot import your old/handcrafted stored procedures into the CodeTrigger project using CodeTrigger. You would have to incorporate them using hand built custom classes.
0 link