ASP.NET Core 2.1 Identity

I thought I'd compile some resources on ASP.NET Core 2.1 Identity. Hope you find these useful:

Database schema of tables that are generated after the first EF Migration:

https://gist.github.com/aaronhoffman/74f4c072afaa0459dcd6595b6380f67d


You can override password rules in the Startup.cs class:

            services.AddDefaultIdentity()
                .AddEntityFrameworkStores();

             services.Configure(options =>
            {
                options.Password.RequireDigit = false;
                options.Password.RequireLowercase = false;
                options.Password.RequireUppercase = false;
                options.Password.RequireNonAlphanumeric = false;
            });


If you are wondering where the AccountController or login pages are (because they do not appear in the solution explorer by default) more info can be found here: https://docs.microsoft.com/en-us/aspnet/core/security/authentication/scaffold-identity?view=aspnetcore-2.1&tabs=visual-studio



That's it for now, hopefully more to come...
Aaron


Comments

Post a Comment

Popular posts from this blog

Search iPhone Text Messages with SQLite SQL Query

Image
While you're here, check out some of our interactive visualizations:

Would you like to visualize your text messages?

-------------------------------------------------------------------------------


In my experience, the iPhone text message search functionality is usually pretty awful. Especially if you're trying to find a text from a few years ago. Luckily, if you backup your iPhone using iTunes, your text messages are exported/stored in a SQLite database, and it is fairly easy to query.

Here are the steps to SQL Query your Text Messages.

  1. Backup your iPhone using iTunes.

  2. Find the SQLite file that contains your text messages.
    - in ~/Library/Application Support/MobileSync/Backup/* with a filename of 3d0d7e5fb2ce288813306e4d4636395e047a3d28

  3. Ensure you have a SQLite Query tool (SQLiteBrowser is pretty good).

  4. Open your SQLite Text Message DB File using your favorite SQLite query tool.

  5. Execute this query to see all your messages.

Disclaimer, I had to gue…
Read more

How to Turn Off Microsoft Arc Touch Mouse Scroll Sound Vibration

Image
I recently purchased a Microsoft Arc Touch Mouse and wanted to turn off the middle button wheel scroll sound vibration.

It is possible, however perhaps not obvious.  First you need to download the "Mouse and Keyboard Center" executable available on this page https://www.microsoft.com/accessories/en-us/products/mice/arc-touch-mouse/rvf-00052#techspecs-connect.

(direct link Win10 x64: https://go.microsoft.com/fwlink/?linkid=849754 )


Run the executable and install the software.  After the software is installed, turn off "Vibration." See image below:




Hope this helps,
Aaron


p.s.  Want to make that next report really pop?

Check out this new tool I'm working on:






Read more

Use Azure Functions to Execute a SQL Azure Stored Procedure on a Timer

Image
It was hard to find this information all in one place, so I thought I'd throw a post together quick.

If you have the need to execute a stored procedure on a timer, that can be fairly easily accomplished with Azure Functions.

Create a new Timer Trigger Azure Function, set the cron timer as desired, and add code similar to the code below:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Dapper;

public static void Run(TimerInfo myTimer, TraceWriter log)
{
    var conString = ConfigurationManager.ConnectionStrings["ConString"]?.ConnectionString;

    using(var con = new SqlConnection(conString))
    {
        con.Execute("dbo.MyProc", commandType: CommandType.StoredProcedure);
    }
}


This code will not compile at this time. Note the name of the connection string, we'll need that in the app settings page.

Go to the Connection Strings section of the Application Settings for the function app (this will look very similar to the Con…
Read more