Comments (5)
I think I found the reason.
My Oracle data has two different accounts, but in the same space it looks like this。
So when one of the libraries has a table named “_EFMigrationsHistory”, Codefirst will not create a new “_EFMigrationsHistory“, causing this error. Do you know any solution?
from dotnet-db-samples.
These are two different issues. In your first post, you are executing a SELECT against a table that does not yet exist. The solution is to scaffold the migration, then apply the model to the DB, which will then create __EFMigrationsHistory table. You can do this by following the steps in this README.
https://github.com/oracle/dotnet-db-samples/tree/master/samples/dotnet-core/ef-core
I need more information to understand what produces your second error. What is the relationship between ORACLETESTDB and MYTEST? If they are two distinct schemas, what common access does the user have in common for these schemas?
from dotnet-db-samples.
These two users are in the same database instance, but they are different users.
I execute the following SQL statement in Mytest, and I can find "_EFMigration History" in ORACLETESTDB.
Is that the reason?
Because I deleted the “_EFMigrationsHistory“ table of ORACLETESTDB, Codefirst on MYTEST side can be successfully executed.
The relationship between ORACLETESTDB and MYTEST is shown below, in the same database instance.
from dotnet-db-samples.
In most situations, each Oracle user has its own separate schema.
I suspect what has happened is that you had created an EF Core schema already created for ORACLETESTDB. Then, you tried to create a new EF Core schema again before deleting the previously created tables, such as _EFMigration History.
Of course, the solution is what you found, which is deleting the previously created schema objects if you plan to start a new EF Core schema.
from dotnet-db-samples.
Thank you very much for your answer
from dotnet-db-samples.
Related Issues (20)
- ORA-00904: "FALSE": invalid identifier when .Any() is used in version Oracle.EntityFrameworkCore v 8.23.40 HOT 1
- Table of CustomType out parameter in store procedure HOT 10
- Unable to change NVARCHAR2 to CLOB with no warning HOT 2
- Asynchronous operation throws "A second operation was started on this context instance before a previous operation completed" HOT 2
- SqlFunctionExpression for to_char inverts the arguments in the generated sql if the function name is uppercased HOT 5
- Cursor Overflow ODP.NET not fixed with 8.21.140 HOT 2
- Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-28040: The database does not accept your client's authentication protocol; login denied. HOT 3
- Async vs Sync Performance in ASP.NET Web API: Network Call vs ODP Oracle Connection HOT 2
- Can't set port for AQ Queue listener in Oracle.ManagedDataAccess.Core v23.4.0 HOT 10
- EF Core 8.0: ORA-00932 - expected - got CLOB HOT 3
- CreateTable adds redundant rowversion trigger when column marked as concurrency token HOT 2
- Oracle.EntityFrameworkCore 8.23.40 produces invalid queries in Oracle 19c for boolean data type HOT 2
- [HELP
- [HELP] Does odp.net supports datafiles? HOT 3
- Oracle ORA-04068, ORA-04061, ORA-04065 Errors when Making Changes to Package HOT 14
- ExecuteNonQueryAsync not working properly HOT 4
- ORA-12704: character set mismatch in generated query HOT 10
- ODP.net ZHS16GBK Special characters ,error HOT 3
- Deadlock in in OracleConnectionDispenser.ProcessInstanceUp() HOT 4
- Hang occurred in OracleInternal.Network.ReaderStream.ProcessOB HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dotnet-db-samples.