Comments (6)
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.
Related Issues (20)
- Type not supported yet (LazyType): sdo_geometry HOT 11
- "Cannot bind argument to parameter 'Path' because it is an empty string" when running Add-Migration HOT 9
- Include with InvalidCastException exception HOT 4
- IDbContext HOT 8
- EF6 is available for .NET Core 3+ HOT 1
- HasNoKey and Constructor with Parameters HOT 5
- Make DbMigrator constructors public HOT 4
- Link to entityframework.net HOT 3
- Count() inside string expression in Execute method HOT 4
- Creating new array inside expression string - Execute extension method HOT 8
- Error when using UpdateFromQuery on an expanded query (Linqkit) HOT 3
- HierarchyId.GetAncestor method raise an unexpected exception HOT 7
- Current Values are not reset when using SoftDelete HOT 6
- this.Configuration not availalbe in .net core 6 for soft delete HOT 3
- EDMX - Unable to cast object of type ObjectQuery to DbQuery in .Include() HOT 19
- The object cannot be deleted because it was not found in the ObjectStateManager HOT 1
- IDbCommandInterceptor called multiple times on queries with .IncludeOptimizedByPath() HOT 2
- add new provider Microsoft.Data.SqlClient HOT 4
- Unable to load the specified metadata resource. HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from entityframework-classic.