Select only few columns in LINQ query

I have the following query

 var xyz = from a in prod.Categories
                           where a.CatName.EndsWith("A")
                           select a;

However all the columns are returned in this case. How do i rewrite query so that only few column开发者_StackOverflows are returned like a.CatName, a.CatID, a.CatQty and so on.

var xyz = from a in prod.Categories
                           where a.CatName.EndsWith("A")
                           select new { CatName=a.CatName, CatID=a.CatID, CatQty = a.CatQty};

 var xyz = from a in prod.Categories
                           where a.CatName.EndsWith("A")
                           select new { a.CatID,a.CatQty } ;