API not loading data from SQL Server

Question

I created an API in Visual Studio Community 2017 that is supposed to load data from a MS SQL server. I created getters for the API to look for certain fields, ex ID, Name. The name getter is working but the ID getter stopped working after my first test and I have no idea why since the other getter are still working.

    public IEnumerable<TableName> GET()
    {

            DBEntities entities = new DBEntities();
            return entities.TableName.ToList();

    }
    public TableName Get(string name)
    {
        DBEntities entities = new DBEntities();
        return entities.TableName.FirstOrDefault(e => e.Name == name);
    }
    public TableName Get(int id)
    {
        DBEntities entities = new DBEntities();
        return entities.TableName.FirstOrDefault(e => e.ID == id);
    }

Does anyone know what I need to do to make the ID getter to work again?

When you set a breakpoint, does it find the database record as you expect? — Seano666, Jul 28 '17 at 21:44
It will give me all the information about a certain record if I search for that record by name. — TheJappad, Jul 31 '17 at 19:32

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

0

You can not have two actions with the same name, see here
What you can do is

 [HttpGet, ActionName("GetByName")]
 public TableName Get(string name)
 {
     DBEntities entities = new DBEntities();
     return entities.TableName.FirstOrDefault(e => e.Name == name);
 }
 [HttpGet]
 public TableName Get(int id)
 {
     DBEntities entities = new DBEntities();
     return entities.TableName.FirstOrDefault(e => e.ID == id);
 }

Or you can play with the route configs.

edited Jun 20 '20 at 09:12

Community

1
1

answered Jul 28 '17 at 22:19

ibubi

2,469
3
29
50

I tried a few different things, including what you said but my ID one gets a null value. Do you know any other workaround for this? – TheJappad Jul 31 '17 at 18:46

score 0 · Accepted Answer · answered Jul 31 '17 at 20:23

Thanks for the hint ibubi.

I ended up changing the Get(int id) to GetID(int id) and same for the name and it started doing what I wanted it to.
For example,

From

 public TableName **Get**(int id)
{
  DBEntities entities = new DBEntities();
  return entities.TableName.FirstOrDefault(e => e.ID == id);
}

To

 public TableName **GetID**(int id)
{
  DBEntities entities = new DBEntities();
  return entities.TableName.FirstOrDefault(e => e.ID == id);
}

API not loading data from SQL Server

2 Answers2