dotnet ef database update - any affect on existing oracle tables unrelated to the application?

user5716448

Hi,

new to .net ef core and using visual studio code

Looking at tutorial at

https://docs.microsoft.com/en-us/aspnet/core/security/authentication/identity?view=aspnetcore-2.2&tabs=netcore-cli

want to use against an existing oracle schema we have which hosts a variety of datawarehouse tables and want to make sure command below has no affect on these existing tables

dotnet ef database update

assume this command simply creates/updates tables required by the .net application in question rather than delete the entire database and recreate.

Could someone please confirm?

Also to use this against oracle table do we need to just install the ef core beta and change the appsettings.json file to below?

"ConnectionStrings": {

  "DefaultConnection": "User Id=<schema>;Password=<pwd>;Data Source=<SID>;"

  },

Thanks

Alex Keh-Oracle

Your existing tables should not be affected as you will hit an "ORA-00955: name is already used by an existing object" if you try to use DB migrations to create an object that already exists in the schema. That's a problem nonetheless as you will have to rename your class to something else or provide a different name to use. IMO, it adds unnecessary complication to your app when you can decide right from the beginning to provide a clean separation between two different apps using unrelated schemas. Besides possible naming conflicts, patching/upgrading one app's DB means upgrading both, which means testing both for the upgrade when only one DB may want the patch/upgrade.

To use Oracle EF Core, you can follow this tutorial and use the sample code:

https://github.com/oracle/dotnet-db-samples/tree/master/samples/dotnet-core/ef-core/get-started

user5716448

Thanks for update.

What about if wish to use identity as in tutorial below - will we be able to just change appsettings.json as per below

"ConnectionStrings": {

  "DefaultConnection": "User Id=<schema>;Password=<pwd>;Data Source=<SID>;"

  },

https://docs.microsoft.com/en-us/aspnet/core/security/authentication/identity?view=aspnetcore-2.2&tabs=netcore-cli

Alex Keh-Oracle

Oracle EF Core hasn't certified with ASP.NET Core Identity specifically. We'll probably take a look after our first production release.

user5716448

Thanks for update