DapperIdentity VS Xpenser

Here's how you can use Identity for auth using dapper and MySQL: https://github.com/gismofx/DapperIdentity

Have a look at my repo which uses Dapper With Identity individual accounts. Might help you get started. https://github.com/gismofx/DapperIdentity

I cobbled together Identity individual user accounts and dapper here: https://github.com/gismofx/DapperIdentity It's what I use with the individual accounts in my projects. It may help de-mystify some of the identity behemoth.

I shared the same desire. I'm not sure what type of auth you are using, but the big thing is making a POST for login to get the cookie. Also for email verification. The user settings and things like that should be much easier to edit via Blazor. I've started to make some alternatives, but you can get an idea in my repo here for the login controller and a simple login component. Note: I'm overdue for a push for the latest code. https://github.com/gismofx/DapperIdentity feel free to PM me and I can try to push you in the right direction

Here it is: https://github.com/gismofx/DapperIdentity

In my case I define the roles as Constant type in the code and store them in database as string type in AppUser Table. You can refer to my this (https://github.com/techierathore/Xpenser) application which has login and roles implemented , you can watch Ep-01, 02, 03 from this (https://www.youtube.com/playlist?list=PLhW718RDpMv4lJhcMXp-c1429HIjEj6iI) playlist to understand the code structure and flow.

u/beer0clock my suggestion would be to Create the UI in a separate project (razor class library), do the DB calls from that library using an API project and call that UI project from either Blazor server or Blazor WASM project. This way you can Switch anytime to new project type and will be future ready for using the same UI in even desktop or mobile app using MAUI Blazor. you can checkout my this (https://github.com/techierathore/TrBlazorEx) code where I have used this approach and written blog about it and this (https://github.com/techierathore/Xpenser ) project which is a full-fledged application using the same approach.

Well I have a Open Source budgeting and expense tracking application for which I am looking for contributors and people to collaborate with ,if interested please have a look at https://github.com/techierathore/Xpenser

Hi You do it the same way you do in any .NET App. You can watch this (https://github.com/techierathore/Xpenser) application code of mine which I use for live streaming. It has authentication implemented. The DB I am using is MariaDb which is basically the newer version of MySQL. I do the authentication via API, use Dapper as ORM and MySqlConnector as DB connector which support many DBs including MySQL.