C
C#•3d ago
owlzyhoots

✅ Relation Does not Exist when running Tests

Hi, trusting y'all are well. So I am runnin into this issue where my XUnit tests using a Postgres Test Container fail with the error message 
Npgsql.PostgresException : 42P01: relation "Accidents" does not exist
Npgsql.PostgresException : 42P01: relation "Accidents" does not exist
. I have an extension method 
Apply Migrations
Apply Migrations
that should run the migrations when the container starts. I'd appreciate your aid, thanks!
No description
5 Replies
Sossenbinder
Sossenbinder•3d ago
What does the migration code look like Is it properly executing in some kind of startup hook?
owlzyhoots
owlzyhootsOP•3d ago
I have an extension method for it: 
public static class MigrationExtensions
{
    public static void ApplyMigrations(this WebApplication app)
    {
        using var scope = app.Services.CreateScope();

        var dbContext = scope.ServiceProvider.GetRequiredService<AppDbContext>();

        dbContext.Database.Migrate();
    }
}
public static class MigrationExtensions
{
    public static void ApplyMigrations(this WebApplication app)
    {
        using var scope = app.Services.CreateScope();

        var dbContext = scope.ServiceProvider.GetRequiredService<AppDbContext>();

        dbContext.Database.Migrate();
    }
}
Then added it to Program.cs 
// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
    app.ApplyMigrations();
}
// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
    app.ApplyMigrations();
}
Sossenbinder
Sossenbinder•3d ago
Did you already debug through whether that code is executed in your tests? Or are they built against Release, so they'd skip the development condition?
owlzyhoots
owlzyhootsOP•2d ago
My bad, just noticed I had forgotten to run the migration.
Sossenbinder
Sossenbinder•2d ago
I thought so 😄

Did you find this page helpful?