Data Management Global

hi,

Does the DB2 nuget package implement DbBatch and batching API?

DbBatch Class (System.Data.Common) | Microsoft Learn
New System.Data.Common batching API · Issue #28633 · dotnet/runtime · GitHub

Thanks!

I migrated from 3.1 to 6.0 and I have an issue every time I do Context.SaveChanges() after modifications made inside a Transaction using BOSContext.Database.BeginTransaction() .. It was working fine in 3.1. This is the error: IBM.Data.Db2.DB2Exception: 'ERROR [42601] [IBM][DB2] SQL0104N  An unexpected token "<END-OF-STATEMENT>" was found following "".  Expected tokens may include:  "ON UNIQUE".' 
Code example:

            using (var transaction = SomeContext.Database.BeginTransaction()){                
                try{
                    var obj = SomeContext.SomeTable.Where(x => x.SomeFieldId == 1).FirstOrDefault()
                    obj.SomeFieldToUpdate= "New Value"; 
                    if (SomeContext.SaveChanges() == 1) //=> Fails here!
                        transaction.Commit()                        
                } catch (Exception){
                    transaction.Rollback();
                    throw;
                }                
            }

Hi Ravin Sankardayal,
can you please start a new thread with this question so that we can have dedicated discussion. We tend to overlook any feature specific discussion here.
Thanks
Vishwa

I have a question regarding this DB2 error code.
I am using entity framework, the latest version.
Schema name is in upper case: TEST
Table name Pascal case: MyTestTable
Define Schema Name and Table Name in Model: [Table("MyTestTable", Schema = "TEST")].
When debugging I am receiving this error: "IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42704] [IBM][DB2/NT64] SQL0204N  "TEST.MYTESTTABLE" is an undefined name."
Note table name is in upper case in error message, DB2 does not recognized the upper case table name.
Can someone assist?

Support for geometry is very spotty in this provider. Rather than returning a binary representation and allowing consumers to handle it themselves, the provider seems to turn the Geometry into WKT and leave out the SRID, which makes handling returned geometries impossible.

For some reasons, finding information about developing .net application to connect with Informix is very difficult. I started to develop an .net app using ODBC Ado.Net provider for .net core 3.1(through nuget package)

Later discovered that there is an Informix provider for ADO.Net through internet forums and old in our organization but very recently I understand it is part of Informix Client-SDK. 

First thing comes to my mind now is the names of the package for each .net versions are different. if some consistency is in the naming of package  , it will be better to be discovered. And also organizing way of the documentation can also be improved. 

In .NET7 support was added for the ppc64le ( IBM Linux on Power) architecture ( https://community.ibm.com/community/user/powerdeveloper/blogs/janani-janakiraman/2022/11/07/net7-support-linux-on-power ).

What is the easiest platform for us to test connectivity from C# on ppc64le to a DB2 Server on a different architecture. What drivers are needed for us to test connectivity in the following scenarios:

• C# on ppc64le accessing DB2 on Linux on AMD64
• C# on ppc64le accessing the database server on IBMi ( assuming it is DB2 under the covers on IBMi)