Skip to content

Instantly share code, notes, and snippets.

@segilbert
segilbert / complus_remove_apps
Created Jan 20, 2012
Remove COM+ Applications Pro-grammatically from COM+ Services
View complus_remove_apps
On Error Resume Next
For Each objItem in colItems
' Create an instance of COMAdmin Catalog
set cat = CreateObject( "COMAdmin.COMAdminCatalog" )
' Reference the Applications Collection
Set apps = cat.GetCollection("Applications")
' Retrieve the data
apps.Populate
@segilbert
segilbert / IdeaStrikeSpecBase.cs
Created Apr 5, 2012
IdeaStrike Test Project Nancy Autofac Bootstrapper
View IdeaStrikeSpecBase.cs
//
using System;
using System.Collections.ObjectModel;
using System.Linq;
using System.Linq.Expressions;
using System.Drawing;
using System.IO;
using System.Drawing.Imaging;
//
using Ideastrike;
@segilbert
segilbert / CxServices.asmx
Created Apr 18, 2012
Quiz Question: How do I use webMethod to call GetMessages?
View CxServices.asmx
[WebMethod(true)]
public string GetMessages(string psUserId)
{
List<JxMessage> messages = new List<JxMessage>();
// .... do some logic like get the message list
// Send it back as JSON
return CxJSONHelper.Serialize(messages);
}
View TestHelper.cs
public static class TestHelpers
{
public static void ShouldEqualWithDiff(this string actualValue, string expectedValue)
{
ShouldEqualWithDiff(actualValue, expectedValue, StringComparison.Ordinal, DiffStyle.Full, Console.Out, string.Empty);
}
public static void ShouldEqualWithDiff(this string actualValue, string expectedValue, string message)
{
ShouldEqualWithDiff(actualValue, expectedValue, StringComparison.Ordinal, DiffStyle.Full, Console.Out, message);
@segilbert
segilbert / After
Last active Dec 14, 2015
Tell me what is wrong with this unit test? Hint ... Fails with expect count of 5 but count = 8.
View After
public void CanExecuteNonQueryWithCommandTextWithDefinedTypeAndTransaction()
{
// Arrange
int countBefore = Convert.ToInt32(db.ExecuteScalar(countCommand));
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction trans = connection.BeginTransaction())
{
@segilbert
segilbert / 0.ReadMe.md
Last active Feb 12, 2017
Ever wanted or had the need to create a version of the MS Northwind SQL Server Database on Oracle? If you are working with EntLib code base and want to run the unit tests then you know what I'm taking about. Please see the readMe.md for additional details.
View 0.ReadMe.md

MS Northwind for Oracle

Summary

Ever wanted or had the need to create a version of the MS Northwind SQL Server Database on Oracle? If you are working with EntLib code base and want to run the unit tests then you know what I'm taking about. The scrips below will create Northwind in an Oracle database.

Scripts: ( order required to be run )

  1. northwind.oracle.schema.sql
  2. northwind.oracle.tables.views..sql
  3. northwind.oracle.packages.sql
  4. northwind.oracle.sps.sql
@segilbert
segilbert / CSharp_custom.fit
Created Mar 19, 2013
Simple C# custom WinMerge filter.
View CSharp_custom.fit
## This is a directory/file filter template for WinMerge
name: CSharp Custom Filter
desc: Filter out bin dir and project files
## Select if filter is inclusive or exclusive
## Inclusive (loose) filter lets through all items not matching rules
## Exclusive filter lets through only items that match to rule
## include or exclude
def: include
@segilbert
segilbert / getPublicKeyToken.cmd
Last active Dec 15, 2015
Obtains the public key token from a strong key or dll.
View getPublicKeyToken.cmd
@ECHO off
REM
REM http://msdn.microsoft.com/en-us/library/k5b5tt23(v=vs.80).aspx
REM http://stackoverflow.com/questions/659647/how-to-get-folder-path-from-file-path-with-cmd
REM
SET SnkFilePath=%1
SET FileExt=%~x1
REM ECHO %FileExt%
@segilbert
segilbert / confluence.mailto.macro
Last active Dec 19, 2015
Confluence mailto macro from James Mortimer. Tweaked to remove <br/> from the body before sending to mailto body section to display properly. [Confluence Mailto Macro](https://confluence.atlassian.com/display/DISC/Mailto+User+Macro)
View confluence.mailto.macro
## Check parameters
#if($paramemail && $paramemail.length()>0)
#set($email=$paramemail)
#else
#if($param0 && $param0.length()>0)
#set($email=$param0)
#else
#set($email="first_last@domain.com")
#end
#end
@segilbert
segilbert / gist:10435316
Created Apr 11, 2014
XUnit AAA Resharper Template
View gist:10435316
[Fact]
public void $Method$_$Scenario$_$Expected$()
{
// Arrange
$END$
// Act
// Assert
}