Evolutility can adapt to different database structures and can map your database tables.
Its built-in ORM (Object Relational Mapper) features covers basic CRUD. It requires to create the following database objects:
Installation SQL scripts:
Some of these limitations can be overcome by creating database views (especially for LOVs).
Most of these can be worked around by creation database views for list of values tables.
Example: CREATE VIEW LOV_Category AS SELECT Category_ID AS ID, Title as Name
To let users post comments on a database table, the table must have a column "CommentCount" (of type int).
By default, comments are saved in the database table “Evol_Comment”
but another table can be specified using the attribute dbtablecomments in the XML.
Other specifications are possible with dbcommentsformid and dbcommentsuserpage.
Notes: Additional requirements for Evolutility Dictionary.
To use Evolutility with MySQL instead of Microsoft SQLServer,
you must replace some of the files in "Evolutility.zip" with in the ones in "Evolutility_MySQL.zip".
In the source code, database is specified using preprocessor directives: