Query enum value from DB in C#

Question

My Appointment database has Appointment ID, Status(enum type), Student as column values.

This is the Status enum:

 public enum StatusType
{
    Pending,
    Approved,
    Cancelled
}

I need to query the list of rows in the db(appointments) where Status column is set to 'Pending' and pass it to a list variable.

How do I do that in Visual Studio using C#?

IEnumerable<Appointment> AppQuery = from appointment in _appointmentData.GetAll()
                                            where appointment.Status???? 
                                            select appointment;

Note: _appointmentData.GetAll() lists the entire rows in the db.

Have you tried where appointment.Status == StatusType.Pending — mariocatch
– mariocatch, Commented Aug 5, 2016 at 2:31

sgeddes · Accepted Answer · 2016-08-05 02:30:35Z

2

Depends a bit on what gets stored in your database, but what about using .Equals:

IEnumerable<Appointment> AppQuery = from appointment in _appointmentData.GetAll()
       where appointment.Status.Equals(StatusType.Pending)
       select appointment;

answered Aug 5, 2016 at 2:30

sgeddes

62.9k7 gold badges67 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

Query enum value from DB in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related