EF Core - switch to SQL Server with existing MySQL migrations

EF6 and multiple configurations (SQL Server and SQL Server Compact)

EDIT: based On Error details: Did you already try tell EF where the config class is found?...[DbConfigurationType("MyNamespace.MyDbConfiguration, MyAssemblyFullyQualifiedName")] public class MyContextContext : DbContext { } ...If that cant be made work, then see alternative...Use the Context with constructor DbConnection ...public class MYDbContext...

How to use EF Core (EF7) with Mysql server?

All available providers are listed at ...https://docs.microsoft.com/en-us/ef/core/providers/.... At time of writing, there are 3 different EF Core providers, two community versions and one official version....UPDATE Sept 15, 2016...MySQL released the first version of an official provider for EF Core....https://www.nuget.org/packages/MySql.Data.Enti...

Column encryption in ASP MVC app with SQL Server 2016 using .net Core / EF Core

Always Encrypted is currently not supported on .Net Core...You can find the list of supported frameworks ...here...Adding Support for .NET core is on our roadmap, we do not have timeline for it yet...Please follow ...this github issue... for updates

EF Core migrations using asp.net core, SQL Server and Docker yields dotnet SDK error

I'm using Docker for Windows Version 1.13.0-rc5-beta35 (9606)...Windows 10 Pro...Visual Studio Code...I've created an ASP.NET Core project with Docker using the yeoman generator:...yo aspnet yo docker ...I ran into issues when I was trying to get the API to connect from a Docker container to a SQL Server instance I had running locally....To solve t...

EF Core `update-database` on MySql fails with `__EFMigrationsHistory' doesn't exist`

I Create new project in .net core 1.1 with individual user account identity. I Add MySql Provider in Startup.cs:...services.AddDbContext<ApplicationDbContext>(options => options.UseMySQL(Configuration.GetConnectionString("DefaultConnection"))); ...But when i try do ...update-database... i get error like this:...MySql.Data.MySqlClient.MySql...

Database migration with two context in Asp.Net Core (SQL Server on Docker)

I have two Context in my Application. One in ...WebApi Project -> ApiContext (inherited from IdentityDbContext)... and another one in ...Infrastructure -> Context.......I use Official images for Microsoft SQL Server on Linux for Docker Engine (...microsoft/mssql-server-linux...)....I wrote a ...DbFactory.... Below you can find my codes....ApiContex...

How to revert EF Core migration from SQL Server 2016 production machine

I have to revert the last EF Core migration from a productive instance from a SQL Server 2016 with no Visual Studio installed. How to do this?...Note: I already tried to install .NET SDK on the server but nevertheless it does not know the command ...dotnet ef.... Executing the command results in ...No executable found matching command "dotnet-ef"

Add pre-existing table to code-first migration in EF Core 2.0

I want to add a table that already exists in my SQL Server database to a ...DbContext... that I have so far only used for code-first migrations using Entity Framework Core 2.0. ...Is there a way for me to create a model class, add a ...DbSet<T>... to the ...DbContext... descendant and have it "hook-up" with the table in the database without messing...

EF Core Migration with multiple provider always runs SQL Server scripts

I am using EF Core Code first and I have an issue when using multiple DB providers (SQL Server and MySql). Even when I choose to use MySql DB provider, SQL server migration files are used....Check the sample ...project

EF Core "no migrations found" despite Migrations folder containing migration files

We have a .NET Core project set up with a Migrations folder containing several migrations that we were able to successfully run in our Development database in the past by executing ...dotnet ef database update.... However, we are now trying to apply those changes to our Staging database and it isn't working. We've set our ...ASPNETCORE_ENVIRONMENT....