How to access the database from the api controller?

Question

I am doing a mobile app with Angular and MVC. I am doing my app calling some dummy data from the json model in the web api. Check my code below:

 private IEnumerable<JsonModel> events = new JsonModel[]
    {
       new JsonModel {Id = 1, Title = "title1"}
       new JsonModel {Id = 2, Title = "title2"}
      };


        // GET api/<controller>
        public IEnumerable<JsonModel> Get()
        {
            return events;
        }

        // GET api/<controller>/5
        public JsonModel Get(int id)
        {
            return events.FirstOrDefault(e => e.Id == id );
        }

What I want to do now is to connect my project to the real database. How can I do that?

There are a zillion of possible answers to your question, and this is clearly too broad, and you want somebody to do your homework. Please do some research first, try something and if you have a concrete problem come back to SO. — Faris Zacina
– Faris Zacina, Commented Feb 9, 2015 at 14:49
Zencoder I have done my research. But I cant find much about this. I have added the database to my project, but I don't know how to access it :/ Thank you anyway — Amehiny
– Amehiny, Commented Feb 9, 2015 at 14:56
You should include all the research that you have done. What kind of database? what do you want to retrieve? how it should work? — Faris Zacina
– Faris Zacina, Commented Feb 9, 2015 at 14:57

oskar132 · Accepted Answer · 2015-02-09 15:30:49Z

2

As the ZenCoder mentioned, there are lots of ways to access your database, one of them is the repository pattern, here's some info about it:

https://msdn.microsoft.com/en-us/library/ff649690.aspx

This is one of the most famous patterns used nowadays and when working with the asp.net mvc framework is used with the Entity Framework. Here's a nice tutorial which explains how to use it with the ASP.NET Web Api2:

http://www.asp.net/web-api/overview/data/using-web-api-with-entity-framework/part-1

any question just let me know.

answered Feb 9, 2015 at 15:30

oskar132

8483 gold badges13 silver badges36 bronze badges

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

Comments

DanielV · Accepted Answer · 2017-11-10 12:32:29Z

0

Configuring access to the database file itself can be also the source of your isssue, look here: Configuring Permissions for an Access Database

Hope it helps

answered Nov 10, 2017 at 12:32

DanielV

2,7503 gold badges49 silver badges68 bronze badges

Collectives™ on Stack Overflow

How to access the database from the api controller?

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related