Generating code for DB Views

Jun 25, 2012 at 6:05 PM

Howdy,

Frequently in our projects we do not have full access to our DB directly and work with views created by our DBAs.

When I fired up the mapping generator I noticed there was no way for me to tell it how to look up views and map from those. Are there any plans to include that as a feature? (and should i be logging this feature request elsewhere?)

Jun 25, 2012 at 9:16 PM

you can change download the latest build and change the code in the MysqlMetadataReader.cs file on line 130 to read something like:

select table_name from information_schema.tables where (table_type ='BASE TABLE' or table_type = 'VIEW') and TABLE_SCHEMA = '{0}',

this will treat your view as a table object and generate it.