sql server - How to select columns with other name in linq? -

sql server - How to select columns with other name in linq? -

i select records in sql server query seen below:

select productname 'some name1' , payment 'some name2' dbo.prefactorproduct

is there way select records in linq queries?

you can project result query anonymous type , utilize different alias/field names fields.

var query = db.prefactorproduct .select(r=> new { somename1 = r.productname, somename2 = r.payment });

but if trying format result set displaying purpose should in assigning column names grid/ info container.

sql-server linq multiple-columns