WPF

// List for returning results
List<PurchasingEntity> results = null;

// Query of all joined records 
IQueryable<PurchasingEntity> query = (from c in db.Companies
                                        join p in db.Projects on c.Id equals p.CompanyId
                                        join j in db.Jobs on p.Id equals j.ProjectId
                                        select new PurchasingEntity
                                        {
                                            CompanyId = c.Id,
                                            CompanyName = c.CompanyName,
                                            ProjectId = p.Id,
                                            ProjectName = p.ProjectName,
                                            ProjectStatusId = p.StatusId.HasValue ? p.StatusId : 0,
                                            JobId = j.Id,
                                            JobNumber = j.JobId,
                                            Phase = j.Phase,
                                            Quantity = j.Quantity.HasValue ? j.Quantity.Value : 0,
                                            StartDate = j.StartDate.HasValue ? j.StartDate : null,
                                            LumberVendorId = j.LumberVendorId,
                                            HardwareVendorId = j.HardwareVendorId,
                                            TrussVendorId = j.TrussVendorId
                                        });

// Create the PredicateBuilder
var predicate = PredicateBuilder.True<PurchasingEntity>();

// Add status Awarded filter
predicate = predicate.And(i => i.ProjectStatusId == awardedId);

// Add optional query parameters
if (companyId > 0)
{
    predicate = predicate.And(i => i.CompanyId == companyId);
}

if (projectId > 0)
{
    predicate = predicate.And(i => i.ProjectId == projectId);
}

if (startDate != null)
{
    predicate = predicate.And(i => i.StartDate >= startDate);
}

if (endDate != null)
{
    predicate = predicate.And(i => i.StartDate <= endDate);
}

// Set the query's WHERE clause to the predicate and call ToList
results = query.Where(predicate).ToList();

<TextBlock Grid.Row="0" 
            Margin="5">

    <Hyperlink x:Name="link">
        <TextBlock Text="Purchasing"
                    FontSize="14"/>
        <i:Interaction.Triggers>
            <i:EventTrigger EventName="Click">
                <i:InvokeCommandAction Command="{Binding ActionCommand, RelativeSource={RelativeSource AncestorType=Window}}"
                                        CommandParameter="{Binding ElementName=link}"/>
            </i:EventTrigger>
        </i:Interaction.Triggers>
    </Hyperlink>

</TextBlock>

System.Windows.Data Error: 40 : BindingExpression path error: 'ActionCommand' property not found on 'object' ''MainWindowView' (Name='window')'. BindingExpression:Path=ActionCommand; DataItem='MainWindowView' (Name='window'); target element is 'InvokeCommandAction' (HashCode=36783718); target property is 'Command' (type 'ICommand')

<Style TargetType="TabItem">

    <Setter Property="ContextMenu">
        <Setter.Value>
            <ContextMenu>

                <MenuItem Header="Close All" 
                        Command="{Binding DataContext.CloseTabCommand, RelativeSource={RelativeSource Mode=FindAncestor, AncestorType={x:Type MenuItem}, AncestorLevel=1}}"
                        CommandParameter="{Binding }"/>

                <MenuItem Header="Close All" 
                        Command="{Binding DataContext.CloseAllTabsCommand, RelativeSource={RelativeSource Mode=FindAncestor, AncestorType={x:Type MenuItem}, AncestorLevel=1}}"
                        CommandParameter="{Binding }"/>

                <MenuItem Header="Close All But This" 
                        Command="{Binding DataContext.CloseAllButThisTabCommand, RelativeSource={RelativeSource Mode=FindAncestor, AncestorType={x:Type MenuItem}, AncestorLevel=1}}"
                        CommandParameter="{Binding }"/>

            </ContextMenu>
        </Setter.Value>
    </Setter>

</Style>

System.Windows.Data Error: 4 : Cannot find source for binding with reference 'RelativeSource FindAncestor, AncestorType='System.Windows.Controls.MenuItem', AncestorLevel='1''. BindingExpression:Path=DataContext.CloseTabCommand; DataItem=null; target element is 'MenuItem' (Name=''); target property is 'Command' (type 'ICommand')

System.Windows.Data Error: 4 : Cannot find source for binding with reference 'RelativeSource FindAncestor, AncestorType='System.Windows.Controls.MenuItem', AncestorLevel='1''. BindingExpression:Path=DataContext.CloseAllTabsCommand; DataItem=null; target element is 'MenuItem' (Name=''); target property is 'Command' (type 'ICommand')

System.Windows.Data Error: 4 : Cannot find source for binding with reference 'RelativeSource FindAncestor, AncestorType='System.Windows.Controls.MenuItem', AncestorLevel='1''. BindingExpression:Path=DataContext.CloseAllButThisTabCommand; DataItem=null; target element is 'MenuItem' (Name=''); target property is 'Command' (type 'ICommand')

<ListBox ItemsSource="{Binding QuickActions}"
            x:Name="quickItemList">

    <ListBox.ItemTemplate>
        <DataTemplate>

            <TextBlock Grid.Row="0" 
                        Margin="5">

                <Hyperlink x:Name="link">

                    <TextBlock Text="{Binding Caption}"/>

                    <i:Interaction.Triggers>
                        <i:EventTrigger EventName="Click">
                            <i:InvokeCommandAction Command="{Binding ElementName=uc, Path=DataContext.QuickActionCommand}"
                                                    CommandParameter="{Binding ElementName=quickItemList, Path=SelectedItem}"/>
                        </i:EventTrigger>
                    </i:Interaction.Triggers>

                </Hyperlink>

            </TextBlock>

        </DataTemplate>

    </ListBox.ItemTemplate>

</ListBox>

private ICommand _QuickActionCommand;
public ICommand QuickActionCommand
{
    get
    {
        if (_QuickActionCommand == null)
            _QuickActionCommand = new RelayCommand<object>(p => QuickActionExecuted(p), p => QuickActionCanExecute());
        return _QuickActionCommand;
    }
}

private bool QuickActionCanExecute()
{
    return true;
}

private void QuickActionExecuted(QuickActionModel model)
{
}

<DataGrid Grid.Row="2" Name="_dataGrid2" 
                  ItemsSource="{Binding Matrix}" 
                  AlternationCount="2" 
                  AutoGenerateColumns="False" 
                  Style="{StaticResource styleDataGridNoSelection}" 
                  EnableRowVirtualization="True" 
                  EnableColumnVirtualization="True"
                  VirtualizingStackPanel.IsVirtualizing="False"
                  VirtualizingStackPanel.VirtualizationMode="Recycling"
                  ScrollViewer.CanContentScroll="True"
                  HeadersVisibility="None"/>

public MainWindow()
        {
            InitializeComponent();

            MainViewModel viewModel = new MainViewModel();
            DataContext = viewModel;

            //_gridDataTemplateSelector = new TouchHub2.View.DataGridTemplateSelector();
            _gridDataTemplateSelector = new GridDataTemplateSelector();
            _gridDataTemplateSelector.LabelDataTemplate = Resources["LabelDataTemplate"] as DataTemplate;
            _gridDataTemplateSelector.TextBoxDataTemplate = Resources["TextBoxDataTemplate"] as DataTemplate;
            _gridDataTemplateSelector.CheckBoxDataTemplate = Resources["CheckBoxDataTemplate"] as DataTemplate;
            _gridDataTemplateSelector.ComboBoxDataTemplate = Resources["ComboBoxDataTemplate"] as DataTemplate;

            for (int i = 0; i < Row.constColumnCount; i++)
            {
                DataGridTemplateColumn col = new DataGridTemplateColumn();

                FrameworkElementFactory fef = new FrameworkElementFactory(typeof(ContentPresenter));
                Binding binding = new Binding();
                fef.SetBinding(ContentPresenter.ContentProperty, binding);
                fef.SetValue(ContentPresenter.ContentTemplateSelectorProperty, _gridDataTemplateSelector);

                binding.Path = new PropertyPath("Values[" + i + "]");
                DataTemplate dataTemplate = new DataTemplate();
                dataTemplate.VisualTree = fef;
                col.CellTemplate = dataTemplate;

                _dataGrid2.Columns.Add(col);
        }

public class MainViewModel : System.ComponentModel.INotifyPropertyChanged
    {
        public MainViewModel()
        {
            const int RowCount = 150;

            _matrix = new Row[RowCount];
            for (int i = 0; i < RowCount; i++)
            {
                _matrix[i] = new Row("Row" + i.ToString(), i);
            }
        }

        private Row[] _matrix;
        public Row[] Matrix
        {
            get
            {
                return _matrix;
            }
        }

        #region INotifyPropertyChanged

        public event System.ComponentModel.PropertyChangedEventHandler PropertyChanged;

        public virtual void NotifyPropertyChanged(string propertyName)
        {
            if (PropertyChanged != null)
            {
                PropertyChanged(this, new System.ComponentModel.PropertyChangedEventArgs(propertyName));
            }
        }

        #endregion
    }

public class Row
    {
        private string name;
        private Model.INode[] _values;

        public string Name { get { return name; } }
        public Model.INode[] Values { get { return _values; } }
        public int Index { get; set; }

        public const int constColumnCount = 90;
        public Row(string name, int index)
        {
            Index = index;
            this.name = name;
            _values = new Model.INode[constColumnCount];
            for (int i = 0; i < constColumnCount; i++)
            {
                if (index == 0)
                {
                    _values[i] = new Model.LabelNode();
                    (_values[i] as Model.LabelNode).Value = i.ToString();
                }
                else
                {
                    if (i == 0)
                    {
                        _values[i] = new Model.LabelNode();
                        (_values[i] as Model.LabelNode).Value = index.ToString();
                    }
                    else
                    {
                        switch ((i + index) % 3)
                        {
                            case 0:
                                _values[i] = new Model.TextNode();
                                (_values[i] as Model.TextNode).Value = i.ToString();
                                break;
                            case 1:
                                _values[i] = new Model.CheckBoxNode();
                                (_values[i] as Model.CheckBoxNode).Value = true;
                                break;
                            case 2:
                                _values[i] = new Model.ComboBoxNode();
                                (_values[i] as Model.ComboBoxNode).Values = new List<string>(2) { (i + index).ToString(), (i + index + 1).ToString() };
                                (_values[i] as Model.ComboBoxNode).Value = (_values[i] as Model.ComboBoxNode).Values[0];
                                break;
                        }
                    }
                }
            }
        }

class TextNode : INode
    {
        public string Value { get; set; }
    }