MVC ExecuteQuery not a valid method on Context object

Question

I am trying to execute a sql command directly against the database. However, intellisense does not see ExecuteQuery as a valid method against my context variable. I am sure I am missing something obvious.

My context class:

 public class CatastropheContext : DbContext
 {
     public DbSet<CLIENT> CLIENTs { get; set; }
     ...
 }

My attempt to establish the query:

CatastropheContext db = new CatastropheContext();
IEnumerable<ClientClaim> = db.ExecuteQuery

In the code above, ExecuteQuery is flagged as invalid an intellisense suggests creating a stub method.

score 2 · Answer 1 · answered Mar 23 '12 at 17:52

2

Can you use Database.ExecuteSqlCommand where Database comes from the DbContext class.

answered Mar 23 '12 at 17:52

Sachin Kainth

45,256
81
201
304

1

ExecuteSqlCommand does not show as a valid method under Database. I did include "using System.Data.Entity" to no avail. – Gene Stempel Mar 23 '12 at 17:57
1

It looks like I can use db.Database.ExecuteSqlCommand, so perhaps I am gtg. Thanks! – Gene Stempel Mar 23 '12 at 18:11

score 0 · Answer 2 · answered Mar 23 '12 at 17:53

0

This seems to me like you are missing some references. Make sure you are:

using System.Data.Linq;

Here is the MSDN reference on ExecuteQuery. Notice the namespace.

answered Mar 23 '12 at 17:53

Justin Pihony

66,056
18
147
180

If there are additional details I could provide, please let me know and I will post them. – Gene Stempel Mar 23 '12 at 17:57
That did not answer my question :) Do you have that using statement? – Justin Pihony Mar 23 '12 at 17:59
1

I did *not* have that using statement. However, adding it made no difference. I did find that: db.Database.ExecuteSqlCommand is valid, so perhaps I am gtg. Thanks for your assist! – Gene Stempel Mar 23 '12 at 18:08

MVC ExecuteQuery not a valid method on Context object

2 Answers2