NpgSql EntityFramework Core not persisting DateTimeOffset as UTC time in database

I'm using Npgsql.EntityFrameworkCore.PostgreSQL 7.0.4 in my console app to persist DateTimeOffset to PostgreSQL Database. However the values stored in my database are always in Local DateTimeOffset. My local machine is configured with IST time zone which is UTC +05.30.

Here is my code,

DbContext:

public class TestContext : DbContext
{
    public DbSet<Category> Categories { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseNpgsql("Host=localhost;Database=EFDateTime;User id=postgres;Password=xxxx;")
                       .EnableSensitiveDataLogging()
                       .LogTo(Console.WriteLine, Microsoft.Extensions.Logging.LogLevel.Information);
    }
}

Category:

public class Category
{
    public int Id { get; set; }
    public DateTimeOffset DateTimeProperty { get; set; } = DateTimeOffset.UtcNow;
    public DateTimeOffset DateTimeOffsetProperty { get; set; } = DateTimeOffset.UtcNow;
}

I'm creating new DbContext and new Category and saving to database.

var context = new TestContext();
var category = new Category();
context.Categories.Add(category);
context.SaveChanges();

Now when I check the database, I can see Local DateTimeOffset with +05.30 instead of UTC time with +00.00

Here is the query generated by EF Core,

info: 07-08-2023 16:32:19.239 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
      Executed DbCommand (36ms) [Parameters=[@p0='2023-08-07T11:02:16.4694593+00:00' (DbType = DateTime), @p1='2023-08-07T11:02:16.4694577+00:00' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']
      INSERT INTO "Categories" ("DateTimeOffsetProperty", "DateTimeProperty")
      VALUES (@p0, @p1)
      RETURNING "Id";

Here is the screen shot,

If we see the highlighted values in above image, the values generated in the query is in UTC as expected but in database it is in IST.

Script Generated by EF Core command Script-Migration:

CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
    "MigrationId" character varying(150) NOT NULL,
    "ProductVersion" character varying(32) NOT NULL,
    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
);

START TRANSACTION;

CREATE TABLE "Categories" (
    "Id" integer GENERATED BY DEFAULT AS IDENTITY,
    "DateTimeProperty" timestamp without time zone NOT NULL,
    "DateTimeOffsetProperty" timestamp with time zone NOT NULL,
    CONSTRAINT "PK_Categories" PRIMARY KEY ("Id")
);

INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
VALUES ('20230806181121_Initial', '7.0.9');

COMMIT;

START TRANSACTION;

ALTER TABLE "Categories" ALTER COLUMN "DateTimeProperty" TYPE timestamp with time zone;

INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
VALUES ('20230806181852_AddOffset', '7.0.9');

COMMIT;

Please can someone help me understand what I'm doing wrong? I would like to learn and understand this.