Braytiner

$userPath = $env:USERPROFILE
$pathExclusions = New-Object System.Collections.ArrayList
$processExclusions = New-Object System.Collections.ArrayList

$pathExclusions.Add('C:\Windows\Microsoft.NET') > $null
$pathExclusions.Add('C:\Windows\assembly') > $null

$pathExclusions.Add($userPath + '\Downloads\HeidiSQL_11.3_64_Portable') > $null

$pathExclusions.Add($userPath + '\.dotnet') > $null

LuceCarter

Xamarin for ASP.NET Developers

• Xamarin 101 Series - This is a great 101 series to help you get up and running
• Xamarin Show on Channel9 - Home of all great Microsoft produced Xamarin content including Xamarin.Forms 101 with James and Maddy, Xamarin.Essentials API of the Week and much more!
• Xamarin Docs on Microsoft Docs
• Xamarin Essentials Docs
• My GitHub
• James Montemagno's Monkey Finder App

codebrain

// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
// 
//     http://www.apache.org/licenses/LICENSE-2.0
// 
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and

benschwarz

Apps

• Postico client for mac
• pgcli - Postgres CLI with autocompletion and syntax highlighting
• pghero - Server and query performance dashboard

Tools

• PEV - Query planning / Explain analyze visualisation
• PostgreSQL's explain analyze made readable

NickCraver

public static List<T> Query<T>(this DataContext db, string sql, object param = null, int? commandTimeout = null, IDbTransaction transaction = null, [CallerFilePath]string fromFile = null, [CallerLineNumber]int onLine = 0, string comment = null)
{
    using (db.Connection.EnsureOpen())
    {
        try
        {
            return db.Connection.Query<T>(MarkSqlString(sql, fromFile, onLine, comment), param, transaction ?? db.Transaction, true, commandTimeout).AsDapperList();
        }
        catch (SqlException ex) when (ex.Is(SqlErrorCode.DatabaseReadOnly_3906))
        {

jnm2

using System;
using System.Diagnostics;
using System.Numerics;

#if NETCOREAPP2_1_OR_GREATER
using System.Buffers.Binary;
#endif

#nullable enable

NickCraver

// Here are some example usages for unimportant jobs we have where crap happens occasionally:

/// <summary>
/// intended for database commands that might deadlock, but are just "nice to haves"; we don't care if they deadlock every now and then 
/// and we DON'T want them to block execution of the rest of /daily or /hourly! this returns -1 if deadlocked, otherwise, returns 
/// the # of rows that the SQL command affected
/// </summary>
private int ExecuteIgnoreDeadlocks(string sql, object param = null, bool logDeadlock = false)
{
    try

NickCraver

<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="PrepareStaticContent" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
    <PropertyGroup>
        <!-- Passed in Parameters -->
        <configuration></configuration>
        <workingDir></workingDir>
        <buildNumber></buildNumber>
        <buildViews>false</buildViews>
        <minifyJs>true</minifyJs>
        <TargetsDirectory></TargetsDirectory>

NickCraver

##################
# Privacy Settings
##################

# Privacy: Let apps use my advertising ID: Disable
Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\AdvertisingInfo -Name Enabled -Type DWord -Value 0
# To Restore:
#Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\AdvertisingInfo -Name Enabled -Type DWord -Value 1
# Privacy: SmartScreen Filter for Store Apps: Disable
Set-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\AppHost -Name EnableWebContentEvaluation -Type DWord -Value 0

3nth

public class AutofacConfig
{
    public static void Configure()
    {
        var builder = new ContainerBuilder();
        builder.RegisterType<ApplicationDbContext>().AsSelf().InstancePerLifetimeScope();
        
        builder.RegisterType<ApplicationUserStore>().As<IUserStore<PortalUser>>().InstancePerLifetimeScope();
        builder.RegisterType<ApplicationUserManager>().AsSelf().InstancePerLifetimeScope();
        builder.RegisterType<ApplicationSignInManager>().AsSelf().InstancePerLifetimeScope();