# Few questions regarding CRUD and Users

**URL:** <https://community.auth0.com/t/few-questions-regarding-crud-and-users/6163>\
**Category:** Get Help\
**Tags:** crud, auth0-users, sql, users, user-creation\
**Created:** [April 8, 2017, 8:26am UTC](https://community.auth0.com/t/few-questions-regarding-crud-and-users/6163 "2017-04-08T08:26:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![daniel.castellanom](https://upload.wikimedia.org/wikipedia/commons/thumb/7/7c/User_font_awesome.svg/768px-User_font_awesome.svg.png) [@daniel.castellanom](https://community.auth0.com/u/daniel.castellanom)\
**Post date:** [April 8, 2017, 8:26am UTC](https://community.auth0.com/t/few-questions-regarding-crud-and-users/6163/1 "2017-04-08T08:26:51Z")

</div>

Hey guys,

I’ve been making a [ASP.NET](http://ASP.NET) Core for a while and had troubles with Identity. Ended up finding Auth0 and seems like it was just what I was looking for.

I have a few doubts though:

Can I use the user ID and add it to a custom Azure DB, in order to tie other user properties? For example, I want to use Auth0 for authentication and such, but I want to manage other user properties in Azure SQL, let’s say a list of games tied a user. Is this possible with Auth0?

Regarding if that is possible, can I have different roles in order to have an admin CRUD those list and modify user lists?

Thanks 🙂

---

<div class="post-metadata">

**Author:** ![bragma](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/bragma/32/13310_2.png) [@bragma](https://community.auth0.com/u/bragma)\
**Post date:** [April 10, 2017, 2:26pm UTC](https://community.auth0.com/t/few-questions-regarding-crud-and-users/6163/2 "2017-04-10T14:26:33Z")

</div>

You’ll end up having a user present both in Auth0 and Azure DB databases. You can save Auth0’s user id in Azure DB (as an unique string) and/or use Auth0’s user profile app\_metadata to store Azure DB’s id. I do both.  
To do so, I use a rule on Auth0. On each login, I check Auth0’s user profile for a specific property. If it is present, then the user already exists in my Azure DB and logins continues normally. If not present, I call my backend (from the rule) to create a new user and get back Azure DB’s id. I then store it as a property in app\_metadata. So on Auth0 I have a login rule, on the backend I have an API endpoint which gets the Auth0 id, creates the user on Azure’s DB and returns back the new user id.  
At the end, I have a double reference so in Auth0 I know the id of the user on my backend, and on the backend I know the Id of the user in Auth0.

---

<div class="post-metadata">

**Author:** ![daniel.castellanom1](https://upload.wikimedia.org/wikipedia/commons/thumb/7/7c/User_font_awesome.svg/768px-User_font_awesome.svg.png) [@daniel.castellanom1](https://community.auth0.com/u/daniel.castellanom1)\
**Post date:** [April 10, 2017, 9:07pm UTC](https://community.auth0.com/t/few-questions-regarding-crud-and-users/6163/3 "2017-04-10T21:07:46Z")

</div>

Ah I see! Thanks a lot. This actually looks exactly like what I am trying to do.

Just gotta find out how to do it now that it is possible.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/auth0/original/3X/b/5/b560f266932fcce5d57f09a6595bd50518cae3f3.jpeg) [@system](https://community.auth0.com/u/system)\
**Post date:** [March 2, 2018, 5:53am UTC](https://community.auth0.com/t/few-questions-regarding-crud-and-users/6163/4 "2018-03-02T05:53:10Z")

</div>


