Nico Sap NicoJuicy

Full stack .Net / Node js / ... Dev @ Genetec Belgium Custom dev / websites / shops @ www.sapico.me ECommerce @ www.blindevis.be

davidfowl / FromSqlInterpolatedStringHandler.cs

Last active August 7, 2025 16:09

Implementation of parameterized sql queries using string interpolation handlers

	using System.Data.Common;
	using System.Runtime.CompilerServices;
	using System.Text;
	using Npgsql;

	GetCatalogItemsSql(null, null, null, 10);

	void GetCatalogItemsSql(int? catalogBrandId, int? before, int? after, int pageSize)
	{
	// This looks like it would be susceptible to SQL injection, but it's not.

davepcallan / StackOverflowCloneInsertData.sql

Created August 16, 2023 13:22

Create schema and insert dummy data into Stack Overflow clone

	-- Create StackOverflow-like Database
	CREATE DATABASE StackOverflowClone

	GO

	USE StackOverflowClone

	GO

	-- Users table