Data binding to a data network in WPF using Entity Framework

Question

I looked around the world and found nothing, it seems to help.

I made a model and added the model to the data source as an object. I suggested that this would work as a dataset where I can simply drag and drop onto the form and bind the data for me. But it continues to show a space when I drag it out of the model. so I looked online and saw that some kind of code was required, and that is what I have, and it is still empty. Any ideas what I'm doing wrong?

   public partial class form1: Window

{
    ComEntities context;;
    public form1()
    {
        InitializeComponent();

    }

    private void Window_Loaded(object sender, RoutedEventArgs e)
    {
        context = new ComEntities();

        System.Windows.Data.CollectionViewSource comEntitiesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("comEntitiesViewSource")));


        var permits = (from c in context.tBLPER.Local select c);

        this.DataContext = context.tBLPER.Local;
        tBLPERDataGrid.ItemsSource = context.tBLPER.Local;

    }


}

XAML:

 <DataGrid x:Name="tBLPERDataGrid" RowDetailsVisibilityMode="VisibleWhenSelected" Margin="10,10,10,413" ItemsSource="{Binding}" EnableRowVirtualization="True" AutoGenerateColumns="False">

    </DataGrid>

Answer 1

You must materialize your request (bring data into memory). You can do this by calling the method ToList(), but even better:

 context.TBLPER.Load();  
 this.DataContext = context.TBLPER.Local;  // set the Window DataContext property

Local ObservableCollection<T>, Added, Unchanged Modified . , . , , , .

(, Age , 20 ), :

 context.TBLPER.Where(t=>t.Age>20).Load();  
 this.DataContext = context.TBLPER.Local; 

, ItemSource , xaml, :

<DataGrid ... ItemsSource="{Binding}" ...>

:

tBLPERDataGrid.ItemsSource=context.TBLPER.Local;

Answer 2

ItemsSource ( - ItemsSource="{Binding}").

, AutoGenerateColumns="True", DataGrid X Column DataGrid.

. http://www.wpf-tutorial.com/datagrid-control/custom-columns/

tBLPERDataGrid.ItemsSource = permits;, permits, , .

Answer 3

AutoGenerateColumns = "False", XAML AutoGenerateColumns = "True". , .

Answer 4

Model ( ItemsSource="{Binding}" - , ), ItemsSource. Model CEntities context;, DataContext :

DataContext = new CEntities();

tBLPERDataGrid.ItemsSource = permits;

Now ItemsSource comes from the instance CEntities.