/// <summary>
/// Gets an entity from the database by key.
/// </summary>
/// <param name="key">The primary key of the entity</param>
public TEntity Get(TKey key)
{
var parameters = new DynamicParameters();
parameters.Add("id", key);
var connection = GetConnection();
try {
var keyParamName = _queryGenerator.FormatSqlParameter("id");
var entity = connection.Query <TEntity>(_queryGenerator.Select(Table, SelectFields, Key, keyParamName), parameters).FirstOrDefault();
return(entity);
}
finally {
if (!_useProvidedConnection)
{
connection.Dispose();
}
}
}