Convert thin query in linq.....

Question

Please help to convert to this query in linq. select category_idcategory_name from category_master where category_id not in (select manufacture_name from categorytree).. Thanks...

Venkateshwar Reddy · Answer

List lstM anufactureNames = new List (); lstM anufactureNames = DBContext. categorytree .Select(x => x. manufacture_name ).Distinct().ToList(); var selectedList = DBContext. category_master .Where(x => lstM anufactureNames .Contains((int)x. category_id )).Select(x => new { category_id = x. category_id  category_name = x. category_name }).ToList(); If solves hit Like... :) Happy Coding

Arul R · Answer

Try this... var q = category_master.Where( a => !categorytree.Contains( a.manufacture_name ) ) .Select( a => new { a.category_id a.category_name } );