Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Convert thin query in linq.....

Home
Forums
LINQ

Convert thin query in linq.....

Mukesh Kumar Tiwari

Mukesh Kumar Tiwari

10yAsked Jan 7, 2016, 9:03 AM1.1kLINQ

Please help to convert to this query in linq.

select category_id,category_name from category_master where category_id not in (select manufacture_name from categorytree)..

Thanks...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Venkateshwar Reddy10y ago
List lstManufactureNames= new List();

lstManufactureNames = DBContext.categorytree.Select(x => x.manufacture_name).Distinct().ToList();

var selectedList= DBContext.category_master.Where(x => lstManufactureNames .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 R10y ago
Try this...

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