Generates Alter Columns statements to change any uncompliant columns to postgress naming conventions.

Add nuggets [CLI]

#Run teh following in the terminal:

Install-Package Npgsql.EntityFrameworkCore.PostgreSQL

generate-column-renaming-statements.sql

-- Generate the SQL Statement required to conform All Columns in the Schema.
-- Will pick up and columns ie: 
-- CreatedDate => created
-- Created => created
-- Created Date => created_date

SELECT FORMAT(
  'ALTER TABLE %I.%I.%I RENAME COLUMN %I TO %I;',
  table_catalog,
  table_schema,
  table_name,
  column_name,
  lower(
    -- replace all spaces with _, xX and Xx becomes x_x
    regexp_replace(
      -- First, replace spaces with an _
      replace(column_name, ' ', '_'),
      '([[:lower:]])([[:upper:]])',
      '\1_\2',
      'g'
    )
  )
)
FROM information_schema.columns
WHERE column_name ~ ' |[[:lower:]][[:upper:]]' OR column_name ~ '^[A-Z]';

Run Migrations [CLI]

Add-Migration InitialCreate
Update-Database

startup.cs

//Change the following
services.AddDbContext<YourContext>(options =>
    options.UseNpgsql(Configuration.GetConnectionString("DefaultConnection")));