Entitty framework show the item more than one

Question

1.00/5 (1 vote)

See more:

Hello,

I try to use this code however it show me the item more than one

how can i fix this?

C#

var element = (from h in ent.REPORTHEADERs
                           join d in ent.REPORTDETAILS on h.FIS_NO equals d.FIS_NO
                           select new
                           {
                               h.SUBE_ID,
                               h.FIS_NO,
                               h.TERAZI_NO,
                               h.TERAZI_REYON_NO,
                               d.URUN_NO,
                               d.BIRIM_FIYAT,
                               h.SATICI_NO,
                               h.MUSTERI_NO,
                               h.FIS_ADET,
                               h.FIS_AGIRLIK,
                               h.TUTAR,
                               h.IPTAL,
                               h.ILK_ISLEM_TARIHI,
                               h.SON_ISLEM_TARIHI,
                               h.FIS_SAYISI,
                               h.TERAZI_ADIIP
                           }).ToList();

What I have tried:

I tried to comment the join part and its work perfect however i add the join part i get same item 3 times

Posted 2-Jul-17 21:49pm

Member 10525430

Updated 2-Jul-17 21:54pm

Add a Solution

Comments

Ehsan Sajjad 3-Jul-17 4:07am

it is because you probably have one to many relationship with details table from main table.

Member 10525430 3-Jul-17 4:11am

how can i fix?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prifti Constantine · Answer 1 · 2017-07-02T21:54:00

Solution 1

You could try:

C#

.ToList().FirstOrDefault();

at the end of the ToList() method in order to get the first element that satisfies the statement if youre looking for a single value to come back.

Posted 2-Jul-17 21:54pm

Prifti Constantine

Comments

Member 10525430 3-Jul-17 4:03am

but its the datasource of gridview and when i erite firstordefault i get only one item but i have 3 item.

Prifti Constantine 3-Jul-17 4:17am

So the problem is not that it gives more than one item, but that it shows one item more than once?

Member 10525430 3-Jul-17 4:19am

actually,

my db have 3 item

however when i use this entity code i get 9 item on gridview

Prifti Constantine 3-Jul-17 4:28am

You could iterate the List with a ForEach loop and for reach item that you want to get, you could use the .Distinct(); at the end so it will select A single value per item since you have 3 per item right now.
A way to implement this is :
ForEach var item in ent.REPORTHEADERs
{
var element = (from h in ent.REPORTHEADERs
join d in ent.REPORTDETAILS on h.FIS_NO equals d.FIS_NO
select new
{
h.SUBE_ID,
h.FIS_NO,
h.TERAZI_NO,
h.TERAZI_REYON_NO,
d.URUN_NO,
d.BIRIM_FIYAT,
h.SATICI_NO,
h.MUSTERI_NO,
h.FIS_ADET,
h.FIS_AGIRLIK,
h.TUTAR,
h.IPTAL,
h.ILK_ISLEM_TARIHI,
h.SON_ISLEM_TARIHI,
h.FIS_SAYISI,
h.TERAZI_ADIIP
}).Distinct.ToList();
}

Member 10525430 3-Jul-17 4:36am

its not working correctly
when i use your code i get only 2 same item
the other 2 different item not come

Prifti Constantine 3-Jul-17 4:59am

Do you have anymore code that i could see? Or this is just the part that generates the error?

Member 10525430 3-Jul-17 6:29am

all the metod is:

public DataTable selectGrup()
{
DataTable dt = new DataTable();

var element = (from h in ent.REPORTHEADERs
join d in ent.REPORTDETAILS on h.FIS_NO equals d.FIS_NO
select new
{
h.SUBE_ID,
h.FIS_NO,
h.TERAZI_NO,
h.TERAZI_REYON_NO,
d.URUN_NO,
d.BIRIM_FIYAT,
h.SATICI_NO,
h.MUSTERI_NO,
h.FIS_ADET,
h.FIS_AGIRLIK,
h.TUTAR,
h.IPTAL,
h.ILK_ISLEM_TARIHI,
h.SON_ISLEM_TARIHI,
h.FIS_SAYISI,
h.TERAZI_ADIIP
}).Distinct().ToList();

dt = ToDataTable(element);

return dt;
}
my db have 3 item on report details,3 item on report header

when i run the program i get 2 same item for your code