Duct typing and using

DynamicQuery.cs

/*
 * This is a silly little test to remove the word using from data access classes.
 * Beware that null will be returned if the dynamic object doesn't match the return type of the calling function.
 */
 
private dynamic IHateTheWordUsing(Func<UmbracoDBDataContext, dynamic> command)
{
    using (var context = new UmbracoDBDataContext(sqlConnection))
    {
        return command(context);
    }
}

public Product GetProduct(Guid productId)
{
    return IHateTheWordUsing(context =>
    {
        var product = context.products.FirstOrDefault(x => x.Id == productId);

        if (product == null)
        {
            return null;
        }

        return new Product
        {
            Id = product.Id,
            Name = product.Name,
            Description = product.Description
        };
    });
}