context.Database.SqlQuery not returning list of objects i declare

Question

I have some code that calls GetSQLUser(defined in the code below)... If I put a breakpoint on var result, the result is not as I expected (a SqlUserInfo object... would be nice).

public class Whatever
{
    public void GetSQLUser()
    {
        var result = this.context.Database.SqlQuery<SQLUserInfo>("SELECT SYSTEM_USER AS UserID");
    }
}

public class SQLUserInfo
{
    string UserID { get; set; }
}

What am I doing wrong?

SmartDev · Accepted Answer · 2015-08-11 13:46:22Z

1

Try changing:

var result = this.context.Database.SqlQuery<SQLUserInfo>("SELECT SYSTEM_USER AS UserID");

to

var result = this.context.Database.SqlQuery<SQLUserInfo>("SELECT SYSTEM_USER AS UserID").First();

answered Aug 11, 2015 at 13:46

SmartDev

2,8821 gold badge20 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

context.Database.SqlQuery not returning list of objects i declare

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