Hi,

I'm working on a new section for the backend and I have a small issue.

In a grid (jqGrid) I want to diplay some data. I get the data via linq and I want to get the email from the membership provider (the membership table itself is in another DB).

I use the following code:

PaymentsDataContext data = new PaymentsDataContext();
 var q = from act in data.activations
 where act.approved != true
 orderby act.activationDate ascending
 select new {activationID = act.activationID, userName = act.userName,
brokerName = act.broker.brokerName, existingAccount = act.existingAccount,
activationDate = act.activationDate, brokerUser = act.brokerUser, approved = act.approved,
email = System.Web.Security.
 
Membership.GetUser(act.userName).Email};

When I run this code I get a NullReferenceException. I should be able to access the membership provider from the backend, right?

Any one see what I'm missing?

Thank you!