Identity 8 doesnt work on PostgresSQL

[Temoxa]

Is there an existing issue for this?

• I have searched the existing issues

Describe the bug

Hello!

I make mini app where use AddIdentityApiEndpoints and AddEntityFrameworkStores in PostgresSql.

TestIndetity8.zip

1. Empty AspNetUserTokens

When your loaded and extract arhive app then run docker compose up --build -d
and go to url http://localhost:8080/swagger/index.html
will be opened swagger as is image below

I call method /register then call /login its ok

BUT then connect to database and call query SELECT user_id, login_provider, "name", value FROM tst."AspNetUserTokens"; have empty result. Why? Where tokens after succesfull /login ?

2. How extend methods Identity (/register, /login, /manage/info etc) ?

maybe I didn’t understand how to work, please help

Expected Behavior

1 - when call /login in table AspNetUserTokens insert record
2 - configurate Identity EndPoints

Steps To Reproduce

No response

Exceptions (if any)

No response

.NET Version

8.0.1

Anything else?

No response

[martincostello]

Please provide the repro as a Github repository, not a ZIP file.

aspnetcore/.github/ISSUE_TEMPLATE/10_bug_report.yml

Lines 36 to 42 in e9c1d8a

	We ❤ code! Point us to a [minimalistic project which reproduces this issue (repro)](https://github.com/dotnet/aspnetcore/blob/main/docs/repro.md) hosted in a public GitHub repo.
	We will close this issue if:
	- The repro project you share with us is complex. We can't investigate custom projects, so don't point us to such, please.
	- If we will not be able to repro the behavior you're reporting.
	- If the repro project is attached as a `.zip` file.
	- If the GitHub repro project is set to `Private`.

Hi @Temoxa. We have added the "Needs: Author Feedback" label to this issue, which indicates that we have an open question for you before we can take further action. This issue will be closed automatically in 7 days if we do not hear back from you by then - please feel free to re-open it if you come back to this issue after that time.

[Temoxa]

Please provide the repro as a Github repository, not a ZIP file.

aspnetcore/.github/ISSUE_TEMPLATE/10_bug_report.yml

Lines 36 to 42 in e9c1d8a

	We ❤ code! Point us to a [minimalistic project which reproduces this issue (repro)](https://github.com/dotnet/aspnetcore/blob/main/docs/repro.md) hosted in a public GitHub repo.
	We will close this issue if:
	- The repro project you share with us is complex. We can't investigate custom projects, so don't point us to such, please.
	- If we will not be able to repro the behavior you're reporting.
	- If the repro project is attached as a `.zip` file.
	- If the GitHub repro project is set to `Private`.

Ok, test project https://github.com/Temoxa/IdentityNet8

[mkArtakMSFT]

Thanks for contacting us. The behavior you've observed here is by design. The generated accessToken and refreshToken aren't stored in the database. They're generated using DataProtection and are validated like cookies. That table that you've queries will be used to store email confirmation tokens for example.