How to select 2 columns with Entity Framework?

Asked Oct 26 '21 at 17:10

Active Oct 26 '21 at 19:54

Viewed 57 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 Oct 26 '21 at 19:54

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