问sql到linq查询转换

EN

Select name, count(*) from tblVehicles
WHERE MID = 23065 and name<> '' Group By name

var re = (from vehvoila in DB.tblVehicles
             where vehvoila.MID='23065' && vehvoila.name
             group vehvoila by new{vehvoila.name} into g
             select new
             {
                 g.Key.name,
                 cnt=g.Select(t=>t.name).Count()
             });