Update database with migrations using development environment settings (appsettings.Development.json) #6704 | Support Center

piapps created 5 years ago

Hi guys,

I have added an appsettings.Development.json file to my Web.Host project for use on my local machine which works fine.

However the EntityFrameworkCore project must not use the file because whenever I do Update-Database it fails (unable to find sql instance) unless I put the correct conn string back into appsettings.json.

How or where can I adjust the connection string resolver so that .Development will be respected by migrations?

Im using v6.8.0

Regards, Pete

13 Answer(s)

0

maliming created 5 years ago
Support Team

You can try this solution: https://entityframework.net/knowledge-base/48913968/net-core-2---entity-framework--update-database-of-different-environment

Related discussion: https://github.com/aspnet/EntityFrameworkCore/issues/7353
0

piapps created 5 years ago

Neither using set or $env = seemed to work, any other ideas?
0

ismcagdas created 5 years ago
Support Team

Could you try https://github.com/aspnet/EntityFrameworkCore/issues/15026#issuecomment-472967827 ?
0

piapps created 5 years ago

Hi again,

Sorry I should have been clearer in my response yesterday.

I have tried both the following and they dont work

set ASPNETCORE_ENVIRONMENT=Development

and

$env:ASPNETCORE_ENVIRONMENT='Development'

maliming created 5 years ago

Support Team

@piapps

You can try modifying the DbContextFactory as follows:

Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT")

public class AbpZeroTemplateDbContextFactory : IDesignTimeDbContextFactory<AbpZeroTemplateDbContext>
{
	public AbpZeroTemplateDbContext CreateDbContext(string[] args)
	{
		var builder = new DbContextOptionsBuilder<AbpZeroTemplateDbContext>();
		var configuration = AppConfigurations.Get(WebContentDirectoryFinder.CalculateContentRootFolder(), Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT"), addUserSecrets: true);

		AbpZeroTemplateDbContextConfigurer.Configure(builder, configuration.GetConnectionString(AbpZeroTemplateConsts.ConnectionStringName));

		return new AbpZeroTemplateDbContext(builder.Options);
	}
}

PM> $Env:ASPNETCORE_ENVIRONMENT = "Staging"
PM> $Env:ASPNETCORE_ENVIRONMENT
Staging
PM> Update-Database
Applying migration '20170406083347_Initial_Migration'.
Applying migration '20170623075109_AspNetZero_V4_1_Changes'.
Applying migration '20170704084731_Added_GoogleAuthenticatorKey_Column'.
Applying migration '20170714081027_Added_Relation_Between_Edition_And_SubscriptionPayment'.
Applying migration '20170724142223_Upgraded_To_Abp_V2_2'.
Applying migration '20170913133916_Added_SharedMessageId_To_ChatMessage'.
Applying migration '20170914070123_Added_ReceiverReadState_To_ChatMessage'.
Applying migration '20170914084815_Invoice_Changes'.
Applying migration '20170914121022_TypeChange_SharedMessageId_String_Guid'.
Applying migration '20180118065703_Added_Entity_History'.
Applying migration '20180320065710_Upgraded_To_Abp_V3_5'.
Applying migration '20180718081610_Abp_v3_7_Changes'.
Applying migration '20180726063233_Upgraded_ABP_v3.8.0'.
Applying migration '20180731052649_Upgrade_ABP_v3.8.1'.
Applying migration '20180807062930_Upgrade_ABP_v3.8.2'.
Applying migration '20181012141151_Upgraded_To_Abp_v3_9_0'.
Applying migration '20190103081952_Recurring_Payment_Changes'.
Applying migration '20190208083524_Upgraded_To_Abp_v4_2_0'.
Applying migration '20190304131651_Added_User_OrganizationUnits'.
Done.
PM>

0

piapps created 5 years ago

That worked thanks, better yet after setting that change to the factory I have gone into properties of the EFCore project and set the environment variable in there so it remembers between Visual studio sessions (same as the host project)

Thanks again
0

murat.yuceer created 5 years ago

Thanks maliming why this code not added default template
0

maliming created 4 years ago
Support Team

I will consider adding this code to the template. : )
0

ismcagdas created 4 years ago
Support Team

This issue is closed because of no recent activity. Please open a new issue if you are still having this problem.
0

conzepta created 3 years ago

Hello

@maliming, have you considered adding this code to the template? I mean, it was 2 years since this bug was reported and 1 year since you said, that you will consider it.

Today I ran in the exact same issue and it cost me quite some time to finally find this thread. As one might imagine, it is quite annoying to spend time investigating a 2 year old bug, that already has a solution but the developers were just considering fixing it, instead of actually fixing it...

So could someone please finally add this fix to the template?

Thanks a lot

Kind regards
0

maliming created 3 years ago
Support Team

hi @conzepta

I will add some comment to IDesignTimeDbContextFactory
0

maliming created 3 years ago
Support Team

https://github.com/aspnetzero/aspnet-zero-core/pull/3764
0

conzepta created 3 years ago

Thank you very much =)

Have an answer to this question? Log in and write your answer.