How to return array from database in c#

Question

I want to return my result as array list. My code looks like this:

public Person Get(string doctorCode)
{
     using (PharmaOCEAN_LTEntities entities = new PharmaOCEAN_LTEntities())                   
     {
         return entities.Person.FirstOrDefault(e => e.DoctorLicenseNumber == doctorCode);
     }
}

Some guy informed me that selected (all) result will be an array, so I tried this way, but im getting an error with select statement:

public IList<Person> Get(string doctorCode)
{
    using (PharmaOCEAN_LTEntities entities = new PharmaOCEAN_LTEntities())                   
    {
        return entities.Person.Select<Person>(e => e.DoctorLicenseNumber == doctorCode);
    }
}

any opinions?

Roelant M · Accepted Answer · 2016-10-31 10:13:16Z

1

Yeah sure you can! As a array:

public Person[] Get(string doctorCode)
{
    using (PharmaOCEAN_LTEntities entities = new PharmaOCEAN_LTEntities())                   
    {
        return entities.Person.Where(e => e.DoctorLicenseNumber == doctorCode).ToArray();
    }
}

As a list:

public IEnumerable<Person> Get(string doctorCode)
{
    using (PharmaOCEAN_LTEntities entities = new PharmaOCEAN_LTEntities())                   
    {
        return entities.Person.Where(e => e.DoctorLicenseNumber == doctorCode).ToList();
    }
}

not sure if it compiles, but you get the message :)

answered Oct 31, 2016 at 10:13

Roelant M

1,7082 gold badges15 silver badges33 bronze badges

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

Comments

Krzysiek Szymczak · Accepted Answer · 2016-10-31 10:14:03Z

0

Can you provide info error that you get?

Don't you have to add ToList() at the end of select statement?

answered Oct 31, 2016 at 10:14

Krzysiek Szymczak

1603 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to return array from database in c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related