Web API 2 is not retrieving data from database

Question

0.00/5 (No votes)

See more:

I have api controller in my project which has to retrive data from database based on ISBN

When I am getting an error

":"No HTTP resource was found that matches the request URI 'http://localhost:2280/api/ServiceA/'.","MessageDetail":"No action was found on the controller 'ServiceA' that matches the request."}

What I have tried:

Here is the controller class which have to filter the data based on isbn in the url. but instead its showing no http resource matches the UrI

       [Route("{isbn}")]
       public Book Get(string isbn)
          {

            using (AppDbContext db = new AppDbContext())

            {

                var query = from b in db.Books

                            where b.ISBN == isbn && b.Source == "Book Store 1"

                            select b;

                return query.SingleOrDefault();

            }

        }
    }
}

Here is the table book

public class book
    {
        [Table("Books")]
        public class Book
        {
            public int Id { get; set; }
            public string ISBN { get; set; }
            public string Title { get; set; }
            public string Publisher { get; set; }
            public string Author { get; set; }
            public decimal Price { get; set; }
            public string Source { get; set; }
            public string PurchaseUrl { get; set; }
        }
    }

Posted 3-Mar-17 14:58pm

codegeekalpha

Updated 3-Mar-17 18:30pm

Add a Solution

Comments

Garth J Lancaster 3-Mar-17 22:15pm

where does the 'ServiceA' part of this route

'http://localhost:2280/api/ServiceA/'

come from ... I would expect a valid route, given the code you have shown, to be

'http://localhost:2280/api/isbn/'

I'm not saying 'you've got it wrong', I've done a lot with REST but not WEB API 2 .. so the definition/setup may be elsewhere

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bryian Tan · Answer 1 · 2017-03-03T18:30:00

Solution 1

Add a [RoutePrefix("api/ServiceA")] attribute to the controller. Without that, somehow, the valid URI will be http://localhost:2280/isbn instead of http://localhost:2080/api/ServiceA/isbn

C#

[RoutePrefix("api/ServiceA")]
    public class ServiceAController : ApiController

I got the same error without the RoutePrefix attributes

XML

<Error>
  <Message>No HTTP resource was found that matches the request URI 'http://localhost:47503/api/ServiceA/2'.</Message>
  <MessageDetail>No action was found on the controller 'ServiceA' that matches the request.</MessageDetail>
</Error>

Posted 3-Mar-17 18:30pm

Bryian Tan

Updated 3-Mar-17 18:34pm

v2

Comments

codegeekalpha 4-Mar-17 14:02pm

but I dont want a route prefix as api/serviceA. I want my URI to b localhost:2280/api/ServiceA/isbn.. Which is already defined in WebAPI config but with this i am getting error no resource found

Bryian Tan 4-Mar-17 19:00pm

is the "isbn" word part of the url?

codegeekalpha 4-Mar-17 19:20pm

Isbn is coming from database and i write it like 1234 which is its value in database and is of string type

Bryian Tan 4-Mar-17 19:46pm

based on what you presented here, I really don't see why you can not put [RoutePrefix("api/ServiceA")] decorator on top of the controller. Then you can navigate to http://localhost:47503/api/ServiceA/1 to retrieve book where isbn=1 .
Was there an error?