Entity Framework query custom object

Question

I am trying to query something like this:

var values = new Entities().result.SqlQuery( 
"select distinct     
i.item_type_id,     
Min(value) over (partition by i.item_type_id) as min,     
Max(value) over (partition by i.item_type_id) as max,     
Avg(value) over (partition by i.item_type_id) as avg    
from items i   
inner join packages p on p.id = i.package_id " 
WHERE ... ").ToList();

First I tried var values = new Entities().item.SqlQuery(...) but the result has nothing to do with item, item has different properties from the result of this query.

Than I created result object:

public partial class rolling_table
{
    public int item_type_id { get; set; }
    public int min { get; set; }
    public int max { get; set; }
    public int avg { get; set; }
}

and run var values = new Entities().result.SqlQuery()

But it is complaining that

The entity type result is not part of the model for the current context.

I guess it thinks result is a table in the database, however it is not.

How can I query custom type, not persistent objects ?

thanks

eladcon · Accepted Answer · 2015-02-08 14:03:44Z

1

You can use the SqlQuery method on the Database object.

var values = context.Database.SqlQuery<rolling_table>("your_query").ToList();

answered Feb 8, 2015 at 14:03

eladcon

5,8251 gold badge18 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework query custom object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related