ASP.NET Core SaaS Development with PostgreSQL & Azure

Explore ASP.NET Core Razor pages by setting up the development environment, creating and touring a Razor pages web app, customizing its look, navigating files, and testing changes.

Explore three development environments—Visual Studio 2022, JetBrains Rider, and Visual Studio Code—along with the required dotnet SDK and extensions to set up a cross-platform ASP.NET Core workflow.

Explore getting started with Visual Studio 2026, including insider preview access, workloads for ASP.NET web development and Azure, and a sleek UI with integrated AI features.

Register a new ASP.NET Core Razor Pages web app with authentication. Explore Program.cs, appsettings.json, identity, and Razor Pages structure, including data context and launch settings, for the first run.

Run the app via https profile or start without debugging to view the out-of-the-box home and privacy pages with registration and login, and use hot reload to apply layout changes.

Discover how to swap in a free bootstrap five admin theme, download and integrate the starter kit, and create an _admin layout to render pages in ASP.NET Core.

Customize the extreme admin theme in an ASP.NET Core app by adjusting the nav bar and logo, refining links, and enabling dynamic titles that reflect the page and app name.

Wrap up this section by reviewing how to set up development environment, IDEs, SDK versions, and a web project with file layouts and a custom admin theme for ASP.NET Core.

Set up Entity Framework Core for your ASP.NET Core project with Neon PostgreSQL, define data models, and perform database updates as you create a Neon instance.

Learn to add entity framework core to a .NET project, install the postgres provider, switch from sql server, configure a neon crm connection, and register the db context in Program.cs.

Extend ASP.NET Core Identity with an agent, add customer, vacation package, and booking entities, and configure one-to-many relationships with foreign keys and navigation properties in the db context.

Learn to manage migrations with entity framework by adding columns to the identity user table, creating vacation packages, and handling down migrations across SQL Server and PostgreSQL.

Seed default data by overriding the on model creating method, use HasData to add vacation package records with set IDs, and create a migration named seeding vacation packages.

Discover neon, a fully managed serverless PostgreSQL platform that separates storage and compute for scalable, cost-efficient cloud native apps, with branching, point-in-time recovery, and EF Core compatibility.

Learn how to provision a neon database project, create a neon CRM project, choose hosting, use the free tier, and leverage in-browser SQL editor and GitHub integrations.

Add the connection string to appsettings.json and consider secrets or environment variables for production. Run dotnet ef database update to apply migrations and seed tables in Neon PostgreSQL.

Apply entity framework core with Neon postgres, select NuGet packages for postgres versus sql server, define models and the db context, run migrations, seed data, and prepare the crm.

Advance your CRM capabilities by implementing login, registration, and customized pages, and build CRUD operations for customers and bookings while testing database communication.

Adjust the admin layout to reflect login state with a new admin login partial, update login/register links, switch identity to agent, and enable logout via a secure form.

Scaffold and override identity registration pages, add first name and last name to the agent user, and validate inputs during on get and on post registration.

Learn how identity core handles login with email as the username, using sign in async, remember me, and return URL redirects, while offering registration, forgot password, and user management options.

Scaffold customer CRUD pages with Razor Pages and EF Core DbContext, inject dependencies, and render Bootstrap tables showing customer data and related agent names.

Add and test customer management operations within the admin layout, including create, edit, list, details, and delete with agent selection and server-side binding.

Build booking management with Razor pages and EF Core, adding CRUD pages, display name tweaks, and dropdowns for customers and packages, plus UTC date handling for PostgreSQL.

Set up a test smtp email flow with papercut in an ASP.NET Core app, configuring email settings, implementing an email sender, and wiring it for registration confirmations.

Implements login, registration, and email sending, and builds CRUD for customers and bookings with scaffolded pages and UI tweaks. Validates PostgreSQL usage on Neon cloud.

Explore implementing a multi-tenant database setup using Neon as the database engine, including branching, provisioning via the Neon API, and integrating multi-tenancy management into your application.

Explore Neon database branching for multi-tenant SaaS, including data and schema branches. Automate API access with keys and open API specs.

Explore multi-tenancy concepts and design choices, focusing on separate database per tenant with data isolation, branching neon databases, and dynamic connection management for scalable SaaS apps.

Implement a Neon API service client by wiring the http client and config, setting the base URL and API key, and modeling branch create request and response.

Define the project id from the Neon API config, build a branch create request with the tenant name and parent branch id, and post to projects/{projectId}/branches to orchestrate the service.

Learn how to extend the user model with a tenant connection string, run migrations, and update the database to support multi-tenancy by dynamically forming and storing per-tenant connection details.

Automate on-the-fly tenant db creation with a dedicated tenant db context and factory, registered as a scoped service, using a connection-string claim for efficient runtime access.

Configure dynamic tenant connection strings by extending the user claims principal factory to add a tenant connection string claim and retrieve it via http context for DbContext creation.

Test and refactor a multi-tenant ASP.NET Core app by validating registration, verifying a tenant connection string, switching to a tenant database context, and auto-creating tenant users.

Encrypt saved connection strings with an aes encryption helper, decrypt on use via a config-based key, and inject the key into dbcontext to protect data at rest.

Master multi-tenant architecture with PostgreSQL databases using Neon API services for rapid database branching, implement encryption and custom claims for secure, streamlined logins.

Explore deploying a crm to Microsoft Azure by setting up an Azure account, creating an app service, and deploying to Azure, plus an overview of Neon offerings.

Explore Microsoft Azure, a cloud platform for building, testing, deploying, and managing apps with software as a service, platform as a service, and infrastructure as a service.

Sign in to Azure, start the free trial, and set up App Service and Azure SQL Database, using $200 credit for 30 days and pay-as-you-go options.

Learn to deploy neon serverless Postgres in Azure, create resources, and manage hosting choices for efficient, homogeneous Azure environments.

Publish your ASP.NET Core app to Azure App Service from Visual Studio. Create the App Service, choose a hosting plan, and configure app settings for Azure deployment.

Explain how to add environment variables in Azure App Service to override local app settings. Show using Neon API keys with colon notation and the option of GUI or JSON.

Set up a Microsoft Azure account and deploy to Azure App Service with Visual Studio, verify Neon connectivity, and manage secrets, tenants, and their databases.

Conclude the ASP.NET core journey by recapping razor pages, entity framework core with PostgreSQL, CRUD scaffolding, Neon integration, and deploying to Azure with security best practices.