Hi,

I have the following design table,

dbo.asp.net_users - ApplicationId - UserId - UserName - LowerredUserName - Mobile Alias - IsAnonymous - LastActivityDate

dbo.aspnet_membership - ApplicationId - UserId - UserName - Comment

dbo.UserProject - UserProjectId(PK) - ProjectId - UserName

dbo.Project - ProjectId (PK) - ProjectSubGroupId - ProjectCoded

I would like to retrieve value from Comment field which contain fullname currently i can do project.UserProject[0].Items.UserName (which will retrieve the username)

Then i need display Full Name (comment field) instead username. How i can achieve this. Currently there is no link between UserProject and dbo.aspnet_,membership.

Please advise

Why there is no link? UserProject should have a FK pointing to the User table.

Hi Walaa,

Thank you.

I just wondering is there anyway to do it with LLBLGen code without having to do it from database. Please advise

If no relationship is present, How would you obtain the Comment fild? If you don't have FK on DB you can create a model-only relationship in your LLBLGen Designer. Otherwise (if no link is present) you need to do a search by UserName on membership table.

Hi Daelmo I am interesting to search using Membership method you mention earlier. How i can search username in Membership using the following scenario. Would you be able to point out what i missing?

Test: I am trying to return name by Searching using membership, but the following not working

if (n.Value == Membership.FindUsersByName(p.UserProject.Items[0].UserName).ToString())
                {
                    pnode = n;
                    break;
                }

The following code will return the username not name

private void BuildTreeNode()
{
ArrayList pgnodes = new ArrayList();
        RadTreeNode pnode = null;
        RadTreeNode snode = null;

EntityCollection<ProjectEntity> collection = GetTestData();
foreach (RadTreeNode in pgnodes)
{
    pnode = null;
    foreach (RadTreeNode n in pgnodes)
   {
      if (n.Value == (p.UserProject.Items[0].UserName))
      {
             pnode = n;
             break;
       }
   }

}
}

I don't think David meant querying using the Membership framework. He meant querying using LLBLGen Pro Predicates on an EntityCollection (entity mapped to the secified table).