This section illustrates the database specific features for MySQL which are available to you through configuration, either through the .config file of your application or through code.
See the Application configuration through .config files
section for the details about the configuration settings defined through
See the RuntimeConfiguration system section for details about configuring the settings through code.
For MySQL, index hint specifications for elements in the
FROM clause in select queries are supported through Linq and QuerySpec.
Below is an example using a linq query, where the query is directed to use a specific index for the target of
var q = metaData.Address.WithHint("USE INDEX (idx_fk_city_id)").Count();