Beginner question - how can i store some user id in my db, and what about cookies?

[dan.woda]

Hi @justbeginnerguy

@justbeginnerguy

How can i now save some user id/username/anything that can point to specific user at Posts table? What should i use? Of course i don’t mean asking You about usage of Entity Framework, but asking about what value i am looking for, and how to get that value after successful user login

You can use the Auth0 user ID (present in the token as the sub claim).

@justbeginnerguy

If i want to get usernames for all of stored userids, what is the best/most effective way to do that? For example i will need to show a lists of users posts in a table, and there will be “user name” column, in which i will need to show user names of specific post. How to make it in a best possible way?

There are different approaches here, but I suggest storing this info in your DB if it is linked to non-auth data like user content/posts. It’s possible to use the Auth0 management API to retrieve a list of users, but you will need to handle rate limits and do it via rest API and will need to reach out to your DB to get the user’s post anyway. It may be simpler to just use your existing DB.

@justbeginnerguy

How can i maintain cookies? Do i need to maintain them? For now i have copied a lot from Auth0 .net core mvc quickstart guide, and everything is working, but while this code:

Auth0’s SDKs usually handle the cookies for you. None of our quickstarts require any manual cookie settings or storage.