dotConnect for MySQL Documentation
Entity Framework Provider Configuration
support@devart.com

Entity Framework support features can be configured either in code using Devart.Data.MySql.Entity.Configuration.MySqlEntityProviderConfig class or in the project .config file. The MySqlEntityProviderConfig class is available in the Devart.Data.MySql.Entity.dll assembly. For example, this code is used to enable batch updates feature:

C#csharpCopy Code
MySqlEntityProviderConfig config = MySqlEntityProviderConfig.Instance;  
config.DmlOptions.BatchUpdates.Enabled = true;  
Visual BasicCopy Code
Dim Config As MySqlEntityProviderConfig
Config = MySqlEntityProviderConfig.Instance
Config.DmlOptions.BatchUpdates.Enabled = True

To configure Entity Framework provider with a config file, you need to add the following section to the configSections tag:

<configSections>
  <section name="Devart.Data.MySql.Entity" 
  type="Devart.Data.MySql.Entity.Configuration.MySqlEntityProviderConfigurationSection, 
  Devart.Data.MySql.Entity.EF[Version], Version=8.3.215.0, Culture=neutral, 
  PublicKeyToken=09af7300eec23701" />
</configSections>  

Where [Version] is the version of the Entity Framework used. For Entity Framework v1 it is "1", for Entity Framework v4 it is "4", for Entity Framework v5 and v6 it is "5" or "6" respectively. For Entity Framework Core it is "Core".

If there is no configSections element in your config file, add it. It must be the first element. If it's not the first element, your application will throw an error when starting.

Then add the following element to the configuration tag:

 <Devart.Data.MySql.Entity xmlns="http://devart.com/schemas/Devart.Data.MySql.Entity/1.0">
 </Devart.Data.MySql.Entity>

And use the following elements of the Devart.Data.MySql.Entity tag to configure Entity Framework provider.

For more details on using MySqlEntityProviderConfig class or configuring Entity Framework provider with a config file see the following topics: