WPF Datagrid loaded 79M items in mvvm , Microsoft.Extensions.DependencyInjection

 

Install-Package Microsoft.Extensions.DependencyInjection;

 

 

 

        public async Task InitBooksCollection(){stopwatch.Start();BooksCollection = new ObservableCollection<Book>();List<Book> booksList = new List<Book>();await Task.Run(async () =>{for (int i = 1; i < 100000001; i++){booksList.Add(new Book(){Id = idService.GetID(),Name = nameService.GetName(),ISBN = isbnService.GetISBN(),Author = $"Author_{i}",Title = $"Title_{i}",Topic = $"Topic_{i}"});if (i < 1001 && i % 100 == 0){var tempList = booksList.ToList();booksList.Clear();await PopulateBooksCollection(tempList);}else if (i > 1000 && i % 1000000 == 0){var tempList = booksList.ToList();booksList.Clear();await PopulateBooksCollection(tempList);}}if (booksList.Any()){var tempList = booksList.ToList();booksList.Clear();await PopulateBooksCollection(tempList);}});}private async Task PopulateBooksCollection(List<Book> booksList){await Application.Current.Dispatcher.InvokeAsync(() =>{foreach (var bk in booksList){BooksCollection.Add(bk);}StatusMsg = $"MainWindow,now is {DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}," +$"loaded {BooksCollection.Count} items,{GetMemory()},{GetTimeCost()}";}, System.Windows.Threading.DispatcherPriority.Background);System.Diagnostics.Debug.WriteLine(StatusMsg);}private string GetMemory(){double memory = Process.GetCurrentProcess().PrivateMemorySize64;return $"Memory:{memory.ToString("#,##0.00")}";}private string GetTimeCost(){return $"Time cost:{stopwatch.Elapsed.TotalSeconds.ToString("#,##0.00")} seconds";}

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

//App.xaml
<Application x:Class="WpfApp5.App"xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"xmlns:local="clr-namespace:WpfApp5"><Application.Resources></Application.Resources>
</Application>//App.xaml.cs
using Microsoft.Extensions.DependencyInjection;
using System.Configuration;
using System.Data;
using System.Windows;
using WpfApp5.Services;namespace WpfApp5
{/// <summary>/// Interaction logic for App.xaml/// </summary>public partial class App : Application{ServiceProvider serviceProvider;protected override void OnStartup(StartupEventArgs e){base.OnStartup(e);var services = new ServiceCollection();ConfigureServices(services);serviceProvider = services.BuildServiceProvider();var mainWin = serviceProvider.GetRequiredService<MainWindow>();mainWin?.Show();}private void ConfigureServices(ServiceCollection services){services.AddSingleton<IISBNService, ISBNService>();services.AddSingleton<INameService, NameService>();services.AddSingleton<IIDService, IDService>();services.AddSingleton<MainWindow>();services.AddSingleton<MainVM>();}}}//MainWindow.xaml
<Window x:Class="WpfApp5.MainWindow"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"WindowState="Maximized"xmlns:local="clr-namespace:WpfApp5"mc:Ignorable="d"Title="{Binding StatusMsg}"Height="450" Width="800"><Grid><DataGrid ItemsSource="{Binding BooksCollection,Mode=TwoWay,UpdateSourceTrigger=PropertyChanged}"VirtualizingPanel.IsVirtualizing="True"VirtualizingPanel.VirtualizationMode="Recycling"VirtualizingPanel.ScrollUnit="Pixel"VirtualizingPanel.CacheLengthUnit="Pixel"VirtualizingPanel.CacheLength="1,2"                    ScrollViewer.IsDeferredScrollingEnabled="True"ScrollViewer.CanContentScroll="True"EnableColumnVirtualization="True"EnableRowVirtualization="True"AutoGenerateColumns="False"><DataGrid.Resources><Style TargetType="DataGridCell"><Setter Property="FontSize" Value="30"/><Setter Property="Width" Value="Auto"/><Style.Triggers><Trigger Property="FontSize" Value="50"/><Trigger Property="Foreground" Value="Red"/></Style.Triggers></Style></DataGrid.Resources><DataGrid.Columns><DataGridTextColumn Binding="{Binding Id}"/><DataGridTextColumn Binding="{Binding Name}"/><DataGridTextColumn Binding="{Binding Author}"/><DataGridTextColumn Binding="{Binding Title}"/><DataGridTextColumn Binding="{Binding Topic}"/><DataGridTextColumn Binding="{Binding ISBN}"/><!--<DataGridTemplateColumn><DataGridTemplateColumn.CellTemplate><DataTemplate><Grid><Grid.Resources><Style TargetType="TextBlock"><Setter Property="FontSize" Value="30"/><Style.Triggers><Trigger Property="IsMouseOver" Value="True"><Setter Property="FontSize" Value="50"/><Setter Property="Foreground" Value="Red"/></Trigger></Style.Triggers></Style><Style TargetType="ColumnDefinition"><Setter Property="Width" Value="Auto"/></Style></Grid.Resources><Grid.ColumnDefinitions><ColumnDefinition/><ColumnDefinition/><ColumnDefinition/><ColumnDefinition/><ColumnDefinition/><ColumnDefinition/></Grid.ColumnDefinitions><TextBlock Text="{Binding Id}" Grid.Column="0"/><TextBlock Text="{Binding Name}" Grid.Column="1"/><TextBlock Text="{Binding Author}" Grid.Column="2"/><TextBlock Text="{Binding Title}" Grid.Column="3"/><TextBlock Text="{Binding Topic}" Grid.Column="4"/><TextBlock Text="{Binding ISBN}" Grid.Column="5"/></Grid></DataTemplate></DataGridTemplateColumn.CellTemplate></DataGridTemplateColumn>--></DataGrid.Columns></DataGrid></Grid>
</Window>//MainWindow.xaml.cs
using CommunityToolkit.Mvvm.ComponentModel;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.Diagnostics;
using System.Runtime.CompilerServices;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using WpfApp5.Services;namespace WpfApp5
{/// <summary>/// Interaction logic for MainWindow.xaml/// </summary>public partial class MainWindow : Window{public MainWindow(){InitializeComponent();}public MainWindow(MainVM vm){InitializeComponent();RenderOptions.ProcessRenderMode=System.Windows.Interop.RenderMode.Default;this.DataContext = vm;Loaded += async (s, e) =>{await vm.InitBooksCollection();};}}public class MainVM : INotifyPropertyChanged{private IIDService idService;private INameService nameService;private IISBNService isbnService;private Stopwatch stopwatch;public MainVM(IIDService idServiceValue, INameService nameServiceValue, IISBNService isbnServiceValue){stopwatch = new Stopwatch();StatusMsg = $"MainWindow,now is {DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")},{GetMemory()},{GetTimeCost()}";idService = idServiceValue;nameService = nameServiceValue;isbnService = isbnServiceValue;}public async Task InitBooksCollection(){stopwatch.Start();BooksCollection = new ObservableCollection<Book>();List<Book> booksList = new List<Book>();await Task.Run(async () =>{for (int i = 1; i < 100000001; i++){booksList.Add(new Book(){Id = idService.GetID(),Name = nameService.GetName(),ISBN = isbnService.GetISBN(),Author = $"Author_{i}",Title = $"Title_{i}",Topic = $"Topic_{i}"});if (i < 1001 && i % 100 == 0){var tempList = booksList.ToList();booksList.Clear();await PopulateBooksCollection(tempList);}else if (i > 1000 && i % 1000000 == 0){var tempList = booksList.ToList();booksList.Clear();await PopulateBooksCollection(tempList);}}if (booksList.Any()){var tempList = booksList.ToList();booksList.Clear();await PopulateBooksCollection(tempList);}});}private async Task PopulateBooksCollection(List<Book> booksList){await Application.Current.Dispatcher.InvokeAsync(() =>{foreach (var bk in booksList){BooksCollection.Add(bk);}StatusMsg = $"MainWindow,now is {DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}," +$"loaded {BooksCollection.Count} items,{GetMemory()},{GetTimeCost()}";}, System.Windows.Threading.DispatcherPriority.Background);System.Diagnostics.Debug.WriteLine(StatusMsg);}private string GetMemory(){double memory = Process.GetCurrentProcess().PrivateMemorySize64;return $"Memory:{memory.ToString("#,##0.00")}";}private string GetTimeCost(){return $"Time cost:{stopwatch.Elapsed.TotalSeconds.ToString("#,##0.00")} seconds";}public event PropertyChangedEventHandler? PropertyChanged;private void OnPropertyChanged([CallerMemberName] string propertyName = ""){var handler = PropertyChanged;if (handler != null){handler?.Invoke(this, new PropertyChangedEventArgs(propertyName));}}private ObservableCollection<Book> booksCollection;public ObservableCollection<Book> BooksCollection{get{return booksCollection;}set{if (value != booksCollection){booksCollection = value;OnPropertyChanged();}}}private string statusMsg;public string StatusMsg{get{return statusMsg;}set{if (value != statusMsg){statusMsg = value;OnPropertyChanged();}}}}public class DelCommand : ICommand{private Action<object?> execute;private Predicate<object?> canExecute;public DelCommand(Action<object?> executeValue, Predicate<object?> canExecuteValue){execute = executeValue;canExecute = canExecuteValue;}public event EventHandler? CanExecuteChanged{add{CommandManager.RequerySuggested += value;}remove{CommandManager.RequerySuggested -= value;}}public bool CanExecute(object? parameter){return canExecute == null ? true : canExecute(parameter);}public void Execute(object? parameter){execute(parameter);}}public class Book{public int Id { get; set; }public string Name { get; set; }public string Author { get; set; }public string Title { get; set; }public string Topic { get; set; }public string ISBN { get; set; }}
}//IDService.cs
using System;
using System.Collections.Generic;
using System.Text;namespace WpfApp5.Services
{public interface IIDService{int GetID();}public class IDService : IIDService{int id = 0;public int GetID(){return Interlocked.Increment(ref id);}}
}//ISBNService.cs
using System;
using System.Collections.Generic;
using System.Text;namespace WpfApp5.Services
{public interface IISBNService{string GetISBN();}public class ISBNService : IISBNService{int idx = 0;public string GetISBN(){return $"ISBN_{Interlocked.Increment(ref idx)}_{Guid.NewGuid():N}";}}
}//NameService.cs
using System;
using System.Collections.Generic;
using System.Text;namespace WpfApp5.Services
{public interface INameService{string GetName();}public class NameService : INameService{int idx = 0;public string GetName(){return $"Name_{Interlocked.Increment(ref idx)}";}}
}