how to filter in DBcontext where value in list

Question

how to filter in DBcontext where value in list

ahmed omar 181

Hello,

please I need to make dbcontect where value in list

the current code is

[HttpGet("FindOwnersDocotr")]
        public async Task<IActionResult> GetWonerDotor(string wonerId)
        {
            List<FellowDoctors> dr = await dbContext.FollowDoctors.Where(a => a.ownerId == wonerId).ToListAsync();
         

            if (dr.Count == 0)
            {
                return NotFound("not found");
            }
            return Ok(dr);
        }

and the result is

and I need to get from the Doctor table where DoctorId is in the above json

AgaveJoe 30,126 Reputation points

2023-05-14T10:53:28.9766667+00:00

We need the Doctor and FollowDoctors entities to answer this question. In the mean time, try learning EF Relationships.

Introduction to relationships
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2023-05-14T11:15:57.1266667+00:00

Set a breakpoint before a return and examine the result via the local window.

ahmed omar 181

I found good tutorial for EF relationships, @AgaveJoe , thanks for the advice meanwhile this is Doctor

using System.ComponentModel.DataAnnotations;

namespace EF.Models.doctors
{
    public class Doctors
    {
        public Guid id { get; set; }

        public string fullname { get; set; }
        public string email { get; set; }
        public string password { get; set; }
        public string phone { get; set; }
        public string addresss { get; set; }
        public string image { get; set; }
        public string birthdat { get; set; }
        public string DoctorCode { get; set; }
        public string CreatedDate { get; set; }
        public int roll { get; set; }
        public int IsDeleted { get; set; }

    }

 
}

and FollowDoctors

namespace EF.Models.doctors
{
    public class FollowDoctors
    {
        public Guid id { get; set; }

        public string ownerId { get; set; }
        public string doctorId { get; set; }=string.Empty;
        public string CreatedDate { get; set; }
        public int IsDeleted { get; set; }

    }

 
}

Jack J Jun 25,296 Reputation points

2023-05-15T06:46:39.1433333+00:00

@ahmed omar, It seems that your question is not clear. Your result is empty in the question. what result you want to get from the Doctor table?
ahmed omar 181 Reputation points

2023-05-15T11:43:10.5666667+00:00

@Jack J Jun , user can follow more than doctor , so my API returns the list of doctors' IDs that are followed by the user, and this work fine.

now I need to get the Doctor's name and which are exist on the Doctor table so the filter will be the doctor's list IDs which returned previously, so how to filter by list ?

and I will edit the result , sorry it's empty
Jack J Jun 25,296 Reputation points

2023-05-17T01:59:23.6866667+00:00

@ahmed omar, thanks for the feedback, could you update your question about your result? It will be better for me to analyze your problem.

Your answer

AgaveJoe 30,126 Reputation points

2023-05-14T10:53:28.9766667+00:00

We need the Doctor and FollowDoctors entities to answer this question. In the mean time, try learning EF Relationships.

Introduction to relationships
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2023-05-14T11:15:57.1266667+00:00

Set a breakpoint before a return and examine the result via the local window.
ahmed omar 181 Reputation points

2023-05-14T16:45:23.66+00:00

I found good tutorial for EF relationships, @AgaveJoe , thanks for the advice meanwhile this is Doctor

using System.ComponentModel.DataAnnotations; namespace EF.Models.doctors { public class Doctors { public Guid id { get; set; } public string fullname { get; set; } public string email { get; set; } public string password { get; set; } public string phone { get; set; } public string addresss { get; set; } public string image { get; set; } public string birthdat { get; set; } public string DoctorCode { get; set; } public string CreatedDate { get; set; } public int roll { get; set; } public int IsDeleted { get; set; } } }

and FollowDoctors

namespace EF.Models.doctors { public class FollowDoctors { public Guid id { get; set; } public string ownerId { get; set; } public string doctorId { get; set; }=string.Empty; public string CreatedDate { get; set; } public int IsDeleted { get; set; } } }
Jack J Jun 25,296 Reputation points

2023-05-15T06:46:39.1433333+00:00

@ahmed omar, It seems that your question is not clear. Your result is empty in the question. what result you want to get from the Doctor table?
ahmed omar 181 Reputation points

2023-05-15T11:43:10.5666667+00:00

@Jack J Jun , user can follow more than doctor , so my API returns the list of doctors' IDs that are followed by the user, and this work fine.

now I need to get the Doctor's name and which are exist on the Doctor table so the filter will be the doctor's list IDs which returned previously, so how to filter by list ?

and I will edit the result , sorry it's empty
Jack J Jun 25,296 Reputation points

2023-05-17T01:59:23.6866667+00:00

@ahmed omar, thanks for the feedback, could you update your question about your result? It will be better for me to analyze your problem.

Share via

how to filter in DBcontext where value in list

Your answer