bricelam

Since I always forget, here's the best way I've found to do it.

dotnet tool update -g OpenVsixSignTool
SET DOTNET_ROLL_FORWARD=LatestMajor
OpenVsixSignTool sign --sha1 f4d452b501c18a23e8eed7fa67c7510fa0f9bccb --timestamp http://time.certum.pl VisualStudio.Data.Sqlite.vsix

bricelam

<Configuration>
  <vGPU>Enable</vGPU>
  <Networking>Disable</Networking>
  <MappedFolders>
    <MappedFolder>
      <HostFolder>%USERPROFILE%\Downloads</HostFolder>
      <SandboxFolder>C:\Users\WDAGUtilityAccount\Downloads</SandboxFolder>
    </MappedFolder>
  </MappedFolders>
  <LogonCommand>

bricelam

using System.Diagnostics;
using System.Text.RegularExpressions;
using System.Xml.Linq;
using Octokit.GraphQL;
using Octokit.GraphQL.Model;

var disqus = XElement.Load("disqus-export.xml");
var ns = disqus.GetDefaultNamespace();
var dsq = disqus.GetNamespaceOfPrefix("dsq")!;
var threads = new Dictionary<long, Thread>();

bricelam

[Settings]
ShowToolbar=false
WordWrap=false
TabsAsSpaces=true
AutoCloseTags=true
HighlightCurrentLine=2
MarkLongLines=true
LongLinesLimit=140
PathNameFormat=0
[Settings2]

bricelam

{
    "defaultProfile": "{cd6f40e9-9cd5-405e-8113-b66b820b2b13}",
    "profiles": [
        {
            "guid": "{cd6f40e9-9cd5-405e-8113-b66b820b2b13}",
            "name": "Developer Command Prompt",
            "commandline": "%comspec% /k \"C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\Preview\\Common7\\Tools\\VsDevCmd.bat\"",
            "startingDirectory": "C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\Preview\\",
            "icon": "ms-appx:///ProfileIcons/{0caa0dad-35be-5f56-a8ff-afceeeaa6101}.png",
            "useAcrylic": true,

bricelam

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>netcoreapp3.0</TargetFramework>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="Dapper" Version="2.0.4" />
    <PackageReference Include="NetTopologySuite.IO.SqlServerBytes" Version="2.0.0" />

bricelam

{
    "workbench.colorTheme": "Default Light+",
    "editor.formatOnSave": true,
    "files.autoSave": "afterDelay",
    "files.trimTrailingWhitespace": true,
    "files.insertFinalNewline": true,
    "editor.codeLens": false,
    "editor.rulers": [
        120
    ],

bricelam

1. docker pull container-registry.oracle.com/database/standard
2. docker run --name oracle -d -p 1521:1521 -p 5500:5500 --shm-size 4g container-registry.oracle.com/database/standard
3. docker exec -it oracle /bin/bash
4. Wait for DB setup to complete. Check progress with tail -f /home/oracle/setup/log/setupDB.log (Ctrl+C to exit)
5. su - oracle
6. sqlplus / as sysdba
7. ALTER PLUGGABLE DATABASE PDB1 CLOSE;
8. DROP PLUGGABLE DATABASE PDB1 INCLUDING DATAFILES;
9. Continue with README
10. Change DataSource in OracleTestStore.CreateConnectionString() to "//localhost:1521/ef.localdomain"

bricelam

using System.Collections;
using System.IO;
using System.Linq;
using System.Resources;

class Program
{
    static void Main(string[] args)
    {
        var reader = ResXResourceReader.FromFileContents(File.ReadAllText(args[0]));

bricelam

<VSTemplate xmlns="http://schemas.microsoft.com/developer/vstemplate/2005"
            xmlns:sdk="http://schemas.microsoft.com/developer/vstemplate-sdkextension/2010">
  <WizardExtension>
    <Assembly>NuGet.VisualStudio.Interop, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</Assembly>
    <FullClassName>NuGet.VisualStudio.TemplateWizard</FullClassName>
  </WizardExtension>
  <WizardData>
    <packages repository="template">
      <package id="EntityFramework" version="6.1.3" />
    </packages>