asp.net - Find Method With Non Primary Key Not Working

Question

    // GET: api/VENDORs/5
    [ResponseType(typeof(VENDOR))]
    public IHttpActionResult GetVENDOR(string IN_VEN_NAME)
    {
        VENDOR vENDOR = db.VENDORs.Find(IN_VEN_NAME);// ----> A
        //Where(c => c.VEN_NAME == IN_VEN_NAME).FirstOrDefault(); ----> B
        //SingleOrDefault(s => s.VEN_NAME.ToLower() == IN_VEN_NAME.ToLower()); ----> C
        if (vENDOR == null)
        {
            return NotFound();
        }

        return Ok(vENDOR);
    }

When i hit below URLS:

https://localhost:44380/api/VENDORs/XYZ
https://localhost:44380/api/VENDORs/IN_VEN_NAME=XYZ
https://localhost:44380/api/VENDORs/IN_VEN_NAME==XYZ
https://localhost:44380/api/VENDORs/anything

My Output:

[{"VEN_ID":1,"VEN_NAME":"XYZ","VEN_PASSWORD":"XYZ123","VEN_EMAIL":"[email protected]","VEN_MOBILE":987654321,"VEN_ADDRESS":"DZA"},{"VEN_ID":2,"VEN_NAME":"PQRS","VEN_PASSWORD":"PQRS123","VEN_EMAIL":"[email protected]","VEN_MOBILE":123456789,"VEN_ADDRESS":"IJN"}]

When I execute using (A) or (B) or (C) lines of code and hit the above URL's It display's all the records I know the Find() method will search on the Primary key but I need to search with the Non-Primary key and display the particular record.

In my SQL SCHEMA, VEN_ID is Primary Key and all other attributes are not NULL.

NOTE: Records displayed are in JSON Format.

question from:https://stackoverflow.com/questions/65944215/find-method-with-non-primary-key-not-working

Answer 1

Waitting for answers