Entity Framework raw sql query not setting values

Question

I have a simple query that I'm trying to execute:

sql = "SELECT DailyGamingID, GamingDate, LocationID FROM tblDailyGaming WHERE GamingDate >= '1/1/23' AND LocationID = 1";
List<TestData> testList = context.Database.SqlQuery<TestData> (sql).ToList ();

The query returns 10 rows.

I also have the following class:

public class TestData
{
    public int DailyGamingID;
    public DateTime GamingDate;
    public int LocationID;
}

testList will have the correct number of elements (10) in the list but none of the values of TestData have been set. They are all default values. Help please!

marc_s · Accepted Answer · 2023-01-19 21:55:39Z

1

You need to make those properties - not fields - in your class:

public class TestData
{
    public int DailyGamingID { get; set; };
    public DateTime GamingDate { get; set; };
    public int LocationID { get; set; };
}

answered Jan 19, 2023 at 21:55

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Collectives™ on Stack Overflow

Entity Framework raw sql query not setting values

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