Return true to generate a 'Insert' method for the table.Ī callback function to be run for each table that is not omitted by tableFilter. Return true if the user-defined table type must be included.Ī callback function to be run for each table that is not omitted by tableFilter. Return true if the table must be included (meaning: CRUD methods will be generated).Ī callback function to be run for each user-defined table type. Return true if the stored-procedure must be included.Ī callback function to be run for each table. (schema: string, name: string) => booleanĪ callback function to be run for each stored-procedure. You can combine this option with any of the 'filter' options. Indicates what type of objects to include (refer to the list of object types below). ConnectionPool ( connectionString ) const builder = new ReverseDbBuilder ( pool, options ) Option If you haven't yet, run the following command:Ĭonst options: ReverseSqlOptions = const pool = new sql. There is no easy, future-proof way to retrieve meta data about more result sets.įirst, you need to have the Yellicode CLI installed globally. This isĪctually a limitation in SQL Server because this package uses sp_describe_first_result_set internally.
CRUD STORED PROCEDURE GENERATOR SQL SERVER CODE
First result set only: when a stored procedure has more than 1 result set, you will notice that code is only generated for the first one.This is not a ORM: it doesn't provide the advanced mapping, querying and caching methods that a ORM provides.Customizable: customize which database objects to include, control class- and method names and split your code over multiple files.Generates Select.Where(expression) methods for basic filtering of table data.Generates basic CRUD operations for tables.Generates entities for User-Defined Table Types: use strongly-typed entities instead of DataTables when stored procedures expect a user-defined table type as parameter.Supports Stored Procedures: generates stored procedure calls and entities for corresponding result sets.The code only depends on a few namespaces, namely (which is part of NET Standard) and, if you need strongly-typed support for table types,. Generated code is cross-platform: the code will work in.This generator is built as an extension to Yellicode, a cross-platform code generator based on TypeScript and Node.js. Engineers an existing SQL-Server database and generates C# entities, CRUD actions and stored procedure calls.