creating query in linq from sql

See more:

SQL-Server

LINQ

SQL-Server-2008

hello


sir want to write the following query in linq but i'm having problem with linq,
so i need help

select service_name, Category,OnHand, COUNT(status) as Pending,OnHand - COUNT(status) as Inventory
from ViewForInventory
where business_id=26 and [Type]=1
group by service_name, Category,OnHand order by service_name asc

i need the same query for linq

thank you