Share via

How to connect DB2 (IBM AS400) in .Net 8?

Golftion Alva 0 Reputation points
2024-08-07T15:25:23.9866667+00:00

Hi
For now, I use .Net Framework 4.8.1 to create web APIs (using IBM.Data.DB2.ISeries).

 But I want to use .Net 8 for creating APIs by using data from DB2.   
 Is there a way to connect the database which I don't have to pay for a IBM License?  
```**Thank you**
Community Center Not monitored

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Quentin D 5 Reputation points
    2024-12-17T14:50:48.3066667+00:00

    You can use ODBC as a basic and free solution to connect .NET 8 to DB2 on IBM i, but it can be limited in terms of performance and flexibility.

    For a more advanced option, take a look at NTi Data Provider from Aumerial. It's a new solution, natively built for .NET, requiring no additional drivers or middleware. It provides seamless access to both DB2 data and IBM i programs (CL commands, stored procedures, etc.), with support for EF CORE for DB2 for i.

    More details here: https://www.aumerial.com.

    1 person found this answer helpful.
    0 comments
  2. Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator
    2024-08-07T17:12:01.9366667+00:00

    IBM supplies a nuget package:

    https://www.nuget.org/packages/Net.IBM.Data.Db2/

    in general connecting to any non free database (even Sqlserver) requires a license.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.