Posts tagged "MSSQL"

Published: August 19 2023

Deploy .NET 6 API to AWS Lambda with SQL Database (RDS) and Email (SES)

Detailed instructions on how to setup an AWS VPC from scratch then deploy a .NET 6 API to AWS Lambda with a SQL Database on AWS RDS (Relational Database Service) and Email via AWS SES (Amazon Simple Email Service).
Published: February 15 2023

SqlClient.SqlException - The certificate chain was issued by an authority that is not trusted

How to fix this SSL connection error when connecting to SQL Server from ASP.NET Core
Published: February 15 2023

.NET 7.0 + Dapper - Connect to MS SQL Server Database in ASP.NET Core

How to connect to a SQL Server database in ASP.NET Core with Dapper and ADO.NET
Published: February 14 2023
Last updated: April 13 2023

.NET 7.0 + Dapper + MS SQL Server - CRUD API Tutorial in ASP.NET Core

How to build a .NET 7.0 CRUD API with Dapper and a SQL Server database.
Published: February 14 2023

Dapper + SQL Server - Create database if it doesn't exist on startup in ASP.NET Core

How to auto create a database and tables in SQL Server with ASP.NET Core and Dapper
Published: July 01 2022

Node.js + MS SQL Server - Simple API for Authentication, Registration and User Management

Simple Node.js + MS SQL Server API that supports User Registration, Login and User Management. Includes example front end apps in React, Angular and Vue.
Published: June 30 2022

Node + MSSQL - Auto Create/Update SQL Server Database with Sequelize and Tedious

A quick post to show how to automatically create and update (sync) a SQL Server database on app startup using Sequelize and Tedious
Published: June 20 2022

Node.js + MSSQL - Connect to SQL Server with Sequelize & Tedious

How to connect from Node.js to MS SQL Server using Sequelize & Tedious, and automatically create/update the SQL Server database from code.
Published: June 18 2022

Node.js + MS SQL Server - CRUD API Example and Tutorial

Tutorial on how to build a simple Node.js + MS SQL Server API that supports CRUD operations. Includes example front end apps in React and Angular.
Published: March 18 2022

.NET 6.0 - Connect to SQL Server with Entity Framework Core

This post shows goes through the steps to connect a .NET 6 API to SQL Server using Entity Framework Core, and automatically create/update the SQL Server database from code using EF Core migrations.
Published: January 31 2022

.NET 6.0 - Database Migrations to Different DB Per Environment (SQLite in Dev, SQL Server in Prod)

An example of how to setup a .NET 6.0 project with Entity Framework Migrations that supports multiple different database providers.
Published: October 21 2021

.NET 5.0 - Connect to SQL Server with Entity Framework Core

In this post we'll go through the steps to connect a .NET API to SQL Server using Entity Framework Core, and to create a SQL Server database from code using EF Core migrations.
Published: June 03 2021

.NET 5.0 - Entity Framework Migrations for Multiple Databases (SQLite and SQL Server)

An example of how to setup a .NET 5.0 project with Entity Framework Migrations that supports multiple different database providers.
Published: May 10 2021
Last updated: June 14 2021

.NET Core 3.1 + AWS Lambda - Deploy a .NET Core API and SQL Server DB to Lambda and RDS

How to setup an AWS environment from scratch and deploy a .NET Core 3.1 API to AWS Lambda that connects to a SQL Server database running on AWS RDS (Relational Database Service) and sends email using AWS SES (Amazon Simple Email Service).
Published: January 11 2020

Vue.js + ASP.NET Core on Azure with SQL Server - How to Deploy a Full Stack App to Microsoft Azure

In this deployment tutorial we're going to setup a new production ready Windows 2019 web server on Microsoft Azure with IIS (Internet Information Services), then deploy a full stack Vue.js + ASP.NET Core + SQL Server application to it that supports user registration and JWT authentication.
Published: January 10 2020

React + ASP.NET Core on Azure with SQL Server - How to Deploy a Full Stack App to Microsoft Azure

In this deployment tutorial we're going to setup a production ready Windows + IIS server from scratch on Microsoft Azure, then deploy a full stack React + ASP.NET Core + SQL Server application to it that supports user registration and JWT authentication.
Published: January 03 2020
Last updated: June 04 2020

ASP.NET Core - EF Core Migrations for Multiple Databases (SQLite and SQL Server)

An example of how to setup an ASP.NET Core project with EF Core Migrations that support multiple different database providers.
Supported by