IBM Entity Framework Core Provider mandates the user to provide server platform type, and version in addition to the connection string while configuring DbContext. To pass server information, User can use SetServerInfo(..) method which belongs to the namespace IBM.EntityFrameworkCore.Storage.Internal.
For example:
OptionBuilder.UseDb2(<Connection String>, p=>p.SetServerInfo( <Platform Type>, <Server Version> ));
To connect to a DB2 for zOS Data Server, it would look like:
using IBM.EntityFrameworkCore;
using IBM.EntityFrameworkCore.Storage.Internal;
...
…
namespace MyCoreConsoleApp.Model
{
public partial class MyContext : DbContext
{
…
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseDb2(<Connection String>,
p=>p.SetServerInfo(IBMDBServerType.OS390, IBMDBServerVersion.OS390_11_01 ));
}
…
}
}
The second argument (server version) of SetServerInfo(...) method is optional. If it is not specified, the latest supported version for the respective Database server will be taken as the default. Please refer the following table for detailed information about platform type and server version for the currently supported IBM Data Servers:
| S.No. |
Description |
Platform Type |
Server Version |
| 1. |
Db2 for zOS |
IBMDBServerType.OS390 |
- IBMDBServerVersion.OS390_10_01
- IBMDBServerVersion.OS390_11_01
|
| 2. |
IBM i |
IBMDBServerType.AS400 |
|
| 3. |
Db2 for LUW |
IBMDBServerType.LUW |
-
IBMDBServerVersion.LUW_10_05_08
-
IBMDBServerVersion.LUW_11_01_1010
-
IBMDBServerVersion.LUW_11_01_2020
|
| 4. |
Informix Database Server |
IBMDBServerType.IDS |
-
IBMDBServerVersion.IDS_11_70_7300
-
IBMDBServerVersion.IDS_11_70_8000
-
IBMDBServerVersion.IDS_12_10_2000
|
Note: In the above table, Highlighted Server Version is taken as default, if not specified by user.
#DataManagementGlobal#DataServerDrivers