| description | tools | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Guidelines for generating SQL statements and stored procedures |
|
- all tables should have a primary key constraint
- all foreign key constraints should have a name
- all foreign key constraints should be defined inline
| description | tools | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Guidelines for generating SQL statements and stored procedures |
|
| # Debug support provided by common PowerShell function parameters, which is natively aliased as -d or -db | |
| # https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_commonparameters?view=powershell-7.4#-debug | |
| param( | |
| [ValidateSet('gh', 'git', 'shell')] | |
| [Alias('t')] | |
| [String]$Target = 'shell', | |
| [Parameter(Position=0, ValueFromRemainingArguments)] | |
| [string]$Prompt | |
| ) |
This powershell script modifies the Base Image, or the Virtual Hard Disk, which the Windows Sandbox launches upon startup. It will copy the required files to the sandbox and add a registry key which will install them upon startup. By default the script will install the latest stable release of Winget. You can specify to use the latest pre-release with the -PreRelease switch.
When a new version of Winget is released, run this script again to update the installation in the sandbox to the latest version
開啟 Windows PowerShell
將 IE 函式加入到 $PROFILE 之中
[System.IO.Directory]::CreateDirectory([System.IO.Path]::GetDirectoryName($PROFILE))
notepad $PROFILE| public class TimeOnlyConverter : JsonConverter<TimeOnly> | |
| { | |
| private readonly string serializationFormat; | |
| public TimeOnlyConverter() : this(null) { } | |
| public TimeOnlyConverter(string? serializationFormat) | |
| { | |
| this.serializationFormat = serializationFormat ?? "HH:mm:ss.fff"; | |
| } |
| public class DynamicJsonConverter : JsonConverter<dynamic> | |
| { | |
| public override dynamic Read(ref Utf8JsonReader reader, Type typeToConvert, JsonSerializerOptions options) | |
| { | |
| if (reader.TokenType == JsonTokenType.True) | |
| { | |
| return true; | |
| } |
| public class DateOnlyConverter : JsonConverter<DateOnly> | |
| { | |
| private readonly string serializationFormat; | |
| public DateOnlyConverter() : this(null) { } | |
| public DateOnlyConverter(string? serializationFormat) | |
| { | |
| this.serializationFormat = serializationFormat ?? "yyyy-MM-dd"; | |
| } |
| using Serilog; | |
| using Serilog.Events; | |
| var builder = WebApplication.CreateBuilder(args); | |
| Log.Logger = new LoggerConfiguration() | |
| .ReadFrom.Configuration(builder.Configuration) | |
| .CreateLogger(); | |
| try |