Aggregate function in linq to sql with Group by

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
hi,
I need equivalent Linq to Sql query for the query written in access database. Below is the query in access database.
SELECT Table1.ID, Table1.CODE, MIN (Table1.COST) <br/>
FROM Table1 GROUP BY Table1.ID, Table1.CODE
In this query I get COST which is minimum to the given repeated CODE
Below query is giving error "Invalid anonymous type member declarator. Anonymous type members must be declared with a member assignment, simple name or member access."
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

</font>


regards,
Bhaskar

<br/>
<br/>

<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small var<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
ptQ = <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small from<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
i <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small in<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small
(
</font>



<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small from<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
uh <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small in<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small ptTable <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small


</font>



<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small select<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small new<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small {uh.ID, uh.CODE, uh.COST})
<font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

</font>



<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small group<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
i <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small by<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small new<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
{i.ID, i.CODE } <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small into<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small g<font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small


</font>



<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small select<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small new<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small {g.Key.ID, g.Key.CODE, g.Min(uh=>uh.COST)};



View the full article
 


Write your reply...
Back
Top