#:package Npgsql.EntityFrameworkCore.PostgreSQL@10.0.0
#:property PublishAot=false

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;

await using var context = new ProductContext();
await context.Database.EnsureDeletedAsync();
await context.Database.EnsureCreatedAsync();

context.Products.Add(new() { Name = "Product 1" });
await context.SaveChangesAsync();

context.ChangeTracker.Clear();
var product = await context.Products.FirstAsync();
var originalProduct = context.ChangeTracker.Entries().First().OriginalValues.ToObject();
;

public sealed class ProductContext : DbContext
{
    public DbSet<Product> Products { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        => optionsBuilder
            .UseNpgsql("Host=localhost;Username=postgres;Password=postgres;Database=Test")
            .LogTo(Console.WriteLine, LogLevel.Information)
            .EnableSensitiveDataLogging();

    protected override void OnModelCreating(ModelBuilder modelBuilder)
        => modelBuilder.Entity<Product>().ComplexProperty(x => x.Price);
}

public sealed class Product
{
    public int Id { get; private set; }
    public required string Name { get; set; }
    public Price? Price { get; set; }
}

public sealed class Price
{
    public required decimal Amount { get; init; }
    public required int CurrencyId { get; init; }
}