public Task GetById(long id)
    {
        var command    = new SqlCommand(GetByIdCommand);
        var parameters = IEnumerableHelper.ToEnumerable <SqlParameter>(new SqlParameter(GetByIdCommandIdParameter, GetByIdCommandIdParameterType, id));
        var dataTable  = db.ExecuteToDataTable(command, parameters);

        return(DataTableToTask(dataTable)[0]);
    }