Oracle Table cannot be found via EF Core

.net-core c# entity-framework entity-framework-core

Question

I am just wondering, why i am getting data, but cannot delete it? The error is

ORA-06550: Row 4, Column 9:

PL/SQL: ORA-00942: Table or View not found

var entries = await _db.Set<T>().Where(x => x.OBJECT_ID == objectId).ToListAsync();
                _db.Set<T>().RemoveRange(entries);
                await _db.SaveChangesAsync();

Corresponding class is

[Table("PC_NS_REC_MSG_LIVE", Schema = "ENERGYDATASTORE")]
public class PC_NS_REC_MSG_LIVE : IReceivedMessage
{

}

It worked before, but suddenly this statement cannot be executed anymore.

1
1
4/2/2020 9:02:49 AM

Popular Answer

Do you still use dotnet core 2 and EF core 2 ? The oracle ef provider does only support ef core as time of writing (2nd April 2020).. https://www.nuget.org/packages/Oracle.EntityFrameworkCore/

This could be an issue... enter image description here

1
4/2/2020 9:07:15 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow