Loading

how to select two columns from DBContext linq c#?

how to select two columns from DBContext linq c#?

Abhilash J A

Abhilash J A

9y4kVisual Basic .NET

Hello Everyone,

How can I select only two columns from the table via linq from DBContext ?

I have tried,

Here run time error occurred.

public List ShowOfficesList()
{
using (var context = new ReboxEntities())
{
var listPartnerOfficeName = from offices in context.PartnerOffices select new PartnerOffice() { idPartnerOffice = offices.idPartnerOffice, Officename = offices.Officename };
return listPartnerOfficeName.ToList();
}
}

I have tried this also,

Here compile time error occurred.

public List ShowOfficesList()
{
using (var context = new ReboxEntities())
{
return context.PartnerOffices.Select(c => new { c.idPartnerOffice, c.Officename }).ToList();
}
}

Please help me...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel9y ago
Accepted answer
The issue is in return type of your method. As per the definition of your method, you are supposed to required the list of Class.

So if you are plannng to select just two columns from the dbcontext, you need to create the class that holds these two columns as properties and then you should return the List.
+3
Amit Gupta9y ago
Using select keyword will help you to get the particular column.

Check below link for reference
http://stackoverflow.com/questions/14730691/select-two-columns-from-the-table-via-linq
+2