GetByKey needs to be reworked to not need explicit table names

[Grauenwolf]

Here is the current syntax

m_DataSource.GetByKey("HR.EmployeeClassification", employeeClassificationKey).ToObject<EmployeeClassification>().Execute();

Notice how the table name is mentioned twice, once directly and once in the materializer.

We want this:

m_DataSource.GetByKey<EmployeeClassification>(employeeClassificationKey).ToObject().Execute();

[Grauenwolf]

We can't completely generalize it, but this will get us close:

    /// <summary>
    /// Gets a record by its primary key.
    /// </summary>
    /// <typeparam name="TObject">The type of the object.</typeparam>
    /// <param name="key">The key.</param>
    /// <returns></returns>
    /// <remarks>This only works on tables that have a scalar primary key.</remarks>
    ISingleRowDbCommandBuilder GetByKey<TObject>(Guid key)
        where TObject : class;

    /// <summary>
    /// Gets a record by its primary key.
    /// </summary>
    /// <typeparam name="TObject">The type of the object.</typeparam>
    /// <param name="key">The key.</param>
    /// <returns></returns>
    /// <remarks>This only works on tables that have a scalar primary key.</remarks>
    ISingleRowDbCommandBuilder GetByKey<TObject>(long key)
        where TObject : class;

    /// <summary>
    /// Gets a record by its primary key.
    /// </summary>
    /// <typeparam name="TObject">The type of the object.</typeparam>
    /// <param name="key">The key.</param>
    /// <returns></returns>
    /// <remarks>This only works on tables that have a scalar primary key.</remarks>
    ISingleRowDbCommandBuilder GetByKey<TObject>(int key)
        where TObject : class;

    /// <summary>
    /// Gets a record by its primary key.
    /// </summary>
    /// <typeparam name="TObject">The type of the object.</typeparam>
    /// <param name="key">The key.</param>
    /// <returns></returns>
    ISingleRowDbCommandBuilder GetByKey<TObject>(string key)
        where TObject : class;

And for any oddball scenarios

    /// <summary>
    /// Gets a record by its primary key.
    /// </summary>
    /// <typeparam name="TObject">The type of the object.</typeparam>
    /// <typeparam name="TKey"></typeparam>
    /// <param name="key">The key.</param>
    /// <returns></returns>
    /// <remarks>This only works on tables that have a scalar primary key.</remarks>
    ISingleRowDbCommandBuilder GetByKey<TObject, TKey>(TKey key)
        where TObject : class
        where TKey : struct;

[Grauenwolf]

See also #348