Mvc email account confirmation/reset password using postgresql as DB

Question

1.00/5 (1 vote)

See more:

I would like to implement an access account using email (with verification) including a reset password but most of the samples are using SQL server.

What I have tried:

Is there other mechanism or component which is DB agnostic (I'm currently using Postgresql)? A sample project is very much appreciated. Thank you.

Posted 29-Jun-24 23:53pm

sirch fsarso

Add a Solution

Comments

[no name] 30-Jun-24 14:09pm

The problem should be the same whichever database you use. The only difference being the exact syntax of the database commands.

Dave Kreskowiak 1-Jul-24 9:57am

You could always use SQL Server Express. It's free.

IMHO, writing anything that depends on Access is going to bite you in the ass with the next Office update.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2024-06-30T10:52:00

Solution 1

With Entity Framework, all that you need to do is swap the libs using Nuget, change the connection string, then run the commands to crate the database and tables.

Here is a Google Search with many examples of how to do this: entity framework postgresql tutorial[^]

Posted 30-Jun-24 10:52am

Graeme_Grant

Comments

sirch fsarso 5-Jul-24 20:57pm

Thank you Graeme_Grant, i'll try these recommendations and get back on the results

Pete O'Hanlon · Answer 2 · 2024-07-02T03:36:00

As this is such a common thing to do, and so easy to do, I'll write out the steps to follow here:

Uninstall the Microsoft.EntityFrameworkCore.SqlServer package. You're not going to need this one.
Install the Npgsql.EntityFrameworkCore.PostgreSQL package.
Install the Npgsql package.
Update your application.json file to provide a PostgresSQL connection string instead of a SQL Server one.
In Program.cs, change options.UseSqlServer to options.UseNpgsql in the AddDbContext operation.
Delete the existing migrations
Run dotnet ef migrations add CreateIdentity to create your new migrations.
Run dotnet ef database update to create the tables inside Postgres.

You can now run your application and create users/log in as needed.