Help convert SQL into LINQ

Question

Help convert SQL into LINQ

Navigation

#1 by (0 votes)

-1

I want to convert the code select to a query LINQ

SELECT bpac.cmp FROM bpac
union
SELECT bpai.cmp FROM bpai
group by cmp
order by cmp desc

I'm trying to get the first table and I'm already getting error:

List<string> listaBpac = modelOff.bpacs.Where(p => p.ibge == oUsuario.ibge)
                                    .Select(p => new { p.cmp })
                                    .ToList();

can not implicitly convert type 'system.collections.generic.list "anonimous type: string cmp"' to 'system.collections.generic.list "anonimous type: string"'

entity-framework linq

asked by anonymous 02.10.2018 / 15:43

1 answer

Error when displaying json in Angular 6 c # how to store data from a text box from the first run

score 0 · Answer 1

Try this:

ListBpac List = modelOff.bpacs.Where (p => p.ibge == or User.ibge) .Select (p => p.cmp) .ToList ();