IBM.EntityFrameworkCore 9.0.0.100

About

IBM.EntityFrameworkCore is a NuGet package that serves as the IBM Data Server provider for Entity Framework Core, enabling .NET applications to interact seamlessly with IBM database servers.

Key Features

Compatibility: Targets .NET 8.0, ensuring compatibility with applications running on this framework or higher. 
Dependencies: Requires Microsoft.EntityFrameworkCore.Relational (version 9.0.1 or higher) and Net.IBM.Data.Db2 (version 9.0.0.200 or higher).

How to use

Use package manager to add package to the project, build it and deploy it as any other .NET NuGet package based deployment. 
In cases where Db2Connect license is needed, the license file needs to be copied to clidriver/license folder of Net.IBM.Data.Db2** package as detailed here:
https://community.ibm.com/community/user/blogs/vishwa-hs1/2020/07/12/db2-net-packages-download-and-configure

Main Types

All ADO.NET Entity Framework (ORM) specification types.

What's New

-Support for Microsoft EF Core 9
-Issue Fixes: The LINQ query may fail with SQL0104N error, when EF application uses table entities, configured with SMALLINT(2) data type against DB2 for z/os database. For example:
	LINQ Query:
		_dbContext.Smalltabs.Where(x =>x.IncnstDspstnNoted !=1);
	Entity Configuration:
		protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Smalltab>(entity =>
            {
                entity
                .HasNoKey()
                .ToTable("SMALLTAB", "SCHEMA1");
                entity.Property(e => e.IncnstDspstnNoted)
                .HasColumnType("smallint(2)")  //this causes wrong SQL generation
                .HasColumnName("INCNST_DSPSTN_NOTED");
                entity.Property(e => e.ItemId)
                .HasColumnType("bigint(8)")
                .HasColumnName("ITEM_ID");
            });
        }

Open Known Issue -Currently Code First support for Db2 for LUW and Db2 for zOS has issues and will not work as expected. It will be supported in future release.

Related Packages

IBM.EntityFrameworkCore  : Windows x64
IBM.EntityFrameworkCore-lnx.  : Linux Amd64
IBM.EntityFrameworkCore-osx  : Mac Arm M1/M2/M3
Net.IBM.EntityFrameworkCore-ppc : Linux ppc64le

How to enable logging

To enable Entity Framework Core (EF Core) logging, applications can be configured to use the simple built-in logging system as detailed here:
https://learn.microsoft.com/en-us/ef/core/logging-events-diagnostics/simple-logging

Requesting support

Please reach out to IBM Tech support for any issues in using this package:
https://www.ibm.com/mysupport/s/?language=en_US