there is a port of wpf in net.core

// Data model class (replace with your table structure)
public class Customer
{
    public int CustomerID { get; set; }
    public string Name { get; set; }
}

// DbContext class (replace with your connection string)
public class MyDbContext : DbContext
{
    public DbSet Customers { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlite("Data Source=mydatabase.db");
    }
}

// WPF code-behind file (example usage)
public partial class MainWindow : Window
{
    private MyDbContext _context;

    public MainWindow()
    {
        InitializeComponent();
        _context = new MyDbContext();
    }

    private void LoadCustomersButton_Click(object sender, RoutedEventArgs e)
    {
        var customers = _context.Customers.ToList();
        // Bind customers to your WPF list or display them as needed
    }
}

Yes you can leverage WPF (Windows Presentation Foundation) to create desktop applications within a .NET Core environment.

Microsoft made WPF available for .NET Core 3.0, aiming for feature parity with the .NET Framework version. While some minor differences might exist, they should be manageable.

• Install the EF Core NuGet Package:

  • In your project, use the NuGet Package Manager to install the Microsoft.EntityFrameworkCore.Sqlite package (or another provider if you prefer a different database).

• Create a Data Model:

  • Define your data model classes using C# classes that represent your database tables and relationships.

• Configure EF Core:

  • Set up the EF Core context in your application to manage database interactions.

• Access Data in Your WPF Application:

  • Use EF Core's features from your code-behind files or view models to interact with the database, retrieve data, and perform CRUD (Create, Read, Update, Delete) operations.