Mam napisane zapytanie w sql, które działa prawidłowo:
select top 3 a.jednostki, COUNT(0) as razem from
(select *, (jednostka1+' '+Jednostka2) as jednostki
from Tabbazas) as a
group by a.jednostki
order by razem desc
ale nie potrafię zaimplementować go do c#, coś napisałem ale nic z tego nie wychodzi
private void sort_Click(object sender, RoutedEventArgs e)
{
using (Connect context = new Connect())
{
var query =
from tabbaza in context.Tabbazas
select a.jednostki, COUNT(0) as razem from
(select (tabbaza.jednostka1+' '+tabbaza.jednostka2) as jednostki from tabbaza) as a
group by a.jednostki
order by razem desc
gridtab.ItemsSource = query.ToList();
}
}