C# + MySql + Code First: Format of the initialization string does not conform to specification starting at index 0

Question

I have created a Library Project to connect with MySQL DB.

Including MySql.Data, MySql.Data.Entity.EF6 by Nuget => OK.
Installed EntityFramework by Nuget => OK
I created a MyContext.cs:

namespace Project_Core.DAL.Context
{
    [DbConfigurationType(typeof(MySqlEFConfiguration))]
    public class MyContext: DbContext
    {
        public MyContext()
            : base("myDbContext")
        {

        }

        public DbSet<Staff> Staffs { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
        }
    }
}

I edited the App.config:

<connectionStrings> <add name="myDbContext" providerName="MySql.Data.MySqlClient" connectionString="Data Source=localhost; port=3306; Initial Catalog=dbtest; uid=root; pwd=1234;" /> </connectionStrings>

I opened "Package Manager Console" and wrote:

Enable-Migrations -Force

but I got these errors:

Checking if the context targets an existing database...
System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
   at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
   at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
   at MySql.Data.MySqlClient.MySqlConnectionStringBuilder..ctor(String connStr)
   at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value)
   at MySql.Data.MySqlClient.MySqlConnection..ctor(String connectionString)
   at MySql.Data.Entity.MySqlConnectionFactory.CreateConnection(String connectionString)
   at System.Data.Entity.Internal.LazyInternalConnection.Initialize()
   at System.Data.Entity.Internal.LazyInternalConnection.get_Connection()
   at System.Data.Entity.Internal.LazyInternalContext.get_Connection()
   at System.Data.Entity.Infrastructure.DbContextInfo..ctor(Type contextType, DbProviderInfo modelProviderInfo, AppConfig config, DbConnectionInfo connectionInfo)
   at System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration, DbContext usersContext)
   at System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration)
   at System.Data.Entity.Migrations.Design.MigrationScaffolder..ctor(DbMigrationsConfiguration migrationsConfiguration)
   at System.Data.Entity.Migrations.Design.ToolingFacade.ScaffoldRunner.Run()
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)
   at System.Data.Entity.Migrations.Design.ToolingFacade.ScaffoldInitialCreate(String language, String rootNamespace)
   at System.Data.Entity.Migrations.EnableMigrationsCommand.<>c__DisplayClass2.<.ctor>b__0()
   at System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action command)
Format of the initialization string does not conform to specification starting at index 0.

Help me solve it, thank you!

Hoan Tran · Accepted Answer · 2015-06-25 08:09:32Z

9

Solved

I have tried to change base("myDbContext") to base("name=myDbContext"), but it throw the errer: "No connection string named 'myDbContext' could be found in the application config file."
I have been searching and decided copying the connectionString to base: base("server=localhost;user id=root;password=1234;persistsecurityinfo=True;database=dbtest") and it worked.

answered Jun 25, 2015 at 8:09

Hoan Tran

3854 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Reynevan Over a year ago

Well, that actually solved my issue. I don't know how; I don't know why but it did. I actually didn't call the base constructor before explicitly but it alsways worked. This time I had to, though.

willthiswork89 · Accepted Answer · 2017-06-09 20:05:25Z

1

Hey so the real fix(not the hack that you are doing here)...

It wont tell you this but the real reason the standard base("{DBConnectionName}") is failing is because of a permissions issue on the folder to access the web.config since the migrations are actually run under a different user.

I had this exact problem so what i did is goto the folder where the web.config is housed, 1) right click and goto properties 2) Goto security 3) Add User, Everyone 4)Tick Full Control 5) Goto Advanced 6) Tick the box that says Replace child object permissions with these 7) hit apply 8) rerun the Add-Migration or Enable-Migration and it will work fine.

Hope this helps someone!

answered Jun 9, 2017 at 20:05

willthiswork89

6171 gold badge4 silver badges17 bronze badges

Comments

Eugene Podskal · Accepted Answer · 2019-03-18 15:35:52Z

1

In our particular case we had DbContext in a separate project.

And despite explicitly setting the project in the Add-Migration command with

Add-Migration -Name Migration1 -Project SeparateDbContextProject

it still failed with

Format of the initialization string does not conform to specification starting at index 0.

Only when the SeparateDbContextProject has been set as a startup project the migration succeeded.

answered Mar 18, 2019 at 15:35

Eugene Podskal

10.4k5 gold badges34 silver badges56 bronze badges

Comments

nvoigt · Accepted Answer · 2015-06-25 04:48:12Z

0

Data Source=localhost; port=3306; Initial Catalog=dbtest; uid=root; pwd=1234;

This seems to be MS-SQL syntax. I don't know if MySql supports it. Try:

Server=localhost; port=3306; Database=dbtest;uid=root;pwd=1234;

answered Jun 25, 2015 at 4:48

nvoigt

77.7k28 gold badges103 silver badges156 bronze badges

1 Comment

Hoan Tran Over a year ago

Thanks, I changed to MySQL syntax but it still has those errors :(

Lulus Young · Accepted Answer · 2015-06-25 05:41:02Z

0

<connectionStrings>
    <add name="TravelMobileEntities" connectionString="metadata=res://*/ServerDatabaseModel.csdl|res://*/ServerDatabaseModel.ssdl|res://*/ServerDatabaseModel.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=localhost;user id=YS;password=snys19931103;persistsecurityinfo=True;database=travelmobile&quot;" providerName="System.Data.EntityClient"/></connectionStrings>

Hum...I have no idea where actual problem is. In my case, I'm not using "Code First" pattern. But "EF with MySQL". Above is my connection string which works perfectly good, hope this may help you. If you've solved your problem, please let me know where it is.

answered Jun 25, 2015 at 5:41

Lulus Young

431 silver badge7 bronze badges

2 Comments

Lulus Young Over a year ago

So, that means DbContext should be created with the whole connection string but cannot read from the config file, right?

Hoan Tran Over a year ago

I think so but only for MySql connection :)

phanf · Accepted Answer · 2016-02-18 06:36:08Z

This also solve my problem using Code First and MSSQL. When in developer IIS the connection worked without passing it to the base(string nameOrConnectionString) parameter but as soon as I published to IIS the code would get the following error. "Format of the initialization string does not conform to specification starting at index 0". I spent a lot of time looking and most of the other forums state the connection string causes this error which is true, but in my case it was not an error in the syntax of the connection string.

public class EntityContext : DbContext
{

    public static EntityContext EntityStatic()
    {
    var entityCnxStringBuilder = new EntityConnectionStringBuilder("");
    var sqlCnxStringBuilder = new SqlConnectionStringBuilder(entityCnxStringBuilder.ProviderConnectionString);
        sqlCnxStringBuilder.DataSource = "DataSource";
        sqlCnxStringBuilder.UserID = "User";
        sqlCnxStringBuilder.Password = "Password";
        sqlCnxStringBuilder.InitialCatalog = "DatabaseName";
        sqlCnxStringBuilder.ConnectTimeout = 10;
        sqlCnxStringBuilder.Enlist = false;
        sqlCnxStringBuilder.Pooling = false;
        sqlCnxStringBuilder.AsynchronousProcessing = true;
        sqlCnxStringBuilder.TrustServerCertificate = true;
        sqlCnxStringBuilder.Encrypt = true;
        conn = sqlCnxStringBuilder.ConnectionString;
        //For reference
        //string conn = "Data Source=localhost;Initial Catalog=;User ID=root;Password=1234;";
        return new EntityContext(conn);
    }

    public EntityContext(string conn) : base(conn)
    {    

    }
}

To use this code from your controllers

var myEntity = EntityContext.EntityStatic();

Shankar · Accepted Answer · 2016-07-19 21:16:13Z

0

Copy your DAL's ( DataAccessLayer) connectionstring (from config file) to the UI layer's config file. And comment DAL's connectionsstring in the config file.

answered Jul 19, 2016 at 21:16

Shankar

1

Collectives™ on Stack Overflow

C# + MySql + Code First: Format of the initialization string does not conform to specification starting at index 0

7 Answers 7

1 Comment

Comments

Comments

1 Comment

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

Comments

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related