SQL with MVC 4 WebAPI

Question

I've found enough MVC 4 API samples that use a hard-coded array as the data source, but am having trouble finding a simple example with and SQL query.

I have this model:

public class Person
{
    public int id {get;set;}
    public string Name {get;set;}
}

and I would like to construct a controller that returns a list of Person using this database query:

select id, name from names order by name

If it matters, the connection string to the database:

Server=sql12;Database=Mydb;Integrated Security=true;"

Thanks in advance!

write a method which executes the query and read the results and fill list of Person objects and return. Call that method in your action method. — Shyju
– Shyju, Commented May 29, 2013 at 17:11
Thought about doing that, a bit awkward, last resort, I guess. — Metaphor
– Metaphor, Commented May 29, 2013 at 17:18

Andrew Lewis · Accepted Answer · 2013-05-29 17:08:39Z

2

Have a look at the Entity Framework examples for ASP.NET MVC. There are several tutorials that apply to what you're doing.

http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc

answered May 29, 2013 at 17:08

Andrew Lewis

5,2941 gold badge29 silver badges32 bronze badges

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

2 Comments

Metaphor Over a year ago

Is there not a simple ADO.NET solution? Or does WebAPI require the use of a new data access paradigm?

Shyju Over a year ago

@Metaphor: No you can use any data access technology as per your wish.

Collectives™ on Stack Overflow

SQL with MVC 4 WebAPI

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related