LINQ query in c#

Harpreet

11y1.3kVisual Basic .NET

Hi ,

I not able to write this sql query in LINQ C# . I want this query in c# linq pl zz z reply

select distinct [someclomn1] from table1 where [someclomn1] NOT IN (SELECT someclomn2 FROM table2)

11 Replies

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

Annad Kumar10y ago
http://www.csharpmagic.com/IQuestionAns/how-to-get-user-control-textbox-data-values-to-page-35.aspx
+1
Harpreet11y ago
Hi Sir, begin tran insert into topic SELECT distinct rank = (select max(topicid)+1 from topic),b.subjectcode, null, 'L01','TPSPND',1,null, a.topic, 'Cureted Topic ' + a.topic, 4,getdate(),null from Content2_temp a inner join subject b on a.subject = b.subjectname WHERE a.Topic NOT IN (SELECT TOPICNAME FROM TOPIC) group by a.topic,b.subjectcode order by rank rollback in this query i m trying to insert the data into topic table from Content2_temptable,.. if data is not their in topic table.. can u plz check it is not working ?? plzz
+1
Harpreet11y ago
Hi Sir,

begin tran

insert into topic
SELECT distinct rank = (select max(topicid)+1 from topic),b.subjectcode, null, 'L01','TPSPND',1,null, a.topic, 'Cureted Topic ' + a.topic, 4,getdate(),null from Content2_temp a inner join subject b on a.subject = b.subjectname WHERE a.Topic NOT IN (SELECT TOPICNAME FROM TOPIC) group by a.topic,b.subjectcode order by rank
rollback

in this query i m trying to insert the data into topic table from Content2_temptable,.. if data is not their in topic table.. can u plz check it is not working ?? plzz
+1
Upendra Pratap Shahi11y ago
var data1 =(from tab1 in dbc.table1 where !(from tab2 in dbc.table2 select new {tab2.someclomn2}).Contains(new { someclomn1 = ()tab1.someclomn1 }) select new { tab1.someclomn1}).Distinct()

dbc is context object
+1
Harpreet11y ago
ok i got thnxx
+1
Jignesh Trivedi11y ago
Hi,

Try
var innerquery = from en in table2
select en.someclomn2;
var query = from u in table1
where !innerquery.Contains(u.someclomn1)
select u;

hope this will help you.
+1
Ravi Patel11y ago
Hi Harpreet,

try this
db is the context object
(from m in db.table1
where
!
(from n in db.table2
select new {
n.someclomn2
}).Contains(new { someclomn1 = ()m.someclomn1 })
select new {
m.someclomn1
}).Distinct()
+1
Harpreet11y ago
Ok i will try this one thanku so much
+1
Nishant Mittal11y ago
one more link regarding not in clause..

http://stackoverflow.com/questions/432954/not-in-clause-in-linq-to-entities
+1
Nishant Mittal11y ago
Hi ,

You can use something like this... for not in clause

from p in db.Products where !X.Contains(p.Category) select p;

Ans also use below link it will explain you more

http://www.codeproject.com/Questions/370620/Filter-Using-Linq-On-datatable-with-IN-and-Not-In

Thanks
Nishant
+1
Harpreet11y ago
plzz replyy ....
+1