EF Core beta 2: How call scalar function (DbFunction) ?

Molonator69

HI.

How call a scarlar function db with EF Core2 in a package?.

1.- If I have the function "TEST_FUNCTION" in the schema "test", it´s work:

[DbFunction(FunctionName = "TEST_FUNCTION", Schema = "test")]

public static int testFunc(String val)

{

    throw new NotImplementedException();

}

But if the function is in a package "PK_NAME", don´t work, and return ORA-00904: "test"."PK_NAME.TEST_FUNCTION": invalid identifier

[DbFunction(FunctionName = "PK_NAME.TEST_FUNCTION", Schema = "test")]

public static int testFunc(String val)

{

    throw new NotImplementedException();

}

or

[DbFunction(FunctionName = "TEST_FUNCTION", Schema = "test.PK_NAME")]

public static int testFunc(String val)

{

    throw new NotImplementedException();

}

Any idea?.

I don´t find any example of this.

Molonator69

¿Nobody knows how to call a function inside a package body?

I don´t see the way to indicate the package, just function and schema

Alex Keh-Oracle

I recommend using an Oracle synonym that references the package name and function. The, use DbFunction to call the synonym.