c# - The type initializer for 'System.Data.Entity.Migrations.DbMigrationsConfiguration`1' threw an exception -

-

i have asp.net mvc site.

technology stack

  • asp.net 4.6
  • c#.net
  • ef 6
  • mysql -database

while trying generate database using nuget command:-

enable-migrations -force

i getting below exception

the type initializer 'system.data.entity.migrations.dbmigrationsconfiguration`1' threw exception.

following things cross checked & tried me:-

my app.config:-

 <connectionstrings> <add name="mydbcontext" providername="mysql.data.mysqlclient" connectionstring="server=localhost;port=8080;database=mydb;uid=root;password=" /> </connectionstrings>    <entityframework> <defaultconnectionfactory type="mysql.data.entity.mysqlconnectionfactory,   mysql.data.entity.ef6" /> <providers>   <provider invariantname="mysql.data.mysqlclient" type="mysql.data.mysqlclient.mysqlproviderservices, mysql.data.entity.ef6, version=6.8.8.0, culture=neutral, publickeytoken=c5687fc88969c44d"></provider> </providers>

this configuration worked me: 

<?xml version="1.0" encoding="utf-8"?> <configuration>   <configsections>     <section name="entityframework" type="system.data.entity.internal.configfile.entityframeworksection, entityframework, version=6.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089" requirepermission="false" />   </configsections>   <startup>     <supportedruntime version="v4.0" sku=".netframework,version=v4.5.2" />   </startup>   <entityframework>     <defaultconnectionfactory type="system.data.entity.infrastructure.sqlconnectionfactory, entityframework" />     <providers>       <provider invariantname="system.data.sqlclient" type="system.data.entity.sqlserver.sqlproviderservices, entityframework.sqlserver" />       <provider invariantname="mysql.data.mysqlclient" type="mysql.data.mysqlclient.mysqlproviderservices, mysql.data.entity.ef6, version=6.8.3.0, culture=neutral, publickeytoken=c5687fc88969c44d"></provider>     </providers>   </entityframework>   <system.data>     <dbproviderfactories>       <remove invariant="mysql.data.mysqlclient" />       <add name="mysql data provider" invariant="mysql.data.mysqlclient" description=".net framework data provider mysql" type="mysql.data.mysqlclient.mysqlclientfactory, mysql.data, version=6.8.3.0, culture=neutral, publickeytoken=c5687fc88969c44d" />     </dbproviderfactories>   </system.data>   <connectionstrings>     <add name="mylocaldatabase" providername="mysql.data.mysqlclient" connectionstring="server=localhost;port=3306;database=mycontext;uid=root;password=********" />   </connectionstrings> </configuration>

i getting errors similar yours because of wrong installation of mysql connector client in development machine. installed mysql connector nuget packages within visual studio, not enough. needed install mysql client downloaded mysql website. after type errors went away.

these nuget packages: enter image description here

and the download page of mysql connector downloaded , installed manually.

note: defaultconnectionfactory value never used if specify explicitly type of provider. in case doesn't matter value have in configuration file in setting. see point 3 in this reference doc page in mysql website.

i recommend check if mysql correctly installed in machine using mysql command line client console. try connect server outside visual studio connection string values.


Comments

Post a Comment

Popular posts from this blog

jsf - "PropertyNotWritableException: Illegal Syntax for Set Operation" error when setting value in bean -

-
this question has answer here: how send form input values , invoke method in jsf bean 1 answer i error when trying send values jsf page bean. i want set values fields in bean, create airplane instance , add database. error telling me use illegal syntax setter part of bean. why error? didnt find on site helped me problem. here jsf part: <h4>add plane</h4> <c:if test="#{not empty listairplanebb.error}"> <div class="alert alert-danger"> <span class="glyphicon glyphicon-remove"></span> <h:outputtext value="#{listairplanebb.error}" /> </div> </c:if> <h:form> <table class="table"> <thead> ...
Read more

arrays - Algorithm to find ideal starting spot in a circle -

-
so problem have been debating such: your given array of integers representing circle. then, have pick spot in circle start. place start, compare value @ array number of steps took there , if steps less or equal number, include in final set. find place start have elements in set. ex, a=[0, 1, 2] if start @ index=0, then: a[0]=0 < =0 0 included a[1]=1 < =1 1 included a[2]=2 < =2 2 included final set: {0,1,2} if start @ index=1, then: a[1]=1 > 0 1 not included a[2]=2 > 1 2 not included here loop around a[0]=0 > 2 0 included final set: {0} if start @ index=2, then: a[2]=2 > 0 2 not included, here loop around a[0]=0 < = 1 0 included a[1]=1 < = 2 1 included final set: {0,1} so in trivial case, starting position index=0 best position results in final set elements. brute force method of finding obvious, trying find more efficient method. attempts far have been examine trying find max intersect of viable starting ranges calculated each element in arr...
Read more

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more