Fetch result from Raw SQL in asp.net MVC3

Question

in controller

public ActionResult Index(int id)
{
    string sql = string.Format("SELECT * FROM emp WHERE empno = {0}", 3195);
    var ret = db.Database.SqlQuery<int>(sql).ToList();

     // I want to fetch above query result here...
     // Above query returns more than 1 rows and more than 1 column
     // Like ret.Column1(row0).value

    return RedirectToAction("Index");
}

how can I fetch result in the same function.. i need to perform some calculation here and saved the result in database again.

Ehsan Sajjad · Accepted Answer · 2014-04-22 10:13:51Z

1

you need to do like this. Create a ViewModel:

public class EmployeeVM
{
public int Id {get;set;}
public string EmployeeName {get;set;}
}

action:

public ActionResult Index(int id)
{
    string sql = string.Format("SELECT Id,EmployeeName FROM emp WHERE empno = {0}", 3195);
    var ret = db.Database.SqlQuery<EmployeeVM>(sql).ToList();

     /
    return RedirectToAction("Index");
}

Remember that your model properties name should match the column name of the table, as in my case Id and EmployeeName property are mataching with column name.

answered Apr 22, 2014 at 10:13

Ehsan Sajjad

62.6k16 gold badges112 silver badges171 bronze badges

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

4 Comments

kaka Over a year ago

Thanks, can you also tell me if I use ToArray instead of ToList and How?

Ehsan Sajjad Over a year ago

you should use list in my opinion of you want to use array simply replace ToList with ToArray

kaka Over a year ago

Then how can I get value from an arrey

Ehsan Sajjad Over a year ago

same way as you get from List

Collectives™ on Stack Overflow

Fetch result from Raw SQL in asp.net MVC3

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related