For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
How can I use LISTAGG with EFCore?
I tried to follow the steps on this "https://docs.microsoft.com/en-us/ef/core/querying/user-defined-function-mapping" page but couldn't generate sql because it can't convert string[] or IEnumerable<string> to the parameter.
The most straightforward way is to use FromSqlRaw to call the SQL directly.
@alex-keh-oracle , .NET 7.0 allow us to use string.Join (C# code) on our query. Will Oracle convert string.Joing (C# code) to LISTAGG (PL/SQL code)?
I'm not sure I understand the question. The .NET String class does not have an implementation that ODP.NET can override unless you are asking about ODP.NET OracleString class.