Oracle Entity Framework Connection String

Question

I am using asp.net core oracle entity framework. I am writing default connection to appsettings.json

But I got

Oracle.ManagedDataAccess.Client.OracleException: 'ORA-00942: The table or schema doesnt exist.

I think I make mistake at connection string but I dont know where

my database name TEST my schema name DBTEST( all my db table inside this i must to connect to dbtest for insert ,select or update ) but I couldn't so that I got table or view doesn't exist.

 "DefaultConnection": "Data
 Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= ip
 )(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=test)(SERVER=TEST)));User
 Id=UserName;Password=*******;"

Sayan Malakshinov · Accepted Answer · 2020-07-10 09:35:47Z

1

ORA-00942: The table or schema doesnt exist.

This means that connection was successful, but you got error during parsing your query. You need to check your query.

answered Jul 10, 2020 at 9:35

Sayan Malakshinov

8,7501 gold badge21 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Roberto Hernandez · Accepted Answer · 2020-07-10 09:37:21Z

1

The error is clear, either the table is not there or your user ( the one you connect with ) has no privileges to see the table.

You need to run:

SQL> GRANT SELECT, INSERT, DELETE, UPDATE ON SCHEMA.TABLE_NAME TO USER ;

Replace schema.table_name for your schema and table, and user for TEST, in your case.

answered Jul 10, 2020 at 9:37

Roberto Hernandez

8,5833 gold badges22 silver badges51 bronze badges

Comments

Rimi · Accepted Answer · 2023-09-08 05:54:53Z

0

Use special attributes for the class that represents the table in your DbContext to determine which DB table you are refering to. Use upper case to match the Oracle table.

    [Table(name:"BANK_ORDERS", Schema ="STAGING")]
    public class Orders
    {
        [Column("ID")]
        public string Id { get; set; }

Example for table STAGING.BANK_ORDERS

answered Sep 8, 2023 at 5:54

Rimi

811 silver badge2 bronze badges

Collectives™ on Stack Overflow

Oracle Entity Framework Connection String

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related