Solved

I need help with a LINQ query in my ASP.Net application

Posted on 2011-09-14
2
205 Views
Last Modified: 2012-08-14

Hi experts
if I wanted to execute the query below using LINQ in my ASP.Net app with C# code behind, how would I do it in LINQ?  The query below is how I would execute it in SQL Server but how could I do this in LINQ?


SELECT
[School Year],
[Course Name]
FROM        
TBL_Course
where [CourseID] not in (select [CourseID] from TBL_Book where [BookID] NOT IN (14))



Thanks in advance,
mrotor
0
Comment
Question by:mainrotor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
nishant joshi earned 250 total points
ID: 36538191

[your linqtable or list] .where(!x=>x.[CourseID].exist([TBL_Book linq table].where(y=>y.bookid !=14)).select();
0
 
LVL 7

Assisted Solution

by:Kishan Zunjare
Kishan Zunjare earned 250 total points
ID: 36544616
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question