Hello there,

I wanted to attempt to create an script that after calling the CliSyncWithDatabase utility, could refresh the Entity Model using reverse engineering and then just call CliGenerator to generate code consistent with changes made to the database.

The project will use LLBLGen Framework Pro(Self Service) and connects to an Oracle database using ODP. No issues here using the Designer or the CLI tools.

The problem is that I could not find a way to reverse engineer the tables to entities unless I use the Designer. I found some online references for the following classes:

• CatalogModelGraph (library: SD.Tools.Algorithmia.dll)
• ReverseEngineeringService ( library: SD.LLBLGen.Pro.ApplicationCore.dll)

...but I cannot find any examples of how to use them, the source of information I could find is the Reference Manual

I am not really sure if I am in the right path or if these libraries are meant to be used this way or how to proceed forward. Any help will be greatly appreciated

Thanks in advance

You can do that by using from the Project Settings. Please check the Database First Development section under Entity Model.

Especially these settings have to be true: https://www.llblgen.com/Documentation/5.9/Designer/Functionality%20Reference/ProjectSettings.htm#relational-model-data-synchronization

Thanks to both of you for your help. I am glad that the solution is way less complicated than I imagined.

On the same accord and considering the specific case of Oracle/ODP, how do you think we should proceed in order to link entity fields with a:

• Sequence
• TypeConverter

... without using the designer but just a PS script and/or a C# console app taking parameters?

For sequences you can specify a sequence matching pattern under Database First Development -> Reverse Engineering. If a sequence is found that's matching that pattern when reverse engineering it'll be assigned to the pk field with the same type.

For type converters, you have to define predefined type conversions for the type converter. You then also have to make sure the 'Auto assign type converter to field mapping' is checked under Entity Model -> General