DbMigrator - Problems with existing migrations about entityframework-classic HOT 6 CLOSED

Hi Jon,

thank you very much for the detailed information!

Best regards,
Andreas

from entityframework-classic.

Hello @forsti83 ,

I believe disabling the option BatchMigration in your context constructor will make the job:

public BloggingContext() : base((My.ConnectionString))
{
	this.Configuration.BatchMigration.IsEnabled = false;
}

Let me know if that fixed it.

Best Regards,

Jon

from entityframework-classic.

Hello @JonathanMagnan ,

that fixed it. Thank you very much! Has EF Classic another default value for this config setting than EF?

Best Regards,
Andreas

from entityframework-classic.

Hello Andreas,

I'm not sure to understand you question.

If you ask if there is another config that could affect the migration, I believe that's the only one

from entityframework-classic.

Hello Jon,

no, the question is, if you have a clue, why our migrations are working with EF 6.4.4 (without setting the BatchMigration config option to false), but are failing with EF Classic 7.1.34 (again without setting the BatchMigration config option to false)?

Thank you and best regards,
Andreas

from entityframework-classic.

Oh,

It fail in EF Classic since by default, we batch command.

Which means, instead of executing for example 100 SQL command to create all your tables and index, perhaps only 1-2 commands are executed.

So when batching the migration, this part will be executed way faster.

However, a custom script like your make SQL fail unless it's in a execute method.

This is similar to creating first a table:

CREATE TABLE A
(
	ColumnInt INT
)

then executing the following SQL

ALTER TABLE dbo.A
ADD ColumnInt2 INT

UPDATE A
SET ColumnInt2 = 1

even if somewhat valid, you will get the same error.

However, you found a workaround to make it works with the EXEC.

When directly in SSMS, you can also use the "GO" workaround:

ALTER TABLE dbo.A
ADD ColumnInt2 INT

GO

UPDATE A
SET ColumnInt2 = 1

GO

Let me know if that explains correctly the current behavior.

from entityframework-classic.