Linq : unable to cast object

It errors:

"role is  not declared or is not in the current scope"

Post the code as you implemented it with all variables definitions that are used as well.

Your code returns a query and is not enumerated yet. Return a query.ToArray()  or query.ToList()

I must admit never having done Linq in VB.NET, only in C#,

but can't you do something similar to:
return  oEntities.aspnet_Roles.Where(r => r.sssMenuRole.menuID == menuId2).ToArray();
(don't know VB.NET equivalent)
I also assume that your linq model has relationships between asp_role and menu table (based on the role_id)

I tried that:

Dim query As New List(Of aspnet_Roles)

                query = (From role In oEntities.aspnet_Roles, menu In oEntities.sssMenuRole _
                                  Select RoleId = role.RoleId, RoleName = role.RoleName, _
                                         RoleIDMnu = menu.RoleId, MenuIDMnu = menu.menuId _
                                  Where MenuIDMnu = menuId2 And RoleId = RoleIDMnu _
                                  Select role).ToList()

the "select role" errors with same error, 'either not declared or not in current scope.'

If I do it this way:

               query = (From role In oEntities.aspnet_Roles, menu In oEntities.sssMenuRole _
                                  Select RoleId = role.RoleId, RoleName = role.RoleName, _
                                         RoleIDMnu = menu.RoleId, MenuIDMnu = menu.menuId _
                                  Where MenuIDMnu = menuId2 And RoleId = RoleIDMnu _
                                  Select RoleId, RoleName).ToList()

with this change:

Select RoleId, RoleName

it errors with generic list of anonymous type cannot be converted to  generic list of aspnet_Roles.

sigh.

what's the first select used for anyway?

    query = (From role In oEntities.aspnet_Roles, menu In oEntities.sssMenuRole _
        Where MenuIDMnu = menuId2 And RoleId = RoleIDMnu _
                                  Select role).ToList()
                                              

1:
2:
3:

Here is the query built-by-hand:

           Dim sql As New StringBuilder()
            sql.AppendLine("SELECT r.RoleId,  r.RoleName ")
           sql.AppendLine("FROM dbo.aspnet_Roles r ")
           sql.AppendLine("WHERE r.RoleId IN ")
           sql.AppendLine(" (select roleID from dbo.sssMenuRole where menuId = @MenuId) ")
           sql.AppendLine("Order By r.RoleName")

I'm getting confused, you're selecting roleID + roleName, but expecting to get out a complete role.
select the role as a complete object using linq, or create a new class that contains only roleID, roleName and return that if you like.
but selecting just 2 properties will not working, unless you explicitly create a new object and set these properties yourself, but I don't see the sense of doing that.

If you refer to the previous posts, you'll see I've tried to select all the fields...

>>                                  Select role).ToList()
>>the "select role" errors with same error, 'either not declared or not in current scope.'

But it errors.

I don't care how I do it, as long as I can get it to work.

Can you tell me how to reproduce that query in linq? with selecting *

return oEntities.aspnet_Roles.ToList()

that's all

return? can you spell it out for me please?

               query = (From role In oEntities.aspnet_Roles, menu In oEntities.sssMenuRole _
                                 Select RoleId = role.RoleId, RoleName = role.RoleName, _
                                        RoleIDMnu = menu.RoleId, MenuIDMnu = menu.menuId _
                                 Where MenuIDMnu = menuId2 And RoleId = RoleIDMnu _
                                 Select role).ToList()

It looks like it's working.

Thanks!

I have another question using this same query, if you can look at it:

http://www.experts-exchange.com/Programming/Languages/.NET/LINQ/Q_24204214.html

thanks!