I am converting the following Entity Framework on .NET 4.7.2 code to run on .NET 8.

var item = new Form
               {
                   TokenId = System.Guid.NewGuid().ToString(),
                   BillForm = "B",
                   CompanyNumber = 5,
                   PolicyNumber = "11111111111"
               };

_formRepository.Add(item);
_formRepository.Execute("Call ProgramLibrary.CLProgram");

.NET 8

var item = new Form
               {
                   TokenId = System.Guid.NewGuid().ToString(),
                   BillForm = "B",
                   CompanyNumber = 5,
                   PolicyNumber = "11111111111"
               };

context._formRepository.Add(item);

var result = context.Database.ExecuteSqlRaw("Call ProgramLibrary.CLProgram");

Connection string:

 "AS400Entities": "server=servername;uid=userid;pwd=pasword;database=databasename;Isolation Level=Chaos;"

I am able to access AS400 tables in .NET 8 and update the data, but the CL program is not being executed. The result is returning -1, which indicates failure.

Do you know what I might be missing?

I am converting the following Entity Framework on .NET 4.7.2 code to run on .NET 8.

var item = new Form
               {
                   TokenId = System.Guid.NewGuid().ToString(),
                   BillForm = "B",
                   CompanyNumber = 5,
                   PolicyNumber = "11111111111"
               };

_formRepository.Add(item);
_formRepository.Execute("Call ProgramLibrary.CLProgram");

.NET 8

var item = new Form
               {
                   TokenId = System.Guid.NewGuid().ToString(),
                   BillForm = "B",
                   CompanyNumber = 5,
                   PolicyNumber = "11111111111"
               };

context._formRepository.Add(item);

var result = context.Database.ExecuteSqlRaw("Call ProgramLibrary.CLProgram");

Connection string:

 "AS400Entities": "server=servername;uid=userid;pwd=pasword;database=databasename;Isolation Level=Chaos;"

I am able to access AS400 tables in .NET 8 and update the data, but the CL program is not being executed. The result is returning -1, which indicates failure.

Do you know what I might be missing?

• c#
• db2
• -8.0

Share Improve this question Follow edited Mar 11 at 16:17 marc_s 756k184184 gold badges1.4k1.4k silver badges1.5k1.5k bronze badges asked Mar 11 at 14:48 NakresNakres 1,65211 gold badge1515 silver badges3030 bronze badges 2

• 1 Are those two lines doing the same thing at all? _formRepository.Execute("Call ProgramLibrary.CLProgram"); vs context.Database.ExecuteSqlRaw("Call ProgramLibrary.CLProgram"); ? Is there some error logged on the db system? – Fildor Commented Mar 11 at 14:59
• I am assuming that those lines do the same thing, but I am not sure. I do not have access to logs on the db system. – Nakres Commented Mar 11 at 15:01

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

SaveChanges was missing. That was the issue. It is now working. Result still returns -1 but it executes the CL program.

   context._formRepository.Add(item);
   context.SaveChanges();
   var result = context.Database.ExecuteSqlRaw("Call ProgramLibrary.CLProgram");