LINQ query in c#

Question

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)

Annad Kumar · Answer

http://www.csharpmagic.com/IQuestionAns/how-to-get-user-control-textbox-data-values-to-page-35.aspx

Harpreet · Answer

Hi Sir begin tran insert into topic SELECT distinct rank = (select max(topicid)+1 from topic)b.subjectcode null 'L01''TPSPND'1null a.topic 'Cureted Topic ' + a.topic 4getdate()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.topicb.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

Harpreet · Answer

Hi Sir begin tran insert into topic SELECT distinct rank = (select max(topicid)+1 from topic)b.subjectcode null 'L01''TPSPND'1null a.topic 'Cureted Topic ' + a.topic 4getdate()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.topicb.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

Upendra Pratap Shahi · Answer

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

Harpreet · Answer

ok i got thnxx

Jignesh Trivedi · Answer

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.

Ravi Patel · Answer

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()

Harpreet · Answer

Ok i will try this one thanku so much

Nishant Mittal · Answer

one more link regarding not in clause.. http://stackoverflow.com/questions/432954/not-in-clause-in-linq-to-entities

Nishant Mittal · Answer

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

Harpreet · Answer

plzz replyy ....