Entity Framework Core - Knowledge Base (KB)
17 results in tag: migration
EntityFramework 6 Migrations for both existing and new databases?
In our software, we have a customer base with existing databases. The databases are currently accessed via EntitySpaces, but we'd like to switch to EntityFramework (v6), as EntitySpaces is no longer supported. We'd also like to make use of the migrations ...
asked by hoekki
Entity Framework Code First Migration in MySql DataBase
I create code first model using entity framework and after install first version to client we found some change in columns of database , I use migration of Entity Framework and you apply all steps of migration bat the data base of client not exist rows of...
asked by Iskandar Enuml
EF7 generates wrong migrations with SQLite
I try to use ASP.Net 5 with Entity Framework 7 and SQLite, and I found a strange behavior of migrator....I taked a Visual Studio 2015 and created a new project with template "ASP.NET 5 Template Web Application". ...After that I removed dependecy..."Entity...
asked by Blush
EF7 migration in Pluralsight course
Is anyone else having problems with the second migration in Shawn Wildermuth's Pluralsight course "Building a Web App with ASP.NET Core RC1, MVC 6, EF7 & AngularJS"?...Specifically, the command...dnx ef migrations add IdentityEntities ...causes this excep...
asked by Paul Hennessey
Create and apply migrations for all databases in Entity Framework Core
I have ...ApplicationDbContext..., which dynamically change connection string to database, which depends on user's library name. So, for each library, I have it's own database. When I'm creating migrations and apply them, they are related only to default ...
asked by Yurii N.
Run database migrations using Entity Framework core on application start
Is it possible to configure ...StartUp.cs... or ...project.json... to run database migrations using Entity Framework Core on application start?...Now I have middleware that do this task, but it seems to make negative influence on performance because datab...
asked by malonowa
EF Core 1.1 preview1: No executable found matching command "dotnet-ef"
Hi everyone I've the problem with EFCore migration in project on ASP.NET Core. Some technical info: OS: macOS...dotnet --version 1.0.0-preview2-003148...Here is my project.json:...{ "dependencies": { "Microsoft.NETCore.App": { "version": "1.0....
asked by CMaker
Error while doing Migrations EF core 2.0, changing Identity id from string to int
Scenario:...I have received auto generated project in ASP.NET CORE from my colleague. There is auto-generated code for Account/Manage service. This code includes ApplicationUser Class, DBContext and migration folder with 00000000000000_CreateIdentitySche...
asked by zolty13
Entity Framework Foreign Key For Circular Relation
I am converting an application to Entity Framework Core and am running into trouble getting a Foreign Key relationship between two of my model classes. The classes are setup like so (Note that a Guid ...Id... field is declared on ...BaseEntity...):...publ...
asked by James Hogle
How does migrationBuilder determine which indexes to create?
This is using asp.net core 2.0, EF, visual studio 2017, sql server 2016, and creating a db migration via package manager console using 'add-migration' tool within the Package Manager Console....I have a simple many-to-many relationship configured as below...
asked by codePenny
Entity Framework Code First with an existing database view
My team is starting a new project using Entity Framework Code First. We have a new, empty database for the project; the schema will be managed through Code First migrations....However, there is one piece of data that we will need to access that lives in ...
asked by Nathan Friend
may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints
Entity Framework Core...Throwing error while doing update-database...Error:-... Introducing FOREIGN KEY constraint 'FK_UserRoleRelationship_UserRoels_ParentUserRoleId' on table 'UserRoleRelationship' may cause cycles or multiple cascade paths. Specify ON...
asked by rishi kumar
How to connect to the database from host - sql server in container running under docker compose
I am running Sql Server on a container. I have set up the docker-compose and all services are able to connect to the database in order to perform design time entity framework core migrations. ...I would like to connect to the database from the host mach...
asked by Banoona
drop column in Sqlite Migration
I use ...EntityFrameworkCore.Sqlite... and I want use Migration everything works fine but when I want remove column, I am unable to update database. I know ...Sqlite... has limitation....this is my way for deal with this issue:...1.Create new Table... 2...
asked by Chapache 01
Configuring abstract base class without creating table in EF Core
I have added ...DateCreated..., ...UserCreated..., ...DateModified... and ...UserModified... fields to each entity by creating a ...BaseEntity.cs... class. My requirement is to generate single table which is having all the fields of ...base... class as co...
asked by kudlatiger
How to add migration in the multi-project solution?
I'm using ...VSCode... and I'm struggling to add my first migration in the "multi-project solution". Usually I was doing one ....csproj... per project, but recently I decided to play with the ....sln... file and I hit the wall while doing migrations. This...
asked by Ish Thomas
The property 'xxx' on entity type 'xxx' cannot be marked as nullable/optional because the type of the property is 'short' which is not a nullable type
I have an entity with ...short... data type and I want another entity to have a null-able relationship with this table. After executing Add-Migration I get the error in mentioned in Title of this question. Isn't it possible to have short as null-able prop...
asked by Hamid Noahdi
Page 1 of 1