Executing raw sql in entity framework does not return result set

Question

I am using the following query. It returns 5 rows in a list but all the elements in the list are null.

public class TempClass
{
    public int SID { get; set; }
    public string SNAME { get; set; }
    public string SAGE { get; set; }
}

var i = _dbContext.Database
                  .SqlQuery<TempClass>("select ID, NAME, AGE from eis_hierarchy")
                  .ToList();

What I am doing wrong?

p.s.w.g · Accepted Answer · 2013-11-01 05:08:59Z

2

Try making the columns returned in the SQL query match the property names in the class you're trying to return:

var i = _dbContext.Database
    .SqlQuery<TempClass>("select ID as SID, NAME as SNAME, AGE as SAGE from eis_hierarchy")
    .ToList();

answered Nov 1, 2013 at 5:08

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges

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

Collectives™ on Stack Overflow

Executing raw sql in entity framework does not return result set

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