Michael Gant JohnMGant

Full-stack developer, founder and Principal Consultant of ClearEye Consulting.

JohnMGant / Spaghetti.asp

Last active August 1, 2019 13:22

Example of classic ASP spaghetti code

	<html>
	<body>
	<table>
	<%
	set conn=Server.CreateObject("ADODB.Connection")
	conn.Provider="Microsoft SQL Server"
	conn.Open "Server=SQLPROD;Database=HR;UserID=SuperDuperAdmin;Password=ABC123!!!"
	set rs=Server.CreateObject("ADODB.recordset")
	sql="SELECT ID, Name, FavoriteColor " &
	"FROM Employees " &

JohnMGant / ormexamples.cs

Created August 1, 2019 14:04

ORM examples

	internal IEnumerable<Employee> GetEmployees1(string lastName) {
	var query =
	from emp in context.Employee
	where emp.LastName.StartsWith(lastName)
	orderby emp.LastName, emp.FirstName
	select new Employee {
	Id = emp.Id,
	Name = emp.FirstName + ' ' + emp.LastName,
	FavoriteColor = emp.FavoriteColor ?? "Green"
	};

JohnMGant / ormexamples.sql

Last active August 1, 2019 20:12

SQL for ORM Examples

	select Id, FirstName + ' ' + LastName as Name, coalesce(FavoriteColor, 'Green') as FavoriteColor
	from Employees
	where LastName like '[whatever you passed in]%'
	order by LastName, FirstName

JohnMGant / ForLoopAdder.cs

Last active June 26, 2020 20:04

Adds an array of integers using a for loop

	internal class ForLoopAdder : IIntegerAdder
	{
	public int Add(int[] values)
	{
	int sum = 0;
	int count = values.Length;
	for (int i = 0; i < count; i++)
	{
	int value = values[i];
	sum += value;

JohnMGant / GotoAdder.cs

Last active December 16, 2020 22:38

Adds an array of integers using goto (don't do this!)

	internal class GotoAdder : IIntegerAdder
	{
	public int Add(int[] values)
	{
	int sum = 0;
	int count = values.Length;
	int index = 0;
	BEGIN:
	if (index == count) goto RETURN;
	int value = values[index++];

JohnMGant / ArrayPointerAdder.cs

Last active June 26, 2020 20:02

Adds an array of integers using a point (don't do this!)

	internal unsafe class ArrayPointerAdder : IIntegerAdder
	{
	public int Add(int[] values)
	{
	int sum = 0;
	int count = values.Length;
	fixed (int *p = values)
	{
	for (int i = 0; i < count; i++)
	{

JohnMGant / ForEachLoopAdder.cs

Created July 17, 2020 19:45

	internal class ForEachLoopAdder : IIntegerAdder
	{
	public int Add(int[] values)
	{
	int sum = 0;
	foreach (var value in values)
	{
	sum += value;
	}
	return sum;

JohnMGant / EnumeratorAdder.cs

Created July 17, 2020 20:08

	internal class EnumeratorAdder : IIntegerAdder
	{
	public int Add(int[] values)
	{
	IEnumerator<int> enumerator = values.AsEnumerable().GetEnumerator();
	int sum = 0;
	while (enumerator.MoveNext())
	{
	sum += enumerator.Current;
	}

JohnMGant / JokeAboutMice.cs

Last active July 17, 2020 21:48

	static void Main() {
	foreach (var line in TellJokeAboutMice())
	{
	Console.WriteLine(line);
	}
	}

	private static IEnumerable<string> TellJokeAboutMice()
	{
	yield return "MR MICE.";

JohnMGant / AddArrayForLoop.js

Last active August 7, 2020 17:35

Adding an array of numbers in JavaScript using for loop