locked
Linq To Sql One to Many Many To Many RRS feed

  • Question

  • Hi I am using sql server 2005.
    I want to get User object when user login into my application.
    I want to create Object structure like the below.
    Top level is User Object
    User object contains Roles Collection
    Each Role contains Feature Collection
    Each feature contains Access permissions.
    Attached my database design document.
    Could you please help me to write this query?


    Table Relations:
    tblUser
    tblRole
    tblUserRoleLink
    tblFeature
    tblFeatureRoleLink

    tblUserRoleLink table contains userid from tblUser and RoleID from tblRole
    tblFeatureRoleLink contains RoleId from tblTole and Featureid, Read Access,Write Access, Delete Access and Update Access


    Thanks
    Ravi

    Sunday, January 10, 2010 8:05 PM

Answers

  • Maybe it's me, but I don't see any Silverlight part associated with this question. Is this question in relation to Silverlight?
    Monday, January 11, 2010 6:56 AM
  • Hi Pprasadravi,

    Seems it is not related with Silverlight directly, I would highly recommend you post it to here. There you will be better served.  Thanks for your understanding.

    Best regards,

    Jonathan

    Friday, January 15, 2010 3:27 AM

All replies

  • Maybe it's me, but I don't see any Silverlight part associated with this question. Is this question in relation to Silverlight?
    Monday, January 11, 2010 6:56 AM
  • No this is related to Linq To Sql.

    Monday, January 11, 2010 8:45 AM
  • Hi Pprasadravi,

    Seems it is not related with Silverlight directly, I would highly recommend you post it to here. There you will be better served.  Thanks for your understanding.

    Best regards,

    Jonathan

    Friday, January 15, 2010 3:27 AM