Things are rarely simple or obvious when working across languages; especially when one is .net.
Rather than waste time here's the code, in its long form.

Test parameters

With a key 182634d8894831d5dbce3b3185c50881
and a message or data value of some random junk
with both solutions we should receive d94ed997943420b7d5dfb9b31ae236b7b5225510d8f0314c54ad44fb5fd44a06

C#

public string HmacSHA256(string key, string data)
{
    string hash;
    ASCIIEncoding encoder = new ASCIIEncoding();
    Byte[] code = encoder.GetBytes(key);
    using (HMACSHA256 hmac = new HMACSHA256(code))
    {
        Byte[] hmBytes = hmac.ComputeHash(encoder.GetBytes(data));
        hash = ToHexString(hmBytes);
    }
    return hash;
}

public static string ToHexString(byte[] array)
{
    StringBuilder hex = new StringBuilder(array.Length * 2);
    foreach (byte b in array)
    {
        hex.AppendFormat("{0:x2}", b);
    }
    return hex.ToString();
}

Which will generate the same value for the same given inputs as:

Python 2.7/3

hmac.new(key.encode('utf-8'), data.encode('utf-8'), hashlib.sha256).hexdigest()

When copying to the local file system I always use the following rsync options:

rsync -aWhv --no-compress --progress /source/ /destinationfolder/

--no-compress as it's on the same machine
--progress speaks for itself

-a preserves ownership & permissions using archive flag    
-W copying whole files only
# and optional ones for watching
-h human-readable transfer rate and file sizes
-v keeps it verbose so we can see whats happening

Leading note: The drive creation is based on using Azure with an Ubuntu 14.04 LTS release. This stuff doesn't change very often but sometimes ubuntu changes the advice and occasionally includes features or options that might not exist in other releases.

Create a Site & A disk (or more)

Ok, this bits all azure based, so hang fire or skip to the next bit if you've done this, or are in some other VM/cloud place or ssh'd into a hardware box.

Partitioning, Formatting and Mounting the drive(s)

You've added the drives, your machines ticking along nicely, so SSH in and let's get going.

Now I usually type sudo su which basically chucks you into root mode; if you're uncomfortable with that just imagine I typed sudo before each command.

First, type blkid

Now before you ATTACH your new drive blkid looks like this

/dev/sr0: LABEL="rd_rdfe_stable.150630-2348" TYPE="udf"
/dev/sda1: LABEL="cloudimg-rootfs" UUID="3156d3f3-c771-498f-89f3-c204d36c46d6" TYPE="ext4"
/dev/sdb1: UUID="ab77eb25-3fe1-401f-a0da-60a45169b168" TYPE="ext4"

sda1 is the system drive, never store anything you want to keep here (other than the configs etc for services).

sdb1 is a temporary drive azure attaches to each machine by default. Usually about 69G and linked to /mnt; the size increases with VM size. You can read about that here http://blogs.msdn.com/b/mast/archive/2013/12/07/understanding-the-temporary-drive-on-windows-azure-virtual-machines.aspx

Typing lshw -C disk will display all the attached disks... this is more accurate as blkid does not tend to pick-up new drives without a reboot or you doing something to alter the state.

After typing lshw -C disk we see (at the bottom of the list)

  *-disk
       description: SCSI Disk
       physical id: 0.0.0
       bus info: scsi@5:0.0.0
       logical name: /dev/sdc
       size: 60GiB (64GB)
       configuration: sectorsize=512

Create a partition

Type fdisk /dev/sdc
Various noise will appear followed by a prompt; hitting m shows you the options.

Command (m for help): m
Command action
   a   toggle a bootable flag
   b   edit bsd disklabel
   c   toggle the dos compatibility flag
   d   delete a partition
   l   list known partition types
   m   print this menu
   n   add a new partition
   o   create a new empty DOS partition table
   p   print the partition table
   q   quit without saving changes
   s   create a new empty Sun Disklabel
   t   change a partition's system id
   u   change display/entry units
   v   verify the partition table
   w   write table to disk and exit
   x   extra functionality (experts only)

We want a new partition; so press n followed by hitting enter.
Then p and hit enter again for a primary partition.
Then assuming you don't want to mess with the defaults hit enter for the following...

• Partition number (1-4, default 1):
• First sector (2048-125829119, default 2048):
• Last sector, +sectors or +size{K,M,G} (2048-125829119, default 125829119):

You'll then be presented with the Command (m for help): prompt again; press w and hit enter to write your changes.

The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

Cool, we've made a partition, now we need to format it.

Type mkfs -t ext4 /dev/sdc1 and hit enter.

mke2fs 1.42.9 (4-Feb-2014)
Discarding device blocks: done
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
3932160 inodes, 15728384 blocks
786419 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
480 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
        4096000, 7962624, 11239424

Allocating group tables: done
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

Now we can mount it; first, create a folder (path) you want to mount to; in this instance, I'll create a folder called data in the root and mount that to sdc1 (our new drive sdc, partition 1).

mkdir /data
mount /dev/sdc1 /data

You can now use this drive by going to the data folder at the root. If you reboot the machine at this point it will unmount the drive. Which takes us to...

Make that mount more permanent with FSTAB

The new ubuntu recommendation is that you use the UUID from this output rather than the path, so that's what's demonstrated here.

We've altered the world and typing blkid will now show us our new goodness.

root@host:/# blkid
/dev/sr0: LABEL="rd_rdfe_stable.150630-2348" TYPE="udf"
/dev/sda1: LABEL="cloudimg-rootfs" UUID="3156d3f3-c771-498f-89f3-c204d36c46d6" TYPE="ext4"
/dev/sdb1: UUID="ab77eb25-3fe1-401f-a0da-60a45169b168" TYPE="ext4"
/dev/sdc1: UUID="cd5aaf52-5483-4f9d-a0d6-836f26c23a09" TYPE="ext4"

_Random tip as well as blkid you can also type ls -l /dev/disk/by-uuid which lists the drives + uuids`

Make sure you enter your own UUID, copy + paste fatigue could kick your arse here

So we want to edit fstab, type nano /etc/fstab to open in nano. You can open in VI if you prefer, or whatever.
The file will look like this...

# CLOUD_IMG: This file was created/modified by the Cloud Image build process
UUID=3156d3f3-c771-498f-89f3-c204d36c46d6       /        ext4   defaults,discard        0 0

# CLOUD_IMG: This file was created/modified by the Cloud Image build process
# The following is used to dynamically configured additional
# NICs. Do not remove unless you know what you are doing.
none /etc/network/interfaces.dynamic.d tmpfs   nodev,noexec,nosuid,size=64K 0 0
/dev/sdb1       /mnt    auto    defaults,nobootwait,comment=cloudconfig 0       2

Add a line at the end like this (but with your UUID)

UUID=cd3aaf52-5483-4f9d-a0d6-836f26c23a09 /data ext4 defaults 0 1

The format of this is pretty simple.

• UUID or you can put /dev/sdb1 format, identifies the drive.
• /data is the mountpoint
• ext4 is the file-system type we specified above when formatting.
• defaults is an option shortcut, so it sets these options rw, suid, dev, exec, auto, nouser, async. You can replace it with any of the [mount-options](http://man7.org/linux/man-pages/man8/mount.8.html#FILESYSTEM-INDEPENDENT_MOUNT OPTIONS) normally available
• dump flag - Enable or disable backing up of the device/partition (the command dump). This field is usually set to 0, which disables it.
• pass order - Controls the order in which fsck checks the device/partition for errors at boot time. The root device should be 1. Other partitions should be 2, or 0 to disable checking.

Save and exit the file... esc then :wq in vim or CTRL+X then enter in nano/pico

Typing umount -a will mount all available drives in fstab, in this case they're all mounted bar our new one so go nuts.

Recovering from failure

Your config is wrong or your external drive is buggered, but you still want your VM to start or you can't really fix it... more so in azure where VM's don't have a console emulator so you can diagnose issues (pay your support bill and watch as they can't tell either). So we need to alter the default settings in fstab for our new drive so we boot regardless of its presence.

This is where the aptly names nofail comes in.

fsck normally does not check whether the device actually exists before calling a file system specific checker. Therefore non-existing devices may cause the system to enter file system repair mode during boot if the filesystem specific checker returns a fatal error. The /etc/fstab mount option nofail may be used to have fsck skip non-existing devices. fsck also skips non-existing devices that have the special file system type auto

References

• https://help.ubuntu.com/community/Fstab
• http://man7.org/linux/man-pages/man5/fstab.5.html
• http://www.eazynet.de/nofail_option_in_etc_fstab
• http://unix.stackexchange.com/questions/53456/what-is-the-difference-between-nobootwait-and-nofail-in-fstab
• http://unix.stackexchange.com/questions/44027/how-to-fix-boot-failure-due-to-incorrect-fstab?rq=1
• [http://man7.org/linux/man-pages/man8/mount.8.html](http://man7.org/linux/man-pages/man8/mount.8.html#FILESYSTEM-INDEPENDENT_MOUNT OPTIONS)

My PC hates hibernating, in fact, it hibernates for a whopping minute then wakes up due to the genius default driver power management settings.

A quick way to find the culprit.
Open command prompt and ask...

C:\Users\Chris>powercfg -lastwake
Wake History Count - 1
Wake History [0]
Wake Source Count - 0

Of course, if it had woke up it would tell you what caused it.
My network card had reset its settings during some update and had decided it should wake my pc up; machine shuts down, router says hey where did you go, machine powers back up.
One check-box and bang, fixed.

Microsoft.Build.Exceptions.InvalidProjectFileException: The imported project "E:\_PROJECTS\x\c\src\Services\Azure\.nuget\nuget.targets" was not found. Confirm that the path in the <Import> declaration is correct, and that the file exists on disk.  E:\_PROJECTS\x\c\src\Services\Azure\x\x.csproj
   at Microsoft.Build.Shared.ProjectErrorUtilities.ThrowInvalidProject(String errorSubCategoryResourceName, IElementLocation elementLocation, String resourceName, Object[] args)
   at Microsoft.Build.Shared.ProjectErrorUtilities.ThrowInvalidProject(IElementLocation elementLocation, String resourceName, Object arg0)
   at Microsoft.Build.Evaluation.Evaluator`4.ExpandAndLoadImports(String directoryOfImportingFile, String importExpressionEscaped, ProjectImportElement importElement)
   at Microsoft.Build.Evaluation.Evaluator`4.EvaluateImportElement(String directoryOfImportingFile, ProjectImportElement importElement)
   at Microsoft.Build.Evaluation.Evaluator`4.PerformDepthFirstPass(ProjectRootElement currentProjectOrImport)
   at Microsoft.Build.Evaluation.Evaluator`4.Evaluate()
   at Microsoft.Build.Evaluation.Evaluator`4.Evaluate(IEvaluatorData`4 data, ProjectRootElement root, ProjectLoadSettings loadSettings, Int32 maxNodeCount, PropertyDictionary`1 environmentProperties, ILoggingService loggingService, IItemFactory`2 itemFactory, IToolsetProvider toolsetProvider, ProjectRootElementCache projectRootElementCache, BuildEventContext buildEventContext, ProjectInstance projectInstanceIfAnyForDebuggerOnly)
   at Microsoft.Build.Evaluation.Project.ReevaluateIfNecessary(ILoggingService loggingServiceForEvaluation)
   at Microsoft.Build.Evaluation.Project.Initialize(IDictionary`2 globalProperties, String toolsVersion, String subToolsetVersion, ProjectLoadSettings loadSettings)
   at Microsoft.Build.Evaluation.Project..ctor(String projectFile, IDictionary`2 globalProperties, String toolsVersion, String subToolsetVersion, ProjectCollection projectCollection, ProjectLoadSettings loadSettings)
   at NuGet.Common.MSBuildProjectSystem.GetProject(String projectFile)
   at NuGet.Commands.UpdateCommand.GetMSBuildProject(String packageReferenceFilePath)
   at NuGet.Commands.UpdateCommand.ExecuteCommand()
   at NuGet.Commands.Command.Execute()
   at NuGet.Program.Main(String[] args)

The issue is depth; the nesting of projects in deeper folders for organisation seems to play havoc with the build file.
Pop open the CSProj file causing the issue,
alter the default path
SolutionDir Condition="$(SolutionDir) == '' Or $(SolutionDir) == '*Undefined*'">..\</SolutionDir> in the cs proj file.

Basically when you nest folders AFTER creating projects you'll need to do this.

Sorted.

Prep essentials

Change versions to latest as required...

• JetBrains version is on this page: https://www.jetbrains.com/teamcity/download/
• Postgres Driver version is on this page: http://jdbc.postgresql.org/_

SSH into your server and let's begin.

Go root, type sudo su.

Cheat mode (skip to : Create a Database Config file for PostGres)
wget https://gist.githubusercontent.com/ChrisMcKee/a45e5cd5d7d9b8f9fa00/raw/2b4a8fea3fcff9e6675e560e908fa785d6ac2697/teamcitysetup.sh && chmod +x teamcitysetup.sh && ./teamcitysetup.sh

apt-get update
apt-get install -y openjdk-7-jre-headless curl mercurial git

Set the Java Path ala this post /neither-the-java_home-nor-the-jre_home-environment-variable-is-defined/

Install TeamCity

Check website for current version and substitute.

wget -c http://download.jetbrains.com/teamcity/TeamCity-8.1.5.tar.gz -O /tmp/TeamCity-8.1.5.tar.gz
tar -xvf /tmp/TeamCity-8.1.5.tar.gz -C /srv
rm -rf /tmp/TeamCity-8.1.5.tar.gz
mkdir /srv/.BuildServer

Create a TeamCity user

useradd -m teamcity
chown -R teamcity /srv/TeamCity
chown -R teamcity /srv/.BuildServer

Create init.d script

wget https://gist.githubusercontent.com/sandcastle/9282638/raw/teamcity-init.sh -O /etc/init.d/teamcity
chmod 775 /etc/init.d/teamcity
update-rc.d teamcity defaults

Download PostGres ODBC driver for TeamCity

mkdir -p /srv/.BuildServer/lib/jdbc
mkdir -p /srv/.BuildServer/config
wget http://jdbc.postgresql.org/download/postgresql-9.3-1102.jdbc41.jar -O /srv/.BuildServer/lib/jdbc/postgresql-9.3-1102.jdbc41.jar

Change ownership of files

sudo chown -R teamcity /srv/TeamCity
sudo chown -R teamcity /srv/.BuildServer

Create a Database Config file for PostGres

Install

apt-get update && apt-get install -y postgresql postgresql-contrib

Open Postgres shell

sudo su - postgres
psql

Enter the following to create the user and teamcity db (note your password you'll need it for the config)

create role `teamcity` with login password 'my-very-secure-password';
create database `teamcity` owner `teamcity`;

Type \q and hit enter to exit PostGres shell.
Then type exit to un-assume the Postgres user, and let's reset postgres aswell (you should still be root at this point, sudo if not) /etc/init.d/postgresql restart

nano /srv/.BuildServer/config/database.properties

Paste this in (or type it, if you're a sadist)

connectionUrl=jdbc:postgresql://127.0.0.1/teamcity
connectionProperties.user=teamcity
connectionProperties.password=my-very-secure-password

Start that stuff up.

/etc/init.d/postgresql start (if its not started)
/etc/init.d/teamcity start

Done

Basic mission; code not my own.

Create an advert type; consisting of URL and Image. Additional requirement created setting the type of advert (using uComponents) An AdvertContainer (Doc Type)

With two 'types' of advert (i.e. 3rdparty/mpu)

ThirdParty contains JS (no image/URL)
MPU contains Image/URL

var nodes = GetMultiNodeSelection(1101, "adverts");

Foists off into some god awful linq abuse…

private IEnumerable<IContent> GetMultiNodeSelection(int id, string property)
{
    var node = _contentService.GetById(id);
    if (node.HasProperty(property))
    {
        var nodeProperty = node.Properties[property];
        var nodeIds = nodeProperty.Value.ToString().Split(',');
        return nodeIds.Select(nodeId => _contentService.GetById(int.Parse(nodeId))).ToList();
    }
    return null;
}

Apparently the between the methods this creates 646,908 hits in 44,111 hidden methods without source?! Most of this crap appears to be between .net and IIS having a bun fight.

Tripped and fell into Umbraco

public IContent GetById(int id)
{
    using (IContentRepository repository = this._repositoryFactory.CreateContentRepository(this._uowProvider.GetUnitOfWork()))
    {
        return repository.Get(id);
    }
}

Feel like a kid on a long journey; are we there yet. I know theres a fucking database in here somewhere.

public TEntity Get(TId id)
{
    Guid guid = (id is int) ? this.ConvertIdToGuid(id) : this.ConvertStringIdToGuid(id.ToString());  -- 41 Hits!? 
    IEntity byId = this._cache.GetById(typeof(TEntity), guid);
    if (byId != null)
    {
        return (TEntity) byId;
    }
    TEntity entity = this.PerformGet(id);
    if (entity != null)
    {
        this._cache.Save(typeof(TEntity), entity);
    }
    return entity;
}

INTO

protected override IContent PerformGet(int id)
{
    Sql sql = this.GetBaseQuery(false).Where(this.GetBaseWhereClause(), new object[] { new { Id = id } })
                .Where<DocumentDto>(x => x.Newest).OrderByDescending<ContentVersionDto>(x => x.VersionDate);
    DocumentDto dto = base.Database.Fetch<DocumentDto, ContentVersionDto, ContentDto, NodeDto>(sql).FirstOrDefault<DocumentDto>();
    if (dto == null)
    {
        return null;
    }
    return this.CreateContentFromDto(dto, dto.ContentVersionDto.VersionId);
}

Getting bored now, how fucking deep is this well

Umbraco.Core.Persistence.Repositories.RepositoryBase<TId,TEntity>.Get(TId id)
private IContent CreateContentFromDto(DocumentDto dto, Guid versionId)
{
    IContentType contentType = this._contentTypeRepository.Get(dto.ContentVersionDto.ContentDto.ContentTypeId);//The slowest bit
    IContent content = new ContentFactory(contentType, this.NodeObjectTypeId, dto.NodeId).BuildEntity(dto);
    if (dto.TemplateId.get_HasValue() && (dto.TemplateId.Value > 0))
    {
        content.Template = this._templateRepository.Get(dto.TemplateId.Value);
    }
    content.Properties = this.GetPropertyCollection(dto.NodeId, versionId, contentType);
    ((ICanBeDirty) content).ResetDirtyProperties();
    return content;
}

erm am I in a fucking hole within a hole here or what

public TEntity Get(TId id) // See above

Ah fun so now were in a different PerformGet

Umbraco.Core.Persistence.Repositories.ContentTypeRepository.PerformGet(int id)
protected override IContentType PerformGet(int id)
{
    Func<DocumentTypeDto, ITemplate> selector = null;
    Sql baseQuery = this.GetBaseQuery(false);
    baseQuery.Where(this.GetBaseWhereClause(), new object[] { new { Id = id } });
    baseQuery.OrderByDescending<DocumentTypeDto>(x => x.IsDefault);
    DocumentTypeDto dto = base.Database.Fetch<DocumentTypeDto, ContentTypeDto, NodeDto>(baseQuery).FirstOrDefault<DocumentTypeDto>();
    if (dto == null)
    {
        return null;
    }
    IContentType type = new ContentTypeFactory(this.NodeObjectTypeId).BuildEntity(dto);
    type.AllowedContentTypes = base.GetAllowedContentTypeIds(id);
    type.PropertyGroups = base.GetPropertyGroupCollection(id);
    ((ContentType) type).PropertyTypes = base.GetPropertyTypeCollection(id);
    List<DocumentTypeDto> source = base.Database.Fetch<DocumentTypeDto>("WHERE contentTypeNodeId = @Id", new object[] { new { Id = id } });
    if (Enumerable.Any<DocumentTypeDto>(source))
    {
        if (selector == null)
        {
            selector = template => this._templateRepository.Get(template.TemplateNodeId);
        }
        type.AllowedTemplates = source.Select<DocumentTypeDto, ITemplate>(selector).ToList<ITemplate>();
    }
    foreach (ContentType2ContentTypeDto dto2 in base.Database.Fetch<ContentType2ContentTypeDto>("WHERE childContentTypeId = @Id", new object[] { new { Id = id } }))
    {
        type.AddContentType(base.Get(dto2.ParentId));
    }
    ((ICanBeDirty) type).ResetDirtyProperties();
    return type;
}

Now theres a name ICanBeDirty … funny, the deeper this goes the dirtier I feel.

Umbraco.Core.Persistence.Repositories.ContentTypeBaseRepository<TId,TEntity>.GetPropertyGroupCollection(int id)
protected PropertyGroupCollection GetPropertyGroupCollection(int id)
{
    Sql sql = new Sql();
    sql.Select(new object[] { "*" }).From<PropertyTypeGroupDto>().LeftJoin<PropertyTypeDto>().On<PropertyTypeGroupDto, PropertyTypeDto>(left => left.Id, right => right.PropertyTypeGroupId, new object[0]).LeftJoin<DataTypeDto>().On<PropertyTypeDto, DataTypeDto>(left => left.DataTypeId, right => right.DataTypeId, new object[0]).Where<PropertyTypeGroupDto>(x => (x.ContentTypeNodeId == id)).OrderBy<PropertyTypeGroupDto>(x => x.Id);
    List<PropertyTypeGroupDto> dto = base.Database.Fetch<PropertyTypeGroupDto, PropertyTypeDto, DataTypeDto, PropertyTypeGroupDto>(new Func<PropertyTypeGroupDto, PropertyTypeDto, DataTypeDto, PropertyTypeGroupDto>(new GroupPropertyTypeRelator().Map), sql);
    PropertyGroupFactory factory = new PropertyGroupFactory(id);
    return new PropertyGroupCollection(factory.BuildEntity(dto));
}

Now for a bit of JIT overhead… annnnnnnnnnnnnnnd

Umbraco.Core.Models.PropertyType..cctor
static PropertyType()
{
    NameSelector = ExpressionHelper.GetPropertyInfo<PropertyType, string>(x => x.Name);
    AliasSelector = ExpressionHelper.GetPropertyInfo<PropertyType, string>(x => x.Alias);
    DescriptionSelector = ExpressionHelper.GetPropertyInfo<PropertyType, string>(x => x.Description);
    DataTypeDefinitionIdSelector = ExpressionHelper.GetPropertyInfo<PropertyType, int>(x => x.DataTypeDefinitionId);
    DataTypeControlIdSelector = ExpressionHelper.GetPropertyInfo<PropertyType, Guid>(x => x.DataTypeId);
    DataTypeDatabaseTypeSelector = ExpressionHelper.GetPropertyInfo<PropertyType, DataTypeDatabaseType>(x => x.DataTypeDatabaseType);
    MandatorySelector = ExpressionHelper.GetPropertyInfo<PropertyType, bool>(x => x.Mandatory);
    HelpTextSelector = ExpressionHelper.GetPropertyInfo<PropertyType, string>(x => x.HelpText);
    SortOrderSelector = ExpressionHelper.GetPropertyInfo<PropertyType, int>(x => x.SortOrder);
    ValidationRegExpSelector = ExpressionHelper.GetPropertyInfo<PropertyType, string>(x => x.ValidationRegExp);
    PropertyGroupIdSelector = ExpressionHelper.GetPropertyInfo<PropertyType, int>(x => x.PropertyGroupId);
}

hmm bit more JIT overhead… annnnnnnnnnnnnnnd

public static PropertyInfo GetPropertyInfo<TSource, TProperty>(Expression<Func<TSource, TProperty>> propertyLambda)
{
    return PropertyInfoCache.GetOrAdd(new LambdaExpressionCacheKey(propertyLambda), delegate (LambdaExpressionCacheKey x) {
        Type type = typeof(TSource);
        MemberExpression body = propertyLambda.Body as MemberExpression;
        if (body == null)
        {
            if (propertyLambda.Body.GetType().get_Name() != "UnaryExpression")
            {
                throw new ArgumentException(string.Format("Expression '{0}' refers to a method, not a property.", propertyLambda));
            }
            UnaryExpression expression2 = propertyLambda.Body as UnaryExpression;
            if (expression2 != null)
            {
                MemberExpression operand = expression2.Operand as MemberExpression;
                if (operand == null)
                {
                    throw new ArgumentException("The type of property could not be infered, try specifying the type parameters explicitly. This can happen if you have tried to access PropertyInfo where the property's return type is a value type, but the expression is trying to convert it to an object");
                }
                body = operand;
            }
        }
        PropertyInfo member = body.Member as PropertyInfo;
        if (member == null)
        {
            throw new ArgumentException(string.Format("Expression '{0}' refers to a field, not a property.", propertyLambda));
        }
        if ((type != member.ReflectedType) && !type.IsSubclassOf(member.ReflectedType))
        {
            throw new ArgumentException(string.Format("Expresion '{0}' refers to a property that is not from type {1}.", propertyLambda, type));
        }
        return member;
    });
}

Hey were now using something in the system. Well kinda, mixed in with more usage of the above method.

In a tiny portion of application warm up 81.7% of time is spent in JIT overhead; now we can pretty much ignore that (kinda) as we know profilers disable native imaging which means the system will have to jump to JIT. Can't quite ignore the fucking horrendous pile of code it takes JUST to get a tiny bit of data.

---|| SQL SQL SQL

AND WHERE OFF >

SELECT *
FROM [cmsDocument]
INNER JOIN [cmsContentVersion]
ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')
AND (umbracoNode.id = @0)
AND ([cmsDocument].[newest]='True')
ORDER BY [cmsContentVersion].[VersionDate] DESC

--

SELECT *
FROM [cmsContentTypeAllowedContentType]
WHERE ([cmsContentTypeAllowedContentType].[Id] = 1167)

--

SELECT *
FROM [cmsContentTypeAllowedContentType]
WHERE ([cmsContentTypeAllowedContentType].[Id] = 1166)

--

SELECT *
FROM [cmsPropertyTypeGroup]
LEFT JOIN [cmsPropertyType]
ON [cmsPropertyTypeGroup].[id] = [cmsPropertyType].[propertyTypeGroupId]
LEFT JOIN [cmsDataType]
ON [cmsPropertyType].[dataTypeId] = [cmsDataType].[nodeId]
WHERE ([cmsPropertyTypeGroup].[contenttypeNodeId] = 1167)
ORDER BY [cmsPropertyTypeGroup].[id]

--

SELECT *
FROM [cmsPropertyTypeGroup]
LEFT JOIN [cmsPropertyType]
ON [cmsPropertyTypeGroup].[id] = [cmsPropertyType].[propertyTypeGroupId]
LEFT JOIN [cmsDataType]
ON [cmsPropertyType].[dataTypeId] = [cmsDataType].[nodeId]
WHERE ([cmsPropertyTypeGroup].[contenttypeNodeId] = 1166)
ORDER BY [cmsPropertyTypeGroup].[id]

--

SELECT *
FROM [cmsPropertyType]
INNER JOIN [cmsDataType]
ON [cmsPropertyType].[dataTypeId] = [cmsDataType].[nodeId]
WHERE ([cmsPropertyType].[contentTypeId] = 1167)

--

SELECT *
FROM [cmsPropertyType]
INNER JOIN [cmsDataType]
ON [cmsPropertyType].[dataTypeId] = [cmsDataType].[nodeId]
WHERE ([cmsPropertyType].[contentTypeId] = 1166)

--

SELECT *
FROM [cmsDocumentType]
RIGHT JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsDocumentType].[contentTypeNodeId]
INNER JOIN [umbracoNode]
ON [cmsContentType].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = 'a2cb7800-f571-4787-9638-bc48539a0efb')
AND (umbracoNode.id = @0)
ORDER BY [cmsDocumentType].[IsDefault] DESC

--

SELECT [cmsContentType2ContentType].[parentContentTypeId], [cmsContentType2ContentType].[childContentTypeId] FROM [cmsContentType2ContentType] WHERE childContentTypeId = @0

--


SELECT [cmsDocumentType].[contentTypeNodeId], [cmsDocumentType].[templateNodeId], [cmsDocumentType].[IsDefault] FROM [cmsDocumentType] WHERE contentTypeNodeId = @0

--

SELECT *
FROM [cmsContentTypeAllowedContentType]
WHERE ([cmsContentTypeAllowedContentType].[Id] = 1165)

--

SELECT *
FROM [cmsPropertyTypeGroup]
LEFT JOIN [cmsPropertyType]
ON [cmsPropertyTypeGroup].[id] = [cmsPropertyType].[propertyTypeGroupId]
LEFT JOIN [cmsDataType]
ON [cmsPropertyType].[dataTypeId] = [cmsDataType].[nodeId]
WHERE ([cmsPropertyTypeGroup].[contenttypeNodeId] = 1165)
ORDER BY [cmsPropertyTypeGroup].[id]

--

SELECT *
FROM [cmsPropertyType]
INNER JOIN [cmsDataType]
ON [cmsPropertyType].[dataTypeId] = [cmsDataType].[nodeId]
WHERE ([cmsPropertyType].[contentTypeId] = 1165)

--

SELECT *
FROM [cmsPropertyData]
INNER JOIN [cmsPropertyType]
ON [cmsPropertyData].[propertytypeid] = [cmsPropertyType].[id]
WHERE ([cmsPropertyData].[contentNodeId] = 1172)
AND ([cmsPropertyData].[versionId] = '7dbfb821-05b4-443e-a616-0cb5d126acad')


--

SELECT *
FROM [cmsPropertyData]
INNER JOIN [cmsPropertyType]
ON [cmsPropertyData].[propertytypeid] = [cmsPropertyType].[id]
WHERE ([cmsPropertyData].[contentNodeId] = 1171)
AND ([cmsPropertyData].[versionId] = '6f80d6cd-d1ac-4793-bca3-4343f34f9515')

--

SELECT *
FROM [cmsPropertyData]
INNER JOIN [cmsPropertyType]
ON [cmsPropertyData].[propertytypeid] = [cmsPropertyType].[id]
WHERE ([cmsPropertyData].[contentNodeId] = 1170)
AND ([cmsPropertyData].[versionId] = '510748fa-e6f5-4164-b237-8cea211bff31')

Ooook so less of a quick dive; more like being drowned. To add some context; Node: 1173 consists of 5 records which build up a media element in umbraco (file/width/height/etc); the query was to

To query this one bit of the required data from the db Umbraco creates this query...

SELECT  *
FROM    [cmsPropertyData]
        INNER JOIN [cmsPropertyType] ON [cmsPropertyData].[propertytypeid] = [cmsPropertyType].[id]
WHERE   ( [cmsPropertyData].[contentNodeId] = 1173 )
        AND ( [cmsPropertyData].[versionId] = '87089cf2-f3fb-48c0-904a-346c56d14f2a' )

In fairness, once started, with A LOT of the site not actually making use of umbraco it performs ok. The nodes being loaded in this instance was simply pulling the content of an advert container. Which consists of 3 adverts; an advert consisting of a dropdown (3 items in it to set the type), a media picker (1 image) and a url.

Bit of a double edged blade; if you use umbraco doctypes for everything (think blog style/comments/date filters/long trees lots of properties) it blows and flamethrows memory till there's nothing left; if you treat umbraco like a repository your reliant on the API being stable, set in stone, and eventually, and probably not as far away as you'd like it, to be able to debug it without being dropped into a mass of generic/anonymous methods/linq hell.

Bleh

Back in MVC2 days I wrote a post on setting up a project with lowercase urls / redirecting and a workaround for IIS6. Luckily these days we have MVC4 which is a tad friendlier… to a degree.

In the Route collection registration area (Most likely in App_Start lest you've moved it) you can now simply add routes.LowercaseUrls = true; (http://msdn.microsoft.com/en-us/library/system.web.routing.routecollection.lowercaseurls.aspx )

The big bugger about this is (and theres a bug in codepex for it here http://aspnetwebstack.codeplex.com/workitem/685?PendingVoteId=685) when you add an MVC Area the bloody thing stops working.

In which case you'll want to use http://nuget.org/packages/LowercaseRoutesMVC4/ which does the trick.

A common usage of the self-referencing joins is the use of 1 table for regions and subregions; its also the laziest example that comes to mind.

Entity

using System.Collections.Generic;
using Domain.Base;

public class Region : DomainObject<int, Region>
{
    private IList<Region> _subRegion = new List<Region>();
    public virtual string Name { get; set; }

    public virtual IList<Region> SubRegion
    {
        get { return _subRegion; }
        set { _subRegion = value; }
    }
}

ClassMap

using Domain;
using FluentNHibernate.Mapping;

public class RegionMappingClass : ClassMap<Region>
{
    public RegionMappingClass()
    {
        Id(x => x.Id).GeneratedBy.Identity();
        Map(x => x.Name).Not.Nullable().Length(50);
        HasMany<Region>(x => x.SubRegion).KeyColumn("ParentRegionId").Cascade.All();
    }
}

Fixture / Persistence Specification

using System;
using System.Collections.Generic;
using Domain;
using FluentNHibernate.Testing;
using NUnit.Framework;

[TestFixture]
[Category("DataIntegration")]
public class RegionMappingFixture : IntegrationTestBase
{
    [Test]
    public void CanCreateRegions()
    {
        var region = new Region()
                         {
                             Name = "Gtr Manchester"
                         };

        Session.Save(region);

        region.SubRegion.Add(new Region() {Name = "Test B"});
        region.SubRegion.Add(new Region() {Name = "Test C"});

        Session.Save(region);

        FlushAndClear();

        Assert.NotNull(region.Id);
    }

    [Test]
    public void CanMapRegion()
    {
        new PersistenceSpecification<Region>(Session)
            .CheckProperty(x => x.Name, "Gtr Manchester")
            .CheckList(x => x.SubRegion, new List<Region> {new Region() {Name = "Bolton"}, new Region() {Name = "Bury"}})
            .VerifyTheMappings();
    }
}

Small caveat; this code is supplied as a sample, the tests here are the minimum and nothing more