How to access an Oracle linked table in Linq2db?

Question

I have a linked table I access like this:

SELECT Id, Name FROM MySchema.Sectors@STATS

How do I define that in Linq2db?

I tried:

[Table(Schema = "MySchema", Name = "SECTORS@STATS")]
public partial class Sector

but when I try to load it, I get

ORA-00942: table or view does not exist

Svyatoslav Danyliv · Accepted Answer · 2021-10-05 13:18:17Z

3

You have to set Server property:

[Table(Schema = "MySchema", Name = "SECTORS", Server = "STATS")]
public partial class Sector
{
   ...
}

Also you can do that dynamically when building query:

var result = db.GetTable<Sector>().ServerName("STATS")
   .ToList();

answered Oct 5, 2021 at 13:18

28.2k4 gold badges24 silver badges46 bronze badges

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

1 Comment

Perfect, thank you!