NO REPETATION USING linq query

Question

11 4 14 TWELTH LEGISLATIVE ASSEMBLY ??????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 NULL NULL NULL NULL NULL NULL NULL 13 5 14 TWELTH LEGISLATIVE ASSEMBLY ??????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 NULL NULL NULL NULL NULL NULL NULL 14 6 14 TWELTH LEGISLATIVE ASSEMBLY ????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 NULL NULL NULL NULL NULL NULL NULL 16 3 14 TWELTH LEGISLATIVE ASSEMBLY ??????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 True NULL 4/20/2014 1:09:53 AM NULL NULL NULL NULL 17 7 14 TWELTH LEGISLATIVE ASSEMBLY ??????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 NULL NULL NULL NULL NULL NULL NULL 18 3 14 TWELTH LEGISLATIVE ASSEMBLY ??????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 NULL NULL NULL NULL NULL NULL NULL 19 3 14 TWELTH LEGISLATIVE ASSEMBLY ??????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 NULL NULL NULL NULL NULL NULL NULL 20 7 14 TWELTH LEGISLATIVE ASSEMBLY ??????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 NULL NULL NULL NULL NULL NULL NULL 21 7 14 TWELTH LEGISLATIVE ASSEMBLY ??????? ???????? 1 New Session 01 Local Name01 2014-02-26 00:00:00.000 NULL 11:00:00 NULL 1 1 1 New Session 3rd New Session 3rd NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL False e7e83032-1cb0-41ea-bca8-ffdedd859cef 2014-02-10 17:33:11.000 e7e83032-1cb0-41ea-bca8-ffdedd859124 2014-04-19 23:27:31.000 NULL NULL NULL False True NULL 2014-04-19 23:27:31.000 NULL NULL NULL NULL NULL NULL NULL in that table the second row is LOBID row. in this row 3 is 3 time and 7 is 2 time. but my problem is based on LOBID i need to display ENTIRE ROW one time. plz help me how to display no repetation using LINQ Query

Mukesh Kumar Tiwari · Answer

var detail = (from stud in linq.Student_Masters select new { stud.name, stud.roll, stud.marks }). Distinct ();

Jignesh Trivedi · Answer

Yes distinct may help but for the distinct value you have to remove first column ( values 11 to 21).... can please share you linq query so that we can change it. also refer http://www.codeproject.com/Articles/535374/DistinctBy-in-Linq-Find-Distinct-object-by-Propert http://abundantcode.com/how-to-remove-duplicates-and-get-distinct-records-from-list-using-linq/ hope this will help you.

Ashish · Answer

Use Distinct.

NO REPETATION USING linq query

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)