Entity Framework Core - Knowledge Base (KB)

Environment specific EF6 Code First Migrations using VSTS Release

I have a project that uses Entity Framework 6.x, ASP .NET WebApi 5.x. Data Access is in a secondary project inside the solution. I want to use VSTS (aka Visual Studio Online) to build and release it as a website to environments for integration/dev, qa, st...

How do I run ASP.NET Core Entity Framework migrations from Visual Studio Team Services

I've got a Web API project created using ASP.NET Core 1.1. I use Entity Framework Core Migrations. Locally, that all works well....However, I'm trying to use Visual Studio team services to automatically run the migrations when I do a release and can't fig...

How Do I Run EF Core Migrations with VSTS Deployment to Azure for Web API Project

My project was created via ...dotnet new webapi --name=ProjectName.... I've setup a build definition in VSTS. The Deployment to Azure runs fine, but I can't figure out how to run my migrations, i.e., ...dotnet ef database update...I've reviewed several of...

How to deploy a code-first Entity Framework database using Azure Devops pipelines to SQL server

We are building an ASP.net application using Entity Framework core with Azure DevOps and targeting IIS with MSSQL server 2016....Our test server is a local Windows 2016 machine containing both IIS and the SQL server instance....I have successfully written...

Azure devops ASP.Net Core EF migration production connection string null

I'm trying to build my ASP.Net Core using a build pipeline in Azure devops and get an error when running a script to script the ef migration. ...I do not have the production connection string in the appsettings.json file on purpose. The production connect...

EfCore Migrations with Azure DevOps

I want to add Build and Release pipelines in Azure Devops for my .Net Core application. Application uses EF Core migrations....I used the solution provided for example here: ...https://blog.clear-measure.com/2019/01/07/run-ef-core-migrations-in-azure-devo...

Entity Framework Core migrations through CI and CD in Azure DevOps

I have created an Entity Framework Core project and it is working fine and I am able to generate migrations through Visual Studio. ...But I want to generate SQL scripts through Azure Devops CI and deployment through CD. I am unable to do it. ...By adding ...

How to fix: In Azure Devops connection string is null despite setting Variable in the build Pipeline

I have problem with build pipeline in Azure Devops, with variables from build pipeline not replacing empty configuration in appsettings.json. Below there is more details....My current test project is build using asp.net core technology and is connected to...

How to fix: In Azure Devops build pipeline Entity Framework doesn't generate SQL script

I'm trying to prepare the azure build pipleline for a project, but the SQL script generated in Azure Devops doesn't contain any required data scheme....Little more details. Project is in Aspnet core 2.2 and use Entity Framework. When I run the commands ...

How to create Entity Framework Migration script from Azure Build Pipe Line?

I'm trying to create an Entity Framework Migration script from my Azure Build Pipe Line....I have the following two steps. The first step installs version 3.0.0 of dotnet-ef (I'm using .NET Core 3.0). The second step tries to generate the script which is ...

How to run "dotnet ef migrations script" from the last migration

In Azure DevOps I have a build task with the following command:...dotnet ef migrations script --output path/migrations-script.sql --idempotent ...In my release pipeline I run the generated script....The issue I've got is that the above command runs from t...

Could not load file or assembly 'Microsoft.Data.SqlClient

I am calling a .net standard 2.0 library from a framework 4.7.2 test project sucessfully. ...If I take my .net standard 2.0 dll (SBD.Standard) and create a new winforms project that references it then I get asked to add ...Microsoft.EntityFrameworkCore, ...