Raw Sql query not working Entity Framework

Asked Jan 05 '21 at 10:09

Active Jan 05 '21 at 10:11

Viewed 231 times

Entity Framework:

readonly learning_dbEntities learning_db = new learning_dbEntities();

var userRemindersCheck1 = learning_db.Database.SqlQuery<string>("Select * from UserRemainderEntities");

(or)

var userRemindersCheck1 = learning_db.Database.SqlQuery<string>("Select * from UserRemainderEntities").ToList();

Both are not working!

It showing no error but data is not displaying. Please provide if you find any solution.

edited Jan 05 '21 at 10:11

Yehor Androsov

4,885
2
23
40

asked Jan 05 '21 at 10:09

user27976

1

You shouldn't be using `string` here, it should be a class. – DavidG Jan 05 '21 at 10:15
If possible, provide some syntax or reference links, i will understand better. Thank you responding! – user27976 Jan 05 '21 at 10:18
I used this https://stackoverflow.com/a/35184536/6499680, please check once! – user27976 Jan 05 '21 at 10:23
1

Well you can't just apply random Stack Overflow answers to your code without understanding them. – DavidG Jan 05 '21 at 10:24
If Possible, Please provide some tutorial links so that i will refer and learn Raw Sql syntax better. – user27976 Jan 05 '21 at 10:28
Ok working without string After i refer this:https://medium.com/@9749866865s/how-to-execute-raw-sql-query-by-using-dbcontext-e7928a0b179 – user27976 Jan 05 '21 at 10:34

Raw Sql query not working Entity Framework

0 Answers0