How to set Convert Zero Datetime in Entity Framework connection string

Question

I am trying to connect to MySQL database using Entity Framework 5. Everything works fine when using the connection string supplied by app.config:

<add name="MHEntities" connectionString="metadata=res://*/Models.Model.csdl|res://*/Models.Model.ssdl|res://*/Models.Model.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=server.example.com;user id=username;password=pass;persistsecurityinfo=True;database=dbname;convertzerodatetime=True;characterset=utf8&quot;" providerName="System.Data.EntityClient" />

However, I need to create the connection in code (I want to be able to supply the db password at runtime). So far I have the following code:

      SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(@"Convert Zero Datetime=true;");
        sqlBuilder.DataSource = "server.example.com";
        sqlBuilder.InitialCatalog = "dbname";
        sqlBuilder.UserID = "username";
        sqlBuilder.Password = "password";
        sqlBuilder.IntegratedSecurity = true;
      //  sqlBuilder.Add("convertzerodatetime", "true");

        string providerString = sqlBuilder.ToString();

        EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();

        entityBuilder.Metadata = @"res://*/Models.Model.csdl|res://*/Models.Model.ssdl|res://*/Models.Model.msl";
        entityBuilder.Provider = "MySql.Data.MySqlClient";
        entityBuilder.ProviderConnectionString = providerString;

        ConnString = entityBuilder.ConnectionString;

        MHEntities context = new MHEntities(ConnString);

And that works. But as soon as I uncomment the one line in the code above, I get an exception:

Keyword not supported: 'convertzerodatetime'. I tried "Convert Zero Datetime" with same results.

I need this setting (Convert Zero Datetime=true), because without it the app fails when it tries to load datetime values from the database with all zeros (I have no control over those).

SqlConnectionStringBuilder is for MS's own SqlConnection connections, not for MySQL or other providers. You'll need to look for an alternative for MySQL. — user743382
– user743382, Commented May 1, 2015 at 17:17

Mehrzad Chehraz · Accepted Answer · 2015-05-01 17:16:35Z

2

as error message says, SqlConnectionStringBuilder does not support the convertzerodatetime keyword. Consider using the MySqlConnectionStringBuilder instead.

answered May 1, 2015 at 17:16

Mehrzad Chehraz

5,1572 gold badges19 silver badges29 bronze badges

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

Comments

Miguel del Valle · Accepted Answer · 2016-05-09 10:40:21Z

0

'Convert Zero Datetime' works on EF 6, can you update your library? Try to change your web.config from 'convertzerodatetime=True' to 'Convert Zero Datetime=True'.

<add name="MHEntities" connectionString="metadata=res://*/Models.Model.csdl|res://*/Models.Model.ssdl|res://*/Models.Model.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=server.example.com;user id=username;password=pass;persistsecurityinfo=True;database=dbname;characterset=utf8;Convert Zero Datetime=True&quot;" providerName="System.Data.EntityClient" />

answered May 9, 2016 at 10:40

Miguel del Valle

93 bronze badges

Collectives™ on Stack Overflow

How to set Convert Zero Datetime in Entity Framework connection string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related