MySQL Producer

The MySQL producer is a persistence code generator: it translates a CodeModeler model into a database running on MySQL Server 5.1 and upper. The database is created by generating SQL scripts which are then automatically ran on the configured server.

It relies on the MySql.Data package.

As other producers, to add it, you must click on the “Add New Producer” context menu of the Producers folder node:

Application configuration

You need to configure the generated classes to use MySQL as persistence layer (“persistenceTypeName” attribute) and set a connection string indicating them where to connect to (“connectionString” attribute). Here's a sample configuration for a sample Northwind application:

<configSections>
  <section name="Northwind" type="CodeModeler.Runtime.CodeModelerConfigurationSectionHandler, CodeModeler.Runtime" />
</configSections>
<Northwind persistenceTypeName="MySQL"
           connectionString="Server=localhost;Database=Northwind;User Id=root;Password=yourpassword;"
           mysql-useSchemas="true" />

Note: mysql-useSchemas is optional and its default value is true. Its value at runtime must match the “Produce Schemas” producer attribute value which was used to generate the database.

Supported Features

The following features are supported:

• Schemas (i.e. MySQL databases) and cross-schemas relations,

• Tables,

• Constraints (primary keys and foreign keys),

• Sequences for auto-incremented columns

• Views,

• Stored procedures,

• Generating and saving instances,

• Saving Binary Large Objects (BLOB) instances in BLOB columns. Any binary large object defined in the model is stored in MySQL in fields of type BLOB.

Unsupported Features

The following features are not supported:

• Differential engine

• CMQL Search methods