MySQL

Designer Support

In order to drag tables and views onto the designer, you will need MySQL Connector/Net. This is a free download from the MySQL Web site. LightSpeed has not been tested with third-party Visual Studio/MySQL integration add-ins – please contact us if you encounter problems when using such add-ins.

Although MySQL Connector/Net is capable of displaying stored procedures, at the time of writing it does not support dragging stored procedures from Server Explorer. This is a limitation of MySQL Connector/Net, not of LightSpeed. You can still add stored procedures to your model using the Toolbox, or invoke them by constructing a ProcedureQuery object in code.

Creating Tables from the Designer

If you use the LightSpeed designer’s Update Database feature to create MySQL tables, these tables will use the default storage engine for the database. The default storage engine can be set at the database level using MySQL administration tools. For Linux MySQL installations, the default setting is MyISAM; it is normally recommended that you change this to the transactional InnoDB engine.

You can override the default storage engine when creating tables by adding a MySQL Roundtripping Policy to your model.  To do this, open the LightSpeed Model Explorer (View > Other Windows > LightSpeed Model), right click the model in the tree view, and choose Add New MySQL Roundtripping Policy.  You can then set the engine to be whichever engine you would prefer LightSpeed to use for new tables.