kmoormann

node.Epic { diameter: 60px; color: #FF0000; border-color: #CC0000; border-width: 2px; text-color-internal: #FFFFFF; caption: '{name}'; font-size: 12px; } node.Feature { diameter: 50px; color: #0000FF; border-color: #0000CC; border-width: 2px; text-color-internal: #FFFFFF; caption: '{name}'; font-size: 10px; } node.Story { diameter: 40px; color: #00FF00; border-color: #00CC00; border-width: 2px; text-color-internal: #000000; caption: '{name}'; font-size: 8px; } node.Application { diameter: 50px; color: #800080; border-color: #4B0082; border-width: 2px; text-color-internal: #FFFFFF; caption: '{name}'; font-size: 10px; } relationship.HAS_FEATURE { color: #0000FF; shaft-width: 2px; font-size: 8px; text-color: #000000; caption: '{type}'; } relationship.HAS_STORY { color: #00FF00; shaft-width: 2px; font-size: 8px; text-color: #000000; caption: '{type}'; } relationship.USED_IN_APPLICATION { color: #800080; shaft-width: 2px; font-size: 8px; text-color: #000000; caption: '{type}'; style: dashed; } relationship.BLOCKS 

kmoormann

using System.Collections.Generic;
using System.Linq;
using AutoMapper;
using AutoMapper.QueryableExtensions;
using FluentAssertions;
using NUnit.Framework;

namespace Automapper.PolymorphicList.Tests
{
    [TestFixture]

kmoormann

DECLARE @tableName VARCHAR(50) = 'Foo'

SELECT 
	'public '
	+ CASE 
		WHEN DATA_TYPE = 'int' THEN 'int'
		WHEN DATA_TYPE = 'uniqueidentifier' THEN 'Guid'
		WHEN DATA_TYPE = 'nvarchar' THEN 'string'
		WHEN DATA_TYPE = 'datetime' THEN 'DateTime'
		WHEN DATA_TYPE = 'bit' THEN 'bool'

kmoormann

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;

namespace Inventory.Data {

kmoormann

public override bool Equals(object obj)
{
  return this.Equals(obj as IAggregate);
}

public virtual bool Equals(IAggregate other)
{
  return null != other && other.Id == this.Id;
}

kmoormann

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace Inventory.Web.Code.Extensions
{
	public enum SelectListItemEnumValueOption
	{

kmoormann

DECLARE @InsertDate DATETIME2 
SET @InsertDate = GETDATE()

DECLARE @InsertDateString NVARCHAR(24) 
SET @InsertDateString =
	CAST(YEAR(@InsertDate) AS NVARCHAR(4)) 
	+ '-'
	+ CASE 
		WHEN MONTH(@InsertDate) < 10 THEN '0'
		ELSE ''

kmoormann

open System.IO
let lines path =
    System.IO.File.ReadAllLines(path)

let writeFile lines path =
    System.IO.File.Delete(path)
    System.IO.File.AppendAllLines(path, lines)

let replaceNulls path =
    let origFileNameAndExtension = System.IO.Path.GetFileName(path)

kmoormann

--USE <REPLACE WITH DATABASE NAME>

CREATE TABLE #tablesOfInterest (TableName VARCHAR(2000))
INSERT INTO #tablesOfInterest 
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME 
  IN ('table1'
		,'table2'
		)

kmoormann

USE <REPLACE WITH DATABASE NAME>

SELECT   
	foreignKeyConstraintObject.Name as ForeignKeyConstraint
	,foreignKeySchema.Name as ForeignKeySchema
	,foreignKeyTable.Name as ForeignKeyTable
	,foreignKeyColumn.Name as FoeignKeyName
	,referencedSchema.Name as ReferencedSchema
	,referencedTable.Name as ReferencedTable
	,referencedColumn.Name as ReferencedColumn