What’s this? #

Just coding snippets

General #

Regular Expressions #

Search and replace example #

Search and replace for insert statements given tab delimited content:

10001	Foo	Bar
10002	Baz	Zeb
10003	Bender	bends

Search: ^([^\t]+)\t([^\t]+)\t([^\t]+)$

Replace: \('$1', '$2', '$3'\),

Output #

('10001', 'Foo', 'Bar'),
('10002', 'Baz', 'Zeb'),
('10003', 'Bender', 'bends'),

Git #

The command line tool is the most cross compatible. Reminders:

git clean -xfdn | more - Dry run clean - useful for clearing out bin folders.`

git diff / git difftool -- */*.yml - Use chart for parameters to use.

source

git pull origin develop:develop - Updates the target branch without having to checking it out.

git log --pretty=oneline - Show commits.

git rebase origin/develop - Update the current branch with latest from develop.

git fetch --prune - remove branches that no longer exist on the remote.

Languages #

C# #

Migrating .NET Framework to .NET Core+ #

• Convert existing library projects to .NET Standard 2.0
• For error Could not load file or assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified. - replace GAC reference with nuget package System.ServiceModel.Primitives.
• For .NET standard projects that reference nuget packages sometimes the <CopyLocalLockFileAssemblies>true</CopyLocalLockFileAssemblies> is needed for transitive packages to be copied to output. Happened for test projects.

Using Entity Framework 6 with .NET Core+ #

• The project containing the EF Context and migrations should target both .NET Standard 2.1 and .NET Framework and use conditional references when necessary.
  • <TargetFrameworks>net472;netstandard2.1</TargetFrameworks>
  • <PackageReference Include="AutoMapper" Version="12.0.1" Condition="'$(TargetFramework)' == 'netstandard2.1'" />
• Create an empty console project using .NET Framework that references your EF project. This can be used to execute the EF migrations commands.

add-migration <MigrationName> -configuration XXXXX -StartUpProjectName EFConsole -Verbose

MSBuild for .NET4.x web project #

This can be helpful for creating an automated build. This SO post helped me: https://stackoverflow.com/a/20982171

msbuild xxx.sln /t:Restore /p:RestorePackagesConfig=true

msbuild xxx.sln /t:Build /p:Configuration="Release" /p:Platform="Any CPU" 

// note slnfloder\ is optional. My_WebApi is name of web project.
// publish to a folder instead of creating a zip package.
msbuild xxx.sln /t:slnfolder\My_WebApi:WebPublish /p:PublishUrl="C:\temp\published" /p:WebPublishMethod=FileSystem /p:Configuration="Release" /p:Platform="Any CPU"