c# - Using LInq to SQL to get all the user email from ASP.NET Membership -

c# - Using LInq to SQL to get all the user email from ASP.NET Membership -

public actionresult downloadmembers() { membershipusercollection users = membership.getallusers(); var grid = new webcontrols.gridview(); grid.datasource = members in users // users gives error select new { name = members.firstname, // doesn't works email = members.email // doesn't works }; grid.databind(); response.clearcontent(); response.addheader("content-disposition", "attachment; filename=" + "members" + ".xls"); response.contenttype = "application/excel"; stringwriter sw = new stringwriter(); htmltextwriter htw = new htmltextwriter(sw); grid.rendercontrol(htw); response.write(sw.tostring()); response.end(); homecoming redirecttoaction("index"); }

hi above query downloads details membership table csv format ms excel, gives error on users is:

could not find implementation of query pattern source type 'system.web.security.membershipusercollection'. 'select' not found. consider explicitly specifying type of range variable 'members'.

can 1 guide me on how user email address , his/her name on csv instead of getting details.

edited: works :)

grid.datasource = membershipuser u in membership.getallusers() select new { firstname = u.username, email = u.email };

grid.datasource = (from members in users select new { name = members.firstname, email = members.email }).tolist();

i think need phone call tolist()as linq lazy loading, calling tolist() explicitly forcing load data.

c# asp.net-mvc linq-to-sql csv asp.net-membership