使用EF 7(核心)將實體綁定到WPF數據網格

c# data-binding entity-framework-core wpf

我有一個簡單的數據綁定問題。我無法獲取datagrid DeviceDataGrid來可視化實體信息。 MainWindow.xaml文件如下:

<Window 
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:domain="clr-namespace:FxEditorDatabaseStructure.Core.Domain"
    mc:Ignorable="d" x:Class="FxEditorDatabaseStructure.MainWindow"
        Title="MainWindow" Height="350" Width="525" Loaded="Window_Loaded">
    <Window.Resources>
        <CollectionViewSource x:Key="DeviceViewSource" d:DesignSource="{d:DesignInstance {x:Type domain:Device}, CreateList=True}"/>
    </Window.Resources>
    <Grid DataContext="{StaticResource DeviceViewSource}">
        <DataGrid x:Name="DeviceDataGrid" AutoGenerateColumns="False" EnableRowVirtualization="True" ItemsSource="{Binding}" Margin="0,64,0,0" RowDetailsVisibilityMode="VisibleWhenSelected">
            <DataGrid.Columns>
                <DataGridTextColumn x:Name="NameColumn" Binding="{Binding Name}" Header="Name" Width="250"/>
                <DataGridTextColumn x:Name="SocketCountColumn" Binding="{Binding DeviceId}" Header="Id" Width="Auto"/>
                <DataGridTextColumn x:Name="DescriptionColumn" Binding="{Binding Description}" Header="Description" Width="Auto"/>
                <DataGridTextColumn x:Name="ProductTypeColumn" Binding="{Binding ProductType}" Header="Product Type" Width="*"/>
            </DataGrid.Columns>
        </DataGrid>
        <Button Content="Add" HorizontalAlignment="Left" Margin="23,25,0,0" VerticalAlignment="Top" Width="75" RenderTransformOrigin="-0.143,-0.057" Click="AddDevice_Click"/>
    </Grid>
</Window>

並嘗試在MainWindow上可視化實體內的數據。正確創建數據庫,甚至添加按鈕也可以。我可以通過Firefox SQLite Manager看到這一點。

這是xaml.cs文件,它在將實體加載到內存後將實體“綁定”到數據網格中:

    public partial class MainWindow : Window
    {
        private FxContext _context = new FxContext();

        public MainWindow()
        {
            InitializeComponent();
            _context.Database.Migrate();
        }
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            _context.Devices.Add(new Device
            {
                ProductCode = "100",
                Name = "LUX999",
                Description = "Measurement device",
                Supplier = "X",
                Category = "Sensors",
                ProductType = "Field device",
                TimeCreated = DateTime.Now
            });
            _context.SaveChanges();

            System.Windows.Data.CollectionViewSource deviceViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("DeviceViewSource")));
            _context.Devices.Load();
            _context.Sockets.Load();
            _context.ProductTypes.Load();
            deviceViewSource.Source = _context.Devices.GetLocal();
            deviceViewSource.Source = _context.Categories.GetLocal();
            deviceViewSource.Source = _context.ProductTypes.GetLocal();
        }

        protected override void OnClosing(System.ComponentModel.CancelEventArgs e)
        {
            base.OnClosing(e);

            _context.Dispose();
        }

        private void AddDevice_Click(object sender, RoutedEventArgs e)
        {
            _context.Devices.Add(
                new Device
                {
                    TimeCreated = DateTime.Now,
                    Name = "New Device at " + DateTime.Now.ToShortDateString()
                });

            _context.SaveChanges();
        }
    }
}

因為EF7(核心)仍然缺乏local()的實現,我正在使用另一種擴展方法

public static class Extensions
{
    public static ObservableCollection<TEntity> GetLocal<TEntity>(this DbSet<TEntity> set)
        where TEntity : class
    {
        var context = set.GetService<DbContext>();
        var data = context.ChangeTracker.Entries<TEntity>().Select(e => e.Entity);
        var collection = new ObservableCollection<TEntity>(data);

        collection.CollectionChanged += (s, e) =>
        {
            if (e.NewItems != null)
            {
                context.AddRange(e.NewItems.Cast<TEntity>());
            }

            if (e.OldItems != null)
            {
                context.RemoveRange(e.OldItems.Cast<TEntity>());
            }
        };

        return collection;
    }
}

當我運行應用程序時,datagrid沒有在列表視圖中顯示數據庫中的任何值。不知怎的,這一行沒有正確地傳輸實體deviceViewSource.Source = _context.Devices.GetLocal();或者某些綁定過程在xaml文件中是錯誤的?

我有什麼想法我做錯了嗎?

一般承認的答案

問題是,您將deviceViewSource.Source設置為設備,然後替換為Categories,然後替換為ProductTypes

deviceViewSource.Source = _context.Devices.GetLocal();
deviceViewSource.Source = _context.Categories.GetLocal();
deviceViewSource.Source = _context.ProductTypes.GetLocal();

在和,您正在數據處理到ProductTypes ...刪除兩個底線。

我相信你也不需要GetLocal()方法。嘗試這個:

deviceViewSource.Source = _context.Devices


Related

許可下: CC-BY-SA with attribution
不隸屬於 Stack Overflow
許可下: CC-BY-SA with attribution
不隸屬於 Stack Overflow