LINQ: LinqDataSource How to do column Select in codebehind?

Question

<asp:LinqDataSource 
    ContextTypeName="ExampleDataContext" 
    TableName="Products" 
    Select="new(Key as ProductCategory, 
            Average(Price) as AvePrice)"
    ID="LinqDataSource1" 
    runat="server">
</asp:LinqDataSource>

Somehow my Select in .aspx file (as seen above) is not working: all columns are returned in the query result. So I will try to do that in code behind.

How do I perform the selection of the 2 fields in my LinqDataSource1_Selecting ()? Thanks.

score 1 · Answer 1 · answered Dec 04 '11 at 08:48

1

List<object> Products = (from p in ExampleDataContext.Products
                     where CONDITION
                     select p).ToList<object>();

answered Dec 04 '11 at 08:48

SPillai

177
3
7
20

score 1 · Accepted Answer · answered Dec 04 '11 at 10:16

for example:

//notice: condition is sample

int ave ;

Queryable<Object> IQ = ContextTypeName.TableName.Where(x=>x.Price <= ave);

OR

var Query = FROM objectNameSeleted IN ContextTypeName.TableName
            WHERE (your condition) SELECT objectNameSeleted

score 1 · Answer 3 · answered Dec 04 '11 at 13:27

1

You forgot the GroupBy="ProductCategory".

answered Dec 04 '11 at 13:27

Gert Arnold

105,341
31
202
291

LINQ: LinqDataSource How to do column Select in codebehind?

3 Answers3