aaronhoffman

var stateCodes = new Dictionary<string, string>()
{
  {"AL", "ALABAMA"},
  {"AK", "ALASKA"},
  {"AZ", "ARIZONA"},
  {"AR", "ARKANSAS"},
  {"CA", "CALIFORNIA"},
  {"CO", "COLORADO"},
  {"CT", "CONNECTICUT"},
  {"DE", "DELAWARE"},

aaronhoffman

using MyProject.Models;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;

namespace MyProject.Data
{
    public class MyContext : DbContext
    {
        public MyContext(string connectionString)
            : base(connectionString)

aaronhoffman

#!/bin/bash  
# generate file containing all URIs to execute to retrieve data from hacker news firebase API
# api docs: https://github.com/HackerNews/API

echo generating file hn-uri.txt

URICOUNT=10000000

echo file will contain $URICOUNT lines

aaronhoffman

using System.Collections.Generic;
using System.Linq;

public static class EnumerableExtensions
{
    public static IEnumerable<IEnumerable<T>> Batch<T>(this IEnumerable<T> items, int batchSize)
    {
        return items
            .Select((item, inx) => new { item, inx })
            .GroupBy(x => x.inx / batchSize)

aaronhoffman

private static readonly DateTime _epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
public DateTime EpochSecondsToDateTime(int secondsSinceEpoch)
{
    return _epoch.AddSeconds(secondsSinceEpoch);
}

aaronhoffman

-- SQL Query to search every guid/uniqueidentifier column in a database for the given id

declare @Id uniqueidentifier = 'ED4D0741-B092-4F0A-9E10-51C19265357C'
-- set to 1 to only search within columns that have '%id%' in the name, for all columns of uniqueidentifier type, set to 0
declare @onlyColumnsWithIdInName bit = 1

declare @Columns table (TableName varchar(200), ColumnName varchar(200))

insert into @Columns (TableName, ColumnName)
select

aaronhoffman

aaronhoffman

aaronhoffman

public class KuduWebJobService
{
    private string KuduUserName { get; set; }
    private string KuduPassword { get; set; }
    private string AzureWebsiteName { get; set; }

    public KuduWebJobService()
    {
        this.KuduUserName = "";
        this.KuduPassword = "";

aaronhoffman

Keybase proof

I hereby claim:

• I am aaronhoffman on github.
• I am aaronhoffman (https://keybase.io/aaronhoffman) on keybase.
• I have a public key whose fingerprint is CA49 A892 C3FF 3F8B 95B4 8309 B693 4228 86D5 7E4F

To claim this, I am signing this object: