Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Renner Wellingon de Oliveira 12 posts 82 karma points
    May 19, 2017 @ 17:51
    Renner Wellingon de Oliveira
    0

    Creating relationship in umbraco database

    How can i create a many to one relationship with member, for exemple one member have a many adress, i'm starting in umbraco please someone has a tutorial or a video

  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    May 19, 2017 @ 21:17
    Alex Skrypnyk
    0

    Hi Renner

    How should relationships look like?

    Do you want to store some data in the member?

    Try to look how to work with members - https://our.umbraco.org/documentation/getting-started/data/members/

    It looks like you need to create addresses property for each member and then use it. Ask if it's not clear )

    Thanks,

    Alex

  • Renner Wellingon de Oliveira 12 posts 82 karma points
    May 22, 2017 @ 12:20
    Renner Wellingon de Oliveira
    0

    The member will have store a id of a city and the city a list of members like a entity framework relationship

  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    May 22, 2017 @ 13:11
    Alex Skrypnyk
    0

    Hi Renner

    Are you managing members via Umbraco members section?

  • Renner Wellingon de Oliveira 12 posts 82 karma points
    May 22, 2017 @ 13:21
    Renner Wellingon de Oliveira
    0

    Yes, but i need to edit this properties but not using the custom. Creating in de code a new mapping

  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    May 22, 2017 @ 13:29
    Alex Skrypnyk
    0

    Then you need to add city picker to your members.

    The city picker can be a content picker, then get all members by City value.

  • Renner Wellingon de Oliveira 12 posts 82 karma points
    May 22, 2017 @ 18:47
    Renner Wellingon de Oliveira
    0

    this way the member will have a city id in database?

  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    May 22, 2017 @ 21:25
    Alex Skrypnyk
    0

    Hi Renner,

    Id of City node in Umbraco or id of City row of picker.

    Do you want to be able to set and control ids?

    Alex

  • Renner Wellingon de Oliveira 12 posts 82 karma points
    May 23, 2017 @ 18:29
    Renner Wellingon de Oliveira
    0

    City node? but i just have city in a db table

  • Alex Skrypnyk 5908 posts 22603 karma points MVP 4x admin c-trib
    May 23, 2017 @ 21:29
    Alex Skrypnyk
    0

    Renner, I would suggest you use nuPickers, there is already created SQL DropDown Picker datatype, that you can use - https://our.umbraco.org/projects/backoffice-extensions/nupickers/

    Thanks,

    Alex

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies