How to write pure SQL in asp.net mvc?

Question

I've created a controller class as below: ``` public class CelebrityController : Controller { private MyDatabase db = new MyDatabase(); public ActionResult Index() { var query = db.tableCelebrity.Include(t => t.tableMovie); return View(query.ToList()); } } ``` Now I want to do the same thing, but using a pure SQL query in the `Index` method. I am trying to replace code as below: ``` public class CelebrityController : Controller { private MyDatabase db = new MyDatabase(); public ActionResult Index() { IEnumerable results = db.ExecuteQuery (@"SELECT c1.celebid as CelebrityID, t1.movieName as MovieName FROM tableCelebrity as c1, tableMovie as t1 WHERE c1.celebid = t1.celebid"); } } ``` But this gives me an error at the line `db.ExecuteQuery`: Error 'MyProject.Models.MyDatabase' does not contain a definition for 'ExecuteQuery' and no extension method 'ExecuteQuery' accepting a first argument of type 'MyProject.Models.MyDatabase' could be fou…

Accepted Answer

You want something similar to this :

```
using (var context = new BloggingContext())
{
    var blogs = context.Blogs.SqlQuery("SELECT * FROM dbo.Blogs").ToList();
}
```

You can find tutorial for that here : http://msdn.microsoft.com/en-us/data/jj592907.aspx

How to write pure SQL in asp.net mvc?

Solution

Problem