Devart Forums

raubv0gel

dotConnect for MySQL 9.0.0.0

Any ideas to fix this problem?

raubv0gel

Thanks for advice! Changing the Model, closing it, will prompt for saving changes – works too.

I’m looking forward to see VS 2019 16.8 and EF 5 support.

Best regards!

raubv0gel

Any help on this?

I have a new project using .NET 5. I’m trying to use EF 6 and Devart dotconnect.

raubv0gel

When will EF Core 5 support will arrive?

raubv0gel

Trying

Code: Select all

CREATE TABLE access_protection_test (
	ip_address VARBINARY(16) NOT NULL,
	last_access_time TIMESTAMP NOT NULL DEFAULT (CURRENT_TIMESTAMP) ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (ip_address)
)
ENGINE = MEMORY,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;

throws error “'Specified storage engine' is not supported for default value expressions. SQL1.sql 1 1”. If one omits “DEFAULT (CURRENT_TIMESTAMP)”, it’s working. But whole SQL statement it’s working on phpmyadmin for example.

dbForge Studio 9.0.391
MySQL 8.0.21

Best regards!

raubv0gel

It turns out that Visual Studio(?) did not rebuilded all *.config. I had to clear /bin and /obj. After build the correct configs are created by Visual Studio.

raubv0gel

After upgrading (with wizard) to dotConnect for MySQL 8.17.1696 I get the following Exception if I run the application (WPF, .NET Framework 4.8):

The Entity Framework provider type 'Devart.Data.MySql.Entity.MySqlEntityProviderServices, Devart.Data.MySql.Entity.EF6, Version=8.17.1666.0, Culture=neutral, PublicKeyToken=09af7300eec23701' registered in the application config file for the ADO.NET provider with invariant name 'Devart.Data.MySql' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

App.config contians:

Code: Select all

	<entityFramework>
		<providers>
			<provider invariantName="Devart.Data.MySql"
			          type="Devart.Data.MySql.Entity.MySqlEntityProviderServices, Devart.Data.MySql.Entity.EF6, Version=8.17.1696.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
		</providers>
	</entityFramework>

References:

C:\Program Files (x86)\Common Files\Devart\dotConnect\NET2\Devart.Data.dll

C:\Program Files (x86)\Common Files\Devart\dotConnect\NET2\Devart.Data.MySql.dll

C:\Program Files (x86)\Devart\dotConnect\MySQL\Entity\EF6\Devart.Data.MySql.Entity.EF6.dll

Any idea what I’m doing wrong?

Best regards!

raubv0gel

Thank you!

raubv0gel

Thank you. That’s strange …

If I set FoundRows = true in a MySqlConnectionStringBuilder instance, I don’t get the exception. Is setting FoundRows the right way / best practice?

raubv0gel

Cool! Thank you!

raubv0gel

Okay, thank you! :-)

raubv0gel

For dbForge MySQL 2020 please add an option to disable animations. Namely the menu animations (fade-in) are annoying (at least for me).

raubv0gel

I’m unsure about the BETA. In the download section there is the note “For demo purposes only. Do not use for critical data”. But, I use it for critical/production data … I think, there should be a fix/release for the dbForge MySQL 2019 branch.

Edit: dbForge MySQL 2020 BETA works for MySQL 8.0.20.

raubv0gel

dbForge MySQL 2019 v8.2.23 ist not compatible with MySQL 8.0.20. After trying to connect, I just get the message: “This server version 8.0.20 is not currently supported.”

raubv0gel

If I set a property of an entity Album, let’s say Album.Name = "Greatest Hits", but Album.Name == "Greatest Hits" was true before, DbContext.Entry<Album>(Album).State is set to EntityState.Modified. This seems to be wrong, because there is no change.

If I call DbContext.SaveChanges() later, I get an odd DbUpdateConcurrencyException. If you catch this exception, you can compare database values and local values (see https://docs.microsoft.com/en-us/ef/ef6 ... oncurrency). But these values do not differ!

This seems to be a bug. I can try to create a minimal working example if needed.

Devart Forums

Search found 15 matches

Arithmetic operation resulted in an overflow

Re: bufferAdapter is not a VsTextDocData

bufferAdapter is not a VsTextDocData

EF Core 5 Support

Bug: DEFAULT (CURRENT_TIMESTAMP) in Table Columns with Storage Engine “MEMORY”

Re: Wrong Entity Framework provider type after upgrading to 8.17.1696?

Wrong Entity Framework provider type after upgrading to 8.17.1696?

Re: Entry state modified even if no property was modified (DbUpdateConcurrencyException)

Re: Entry state modified even if no property was modified (DbUpdateConcurrencyException)

Re: dbForge MySQL 2020 Enhancement – option to disable animations

Re: dbForge MySQL 2019 v8.2.23 not compatible with MySQL 8.0.20

dbForge MySQL 2020 Enhancement – option to disable animations

Re: dbForge MySQL 2019 v8.2.23 not compatible with MySQL 8.0.20

dbForge MySQL 2019 v8.2.23 not compatible with MySQL 8.0.20

Entry state modified even if no property was modified (DbUpdateConcurrencyException)