Click here to Skip to main content
15,885,435 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
i have a linq query where I try to do a groupby to obtain data distinct for a column field (RAGIONE_SOCIALE).
But when execute query, oracle gives me an error:
Oracle 11.2.0.3.0 doesn't support APPLY in linq

my linq query is:

C#
Iquerable<VEVO_CLIENTI_SITI_STRUMENTI> query = from cliente in cont.VEVO_CLIENTI_SITI_STRUMENTI orderby cliente.RAGIONE_SOCIALE select cliente;

var vRes = (from clienteDef in query

select new ClienteFiltrato
{
RAGIONE_SOCIALE = clienteDef.RAGIONE_SOCIALE,
ID_CLIENTE = clienteDef.ID_CLIENTE,
ID_SITO =clienteDef.ID_SITO,
COD_SITO =clienteDef.COD_SITO,
COD_STRUMENTO = clienteDef.COD_STUMENTO,
DATA_DA = clienteDef.DA_DATA,
DATA_A = clienteDef.A_DATA
})                    .GroupBy(y=>y.RAGIONE_SOCIALE).Select(z=>z.FirstOrDefault());
                    return vRes.ToList();


how can i use groupby without having that error?
thanks a lot
Posted
Comments
Jörgen Andersson 24-Apr-15 7:09am    
Are you having just the client installed or ODP.Net?
Linq to entities should work from 11.2.0.3.0, but you need to have the ODP.Net installed to get the support in Visual Studio
Maciej Los 16-May-15 16:47pm    
Do not repost![^]
Member 12866899 23-Nov-16 11:55am    
did you found solution? i have same issue

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900