Skip to content

Instantly share code, notes, and snippets.

View pwelter34's full-sized avatar

Paul Welter pwelter34

View GitHub Profile
@pwelter34
pwelter34 / ConcurrencyToken.cs
Last active November 28, 2022 14:50
ConcurrencyToken
public readonly struct ConcurrencyToken : IEquatable<ConcurrencyToken>
{
public static readonly ConcurrencyToken None = new(Array.Empty<byte>());
public byte[] Value { get; }
public ConcurrencyToken(byte[] value)
{
Value = value ?? Array.Empty<byte>();
}
@pwelter34
pwelter34 / Program.cs
Last active December 14, 2021 03:27
Serilog with azure
public static class Program
{
public static int Main(string[] args)
{
// azure home directory
var homeDirectory = Environment.GetEnvironmentVariable("HOME") ?? ".";
Log.Logger = new LoggerConfiguration()
.MinimumLevel.Verbose()
.MinimumLevel.Override("Microsoft", LogEventLevel.Information)
@pwelter34
pwelter34 / HostDebuggerMiddleware.cs
Last active December 1, 2021 16:10
Middleware to debug configuration and routes
using System.Text;
using System.Text.Json;
using Microsoft.AspNetCore.Mvc.Infrastructure;
namespace Demo.Middleware;
public class HostDebuggerOptions
{
public string RouteDebuggerPath { get; set; } = "/route-debugger";
@pwelter34
pwelter34 / setup.sh
Created November 10, 2021 06:49
Test Internet Speed using Speedtest-cli from Alpine OS Docker Image
apk add --no-cache python3 py3-pip
wget -O speedtest-cli https://raw.githubusercontent.com/sivel/speedtest-cli/master/speedtest.py
chmod +x speedtest-cli
python3 speedtest-cli
@pwelter34
pwelter34 / azure-pipelines.yml
Created October 29, 2021 17:16
Standard web project with database
trigger:
- main
- develop
- releases/*
variables:
major: 1
minor: 0
name: $(major).$(minor).$(Rev:r)
@pwelter34
pwelter34 / AssemblyMetadata.cs
Last active August 9, 2023 19:06
Assembly Metadata
public static class AssemblyMetadata
{
private static readonly Lazy<string> _fileVersion = new(() =>
{
var assembly = typeof(AssemblyMetadata).Assembly;
var attribute = assembly.GetCustomAttribute<AssemblyFileVersionAttribute>();
return attribute?.Version;
});
private static readonly Lazy<string> _assemblyVersion = new(() =>
@pwelter34
pwelter34 / SelectTree.sql
Created October 11, 2021 15:00
Select Tree
CREATE PROCEDURE [dbo].[ClientHierarchy]
@clientId UNIQUEIDENTIFIER
AS
DECLARE @root UNIQUEIDENTIFIER;
-- step 1, find hightest node
WITH ParentCTE (Id, ParentClientId) AS
(
@pwelter34
pwelter34 / .editorconfig.yaml
Last active December 29, 2022 23:41
Basic editor config for markdown
# EditorConfig is awesome: https://EditorConfig.org
root = true
# All Files
[*]
charset = utf-8
indent_style = space
indent_size = 4
insert_final_newline = true
@pwelter34
pwelter34 / ColumnSearch.sql
Created April 29, 2021 14:43
SQL Server Schema Search
DECLARE @tableName NVARCHAR(256)
DECLARE @tableSchema NVARCHAR(100)
DECLARE @columnName NVARCHAR(256)
SET @tableName = '%CaseManager%'
SET @tableSchema = 'dbo'
SET @columnName = '%%'
SELECT *
FROM INFORMATION_SCHEMA.Columns
@pwelter34
pwelter34 / GitVersion.yml
Created April 25, 2021 16:49
GitVersion.yml
mode: ContinuousDelivery
next-version: 1.0.0
branches:
main:
tag: ''
develop:
tag: beta
feature:
tag: alpha
pull-request: