EDN Admin
Well-known member
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
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