You are here: Home / Blog / posts / Programming Magic

Programming Magic

by admin published Jan 28, 2014 10:55 AM, last modified Jan 28, 2014 03:11 PM
No one knows how the ancient art of programming works, but our team is willing to share some of their secret rituals.

How-to add timing print out statements to SQL scripts

by admin — last modified Jan 28, 2014 02:36 PM

This wiki describes how to add timing print out statements to SQL scripts and stored procedures.

How-to add timing print out statements to SQL scripts - Read More…

Emulating Oracle's Multi-Column IN Statement with MS SQL Server

by admin — last modified Jan 28, 2014 02:35 PM

This entry describes how to emulate Oracle's multi-column IN statement using an anonymous INNER JOIN with MS SQL server.

Emulating Oracle's Multi-Column IN Statement with MS SQL Server - Read More…

A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance

by admin — last modified Jan 28, 2014 02:32 PM

This exception "A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance" happens when:

A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance - Read More…

Create scripts for source control

by admin — last modified Jan 28, 2014 02:31 PM

When creating SQL scripts for source control, date time stamps make it difficult to see exactly what changed between versions.

Create scripts for source control - Read More…

Convert VS 2008 deploy project to VS 2010

by admin — last modified Jan 28, 2014 02:25 PM

Convert a Visual Studio 2008 deployment project to Visual Studio 2010 deployment project using new and enhanced features. Also a step by step explanation on how to actually deploy your project using the file system method.

Convert VS 2008 deploy project to VS 2010 - Read More…

Mock a call to SmartServiceLocator

by admin — last modified Jan 28, 2014 02:13 PM

Mock SmartServiceLocator<IRepository<Entity>>.GetService()

Mock a call to SmartServiceLocator - Read More…

Force refresh of data from database with NHibernate

by admin — last modified Jan 28, 2014 02:11 PM

Avoid the black magic of NHibernate thinking that it does not need to re-get the data from the database when doing unit tests.

Force refresh of data from database with NHibernate - Read More…

Magic 101

by admin — last modified Jan 28, 2014 10:06 AM

avadakadvra

Magic 101 - Read More…

How to Use an nHibernate Composite Database Key

by Ken Taylor — last modified Jan 28, 2014 11:39 AM

This article describes the extra steps required to setup a c# data access class and a nHibernate data map to use a composite database key. These additional steps allow LINQ to nHibernate to function properly for CRUD operations.

How to Use an nHibernate Composite Database Key - Read More…

SQL Server: Unable to add new replication subscription

by Ken Taylor — last modified Jan 28, 2014 11:38 AM

This article describes how to fix broken replication services on a subscriber where a NULL SERVERNAME is the issue.

SQL Server: Unable to add new replication subscription - Read More…

How to Copy a Windows Azure Database

by admin — last modified Jan 28, 2014 11:41 AM

Describes how to copy a Windows Azure database from the Management Portal, specifically Pre-Purchasing.

How to Copy a Windows Azure Database - Read More…

Bitlocker Drive Encryption Status

by Ken Taylor — last modified Jan 28, 2014 11:40 AM

How to manually check how far along Bitlocker is with encrypting a hard drive.

Bitlocker Drive Encryption Status - Read More…

How-to add timing print out statements to SQL scripts

by Ken Taylor — last modified Jan 28, 2014 11:45 AM

This wiki describes how to add timing print out statements to SQL scripts and stored procedures.

How-to add timing print out statements to SQL scripts - Read More…

Emulating Oracle's Multi-Column IN Statement with MS SQL Server

by Ken Taylor — last modified Jan 28, 2014 11:53 AM

This entry describes how to emulate Oracle's multi-column IN statement using an anonymous INNER JOIN with MS SQL server.

Emulating Oracle's Multi-Column IN Statement with MS SQL Server - Read More…

A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance

by jsylvest — last modified Jan 28, 2014 11:54 AM

This exception "A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance" happens when:

A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance - Read More…

Create scripts for source control

by jsylvest — last modified Jan 28, 2014 12:01 PM

When creating SQL scripts for source control, date time stamps make it difficult to see exactly what changed between versions.

Create scripts for source control - Read More…

Extend MVC LabelFor Method

by jsylvest — last modified Jan 28, 2014 12:02 PM

The LabelFor method provides strongly typed labels using lambda expressions. Unfortunately, the default MVC one doesn't provide a way to add extra attributes and if you don't want the text from the field variable you have to use the DisplayNames data annotations. The method here uses the variable name or data annotation DisplayName, but allows the Camel Case variable to be split into words, add a colon to the end, add extra text, and/or specify an id value for the label.

Extend MVC LabelFor Method - Read More…

Convert VS 2008 deploy project to VS 2010

by jsylvest — last modified Jan 28, 2014 12:20 PM

Convert a Visual Studio 2008 deployment project to Visual Studio 2010 deployment project using new and enhanced features. Also a step by step explanation on how to actually deploy your project using the file system method.

Convert VS 2008 deploy project to VS 2010 - Read More…

Mock a call to SmartServiceLocator

by jsylvest — last modified Jan 28, 2014 12:51 PM

Mock SmartServiceLocator<IRepository<Entity>>.GetService()

Mock a call to SmartServiceLocator - Read More…

Force refresh of data from database with NHibernate

by jsylvest — last modified Jan 28, 2014 12:52 PM

Avoid the black magic of NHibernate thinking that it does not need to re-get the data from the database when doing unit tests.

Force refresh of data from database with NHibernate - Read More…

Tips and Tricks Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0

by Ken Taylor — last modified Jan 28, 2014 12:54 PM

This is a running dialog for documenting tips and tricks found while using SQL Server 2008 R2 Reporting Services and Report Builder 3.0.

Tips and Tricks Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0 - Read More…

When:

Where:

Contact