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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

True

NULL

4/20/2014 1:09:53 AM

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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

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

New Session 3rd

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

False

True

NULL

2014-04-19 23:27:31.000

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.