How to select 2 columns with Entity Framework?

Asked Oct 26 '21 at 17:10

Active Jun 10 '22 at 01:50

Viewed 166 times

Is there a way to run a query using a textbox value & get two columns in return using Entity Framework and insert the values to another table?

tried with single column with no luck.

string warehouse = new DBEntities()
    .emps
    .Where(u => u.emp_id == txt_employee_pack.Text)
    .Select(u => u.sic)
    .SingleOrDefault();

edited Jun 10 '22 at 01:50

Dale K

asked Oct 26 '21 at 17:10

user1704203

1

Have you tried anything at all? What didn't work as expected? – David Oct 26 '21 at 17:13
Please provide enough code so others can better understand or reproduce the problem. – Community Oct 26 '21 at 18:38
Tried with a single column with no luck of getting a result. see update post – user1704203 Oct 26 '21 at 19:53
1

Duplicate of: [Select Multiple Fields from List in Linq](https://stackoverflow.com/questions/1202981/select-multiple-fields-from-list-in-linq), [Select multiple columns using Entity Framework](https://stackoverflow.com/q/19536064/8967612) – 41686d6564 stands w. Palestine Oct 26 '21 at 20:11

0 Answers0