Db2

 View Only
Expand all | Collapse all

Using Entity Framework (EF) with .NET Core 3.1

  • 1.  Using Entity Framework (EF) with .NET Core 3.1

    Posted Mon December 09, 2019 02:14 PM
    Hi,

    Anyone around here have any experience using EF 3.1 with DB2 Connect?

    We only find old articles from developerworks in 2017 (which is now going bye bye Jan 1, 2020).

    Seems the DB2 connect folks have not posted any updates recently.

    Is IBM still maintaining the DB2 EF Core driver??

    ------------------------------
    Mr O.
    ------------------------------

    #Db2


  • 2.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue December 10, 2019 07:29 PM
    Great question and I would love to know the answer as well. I have even emailed my IBM Rep. and he doesn't have a clue.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 3.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed December 11, 2019 11:44 AM
    Let me know if you hear back on a date for support!

    ------------------------------
    Mr O.
    ------------------------------



  • 4.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu December 12, 2019 10:19 AM
    FYI, I did open a case to check on EF 6.3/6.4 support in .NET Core as it would be a very easy way to port existing EF 6 full framework applications to .NET Core, and they currently do not have support.

    I have entered a RFE here. Go vote on it!

    https://ibm-data-and-ai.ideas.aha.io/ideas/DB2CON-I-49

    ------------------------------
    Mr O.
    ------------------------------



  • 5.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu January 09, 2020 08:41 AM
    From the answers, I am getting nobody has any idea about the status of .NET Core 3.x DB2 EF client, which worries me because it takes IBM years to update anything for .NET.  And .NET Core 2.2 is not supported anymore and there is no DB2 .NET client for .NET 3.1 so we are stuck with .NET 2.2 and developing applications for .NET Core 2.2 or .NET 4.8 or going to Java, maybe that's what IBM wants.  Or maybe I am not looking at the right places.

    ------------------------------
    Peter Czurak
    ------------------------------



  • 6.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri January 10, 2020 08:48 AM
    Definitely not a good sign and what you have found is consistent with what I have been able to find. After being bounced around to multiple IBM "experts" none of them seem to even know what .NET Core is, much less how IBM is going to support it in the future. IBM should either just stop pretending they want to integrate with other systems or either get serious about it.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 7.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri January 10, 2020 09:30 AM
    The astonishing thing is IBM bought out Red Hat and Red Hat does support .NET Core 3.1, but IBM to connect to their own database does not.  This puts my employer and me in a rock and a hard place.  We have an ERP system that's using DB2 as the backend so there's zero chance we are going to switch, because of a huge expense. Most of our custom programs written to support this ERP system are written in C# .NET 4.x. And to re-write those in java or anything else is a no go as well for the same reason.  .NET 5 is coming out this year so we should be writing any new projects in .NET Core 3.1, but we are stuck with .NET 4.x.  And what happens if IBM does not create .Net Core 3 DB2 client?

    I don't understand why IBM dropped the ball on this, it's all open source it's not like they don't have specs and they could get those specs for years before it was released as production product.  Especially when they have .NET Core 2.2 Db2 client so I can't imagine it would take a lot to make it work with 3.1.  But at the speed, IBM works even if they started today it would take a couple of years before we would see it so I hope they have something in the works already.  But I am looking for a workaround.

    ------------------------------
    Peter Czurak
    ------------------------------



  • 8.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Sun January 12, 2020 11:03 PM
    Hi,
     work on .NET Core support is in progress and should be done with in the first half of 2020 or earlier.

    Yes, from .NET Core 2.2 to .NET 3.1, it should have been a simple upgrade but we are noticing many breaking changes in MS .NET Core which is affecting our Entity Framework support.

    I will be following your messages and would try to provide any updates we have. If you are interested in alpha programs of IBM .NET Core 3.1, please contact IBM customer support indicating the same.

    Thanks
    Vishwa

    ------------------------------
    Vishwa hs
    ------------------------------



  • 9.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Mon January 13, 2020 09:44 AM
    That's encouraging news!

    Yes, nothing is simple, but what I mean is a lot simpler than going from .NET 4.8  to .NET Core 3.1.

    I would like to be part of alpha programs.
    Thanks for the response.

    Peter

    ------------------------------
    Peter Czurak
    ------------------------------



  • 10.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Mon January 13, 2020 09:50 AM
    Vishwa,

    I would also like to be part of the beta/alpha program.

    Can you also tell me if you will be working on a .NET Standard 2.1 version to work with EF 6.4?

    This is very important for people looking for a very mature EF version to use in .NET Core that have a lot of investment in existing EF 6.X series in their applications.

    Thanks!


    ------------------------------
    Mr O.
    ------------------------------



  • 11.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu February 13, 2020 01:51 PM
    Can you clarify who is working on those drivers?  Is it a partner of IBM, or IBM itself?  When completed who will be able to obtain those drivers?  The soon to be close site at: https://www.ibm.com/developerworks/community/blogs/96960515-2ea1-4391-8170-b0515d08e4da/entry/DB2DotnetCore?lang=en indicates that version 2.0 of the drivers are not available on NuGet but only on IBM Passport Advantage.   That was dated 3 years ago, is that still the case? Will that remain the case for the version that supports .NET core 3.1?



    ------------------------------
    Ben Bolton
    ------------------------------



  • 12.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu February 13, 2020 10:56 PM
    Hi,
     Rocket Software is the development partner and rest all is IBM. Due to Export Compliance issue with NuGet, IBM has blocked NuGet upload of packages. It may change in future but till then IBM download site is the only option to get these packages. Even .NET Core 3.1 will be through IBM downloads only. If you are interested in an early adaption of .NET Core 3.1 alpha, please contact IBM customer support.

    Thanks
    Vishwa

    ------------------------------
    Vishwa hs
    ------------------------------



  • 13.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed April 15, 2020 05:41 PM
    Hi!
    Has a website been made available for download yet?

    ------------------------------
    Fernando Pires
    ------------------------------



  • 14.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu April 16, 2020 12:26 AM
    Hi Fernando,
     its not yet available for download for public. There are some customers who have signed up for Alpha program and are using it in their environments and providing us early feedback. If you are interested in signing up for Alpha program, please contact IBM customer support.

    Thanks and regards
    Vishwa

    ------------------------------
    Hosathota Vishwanatha
    ------------------------------



  • 15.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu May 14, 2020 03:50 PM
    > its not yet available for download for public

    When it is available to the public, where will it be published?

    While looking through the IBM site, we can't even find the current version (2.0.0.100).

    ------------------------------
    Chris Irwin
    ------------------------------



  • 16.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri May 15, 2020 02:23 AM
    Hi Chris,
     Db2 .NET Core 3.1 is planned for June 2020 and will be available through IBM downloads. The 2.0 version is available through IBM fix central and Passport advantage and you can contact IBM support to get the exact part numbers to use. At present there is an Alpha program for Db2 .NET Core 3.1 and if you are interested, please contact IBM support requesting for the same.

    Thanks
    Vishwa

    ------------------------------
    Hosathota Vishwanatha
    ------------------------------



  • 17.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu May 28, 2020 08:07 AM
    Some vendors are starting to release Beta versions for .NET 5 and here's IBM still sitting on an alpha version for .NET 3.1 with general release nowhere insight.

    Thanks
    Peter

    #Db2


  • 18.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu May 28, 2020 09:01 AM
    It's really embarrassing that a company as big as IBM can't figure this out or chooses not to.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 19.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu May 28, 2020 09:25 AM
    Especially when project decisions hinge on this. It's not like I want to update to the next upgrade of Windows, They are costing us money because we have to develop using unsupported technology .NET Core 2 or outdated technology .NET 4.8 where if we want to upgrade later on we will have to do a complete re-write. Do they have a really hard time updating their drivers to .NET 3.1 or they just arrogant "you will upgrade whenever we tell you on our terms and timeline"? We don't know because there is no communication from IBM. No timeline or progress or anything official. Once these drivers are out can we trust IBM if there is a bug they will fix it in a timely manner or will it take months or years? But I don't think IBM cares.



    #Db2


  • 20.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu May 28, 2020 10:07 AM
    I know before they moved to this new forum it was basically 1 or 2 guys working on this in India along with several other database projects. I am assuming that is still the case. I think IBM has always been a decade behind the curve on most things businesses actually use. It makes our lives difficult, but I don't think they really care. My IBM guy won't even come see me anymore because I hammer him on issues like this constantly. He just wants to sell me new hardware and licenses.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 21.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu July 02, 2020 12:20 PM
    I have been a part of alpha since the beginning of March 2020 and the alpha program is so bizarre. I think there's only one developer working part-time on this.  There are hardly any updates, the version number never changes even when there are updates, the original issue I had in March has never been fixed, I never get notified when there are updates, maybe there are no updates just a recompilation, but how would I know the version number never changes.

    Realize this is the middle of May and they are "planning" on heaving a release version by June 2020 and we are still in the "Alpha" stage. Keep in mind June 30, 2020, is still June 2020 so don't get your hopes up for June 1st, 2020, it will be more likely June 2021. And the issue I was having that was never fixed, the new driver for .Net Core 3.1 won't work if there are any other DB2 drivers installed on your computer or the server.  So if you have an application that's using ODBC sorry you can't run it on the same computer. I guess it's a minor thing for IBM, everyone should just spin a VM for each application. It's unbelievable a huge company like IBM treating this as a spare-time project. Like I said the whole thing is just bizarre.

    #Db2


  • 22.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Mon July 06, 2020 08:19 AM
    Re: the issue of multiple drivers including .NET Core.   We believe that a machine should be able to have multiple DS Drivers.  We have tested this in the lab and support this type of configuration.. 
     
    If this continues to be an issue, please open a PMR and it will be looked at.  
     
     

    Michael Connor
    Program Director, Hybrid Data Management -
    Open Source Db Offering Management
    IBM Software Group
    919 543 4385






  • 23.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 08, 2020 11:54 AM
    Michael,

    On July 6th you said that multiple DS drivers were supported, but just today IBM updated the instructions and the instructions state we have to remove all other drivers. Which is correct?


    Instructions for downloading and using the package

        The following are the prerequisites for using the package

    • Any other IBM DB Drivers should not be present in the machine.
    • Path/LD_LIBRARY_PATH needs to be updated to include the package driver path.

    Updated today:
    https://community.ibm.com/community/user/hybriddatamanagement/blogs/michelle-betbadal1/2020/04/29/getting-started-with-ibm-net-provider-for-net-core

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 24.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri July 10, 2020 12:42 AM
    Hi Jeremy,
     this restriction is not applicable for Db2 .NET Core driver for Windows. This was a restriction which was in place for Db2 .NET Core drivers from the beginning and we are trying to remove it. This restriction is still there on Linux due to our dependency on the native library path and we are working on it. We are in the process of updating some of these older blogs to reflect what is applicable in Db2 .NET Core 3.1 driver.

    Thanks
    Vishwa

    ------------------------------
    Hosathota Vishwanatha
    ------------------------------



  • 25.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu April 30, 2020 08:58 AM
    Kind of amazing to me that every other database company in the world can do NuGet except IBM.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 26.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri May 01, 2020 09:25 AM
    Yes, it's very disappointing that they can't make it easy on their clients.

    I'm a big advocate internally at my company for DB2, but not having up-to-date drivers (especially when we are primarily a .NET development shop) makes it harder and harder to suggest using DB2 over something like SQL Server or Postgres.

    For example, the Postgres driver ( https://www.npgsql.org/doc/index.html ) already has preliminary Entity Framework Core 5.0 support in their GitHub repository ( https://github.com/npgsql/efcore.pg ). And all of that work is done by basically one person! It's hard to say that we should keep using DB2 when IBM does not even have EF Core 3.0 support yet, and it's been several months since EF Core 3.0 has been out (Postgres support came 3 days after EF Core 3.0 was announced).

    And it's even harder for someone who has never used it to "just try" DB2 as their database engine when you can't even get the drivers without going through a huge process to get them from IBM.

    ------------------------------
    Bryan Hamby
    ------------------------------



  • 27.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri May 01, 2020 10:06 AM
    Exactly Bryan. With all the other big database vendors the driver is typically included also. It's open source for goodness sake. IBM wants you to buy a $20K+ license on top of what you already spent for DB2 or in my case an entire IBM i server. That is the real reason they don't use NuGet in my opinion. They have to use IBM Passport to collect the money. So basically you have to pay twice just to develop for DB2. 1970's IBM for you.

    I have already told our ERP vendor who offers both MS SQL and DB2 versions that the next upgrade will be a move over to MS SQL. 

    By the time IBM gets .NET Core 3.1 out of Alpha, most people will be developing using the next version.


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 28.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri May 01, 2020 12:02 PM
    Yes, it's very concerning how slow IBM is with this. They must have one developer working part-time on this. I am working with alpha version and there has been virtually no updates for months.  And the alpha version is not usable even for testing.
    I do not understand this! Unless they don't think .NET Core / .NET 5 is going anywhere and they don't want to waste any resources on this. You would think they would want developers to write applications for their database in any language or environment! Especially when you can write an application to work with multiple/any OS. Most of the time database vendors have their drivers working ahead of tools release, but all we get is crickets from IBM. Not even a timetable.
    Maybe they can't give us the Timetable because they can't get the data because they don't have the driver :)

    #Db2


  • 29.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri May 01, 2020 12:02 PM
    This is our issue:

    IBM wants you to buy a $20K+ license on top of what you already spent for DB2

    Coming from a non-IBMi shop into one as a developer, this licence/cost just seems ridiculous. Has anyone successfully found an alternative, even without using .NET directly, but with some sort of modern language. It is hard to stomach that I may have to resort to building a REST API in PHP to gain access to the data.


    ------------------------------
    Shaun Steckley
    ------------------------------



  • 30.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 04, 2020 11:30 PM

    Hello!

    Just a couple of things to say on driver availability.

    1. There are different sorts of Db2, typically one can find at least three: Db2 (aka DB2 LUW), Db2 for z/OS (mainframe, aka System z story) and Db2 for i (aka iSeries or AS/400).
    2. The first one (Db2 LUW) has the drivers included at no additional fee. So talking about the 20K fee is simply not correct,
    3. The second (Db2 for z/OS) requires Db2 Connect product, unless you run your application on the mainframe too.
    4. The third (iSeries) comes with its own specialized drivers (JDBC and ODBC, surprise - no .Net stuff at all), but can be used with Db2 Connect too. Normally Db2 Connect is not requires there, unless there are technical reasons to need it.
    5. The customers with the active support contract receive driver updates as they arrive, similarly to the updates to the database product they use. These updates are the part of the support service.
    6. In order to raise the priority of supporting new sorts of .Net Core technology in the drivers, it is worth to file (and vote for) an Request For Enhancement (RFE) at https://ibm-data-and-ai.ideas.aha.io/, and probably to send the link to your IBM salesperson.


    #Db2


  • 31.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 12:50 AM
    2) If IBM would release database drivers for their own database in a timely manner many be the 20K rumors would not start. What do we suppose to think when there is nothing from IBM, not even a timeline?
    5) My employer has and we had for years an active support contract and I have never received a DB2 driver for .NET Core. it does not come with the Driver download you have to hunt it down to find it.
    6) So you want us to raise the priority for a product that does not exist. All other database vendors make sure the drivers exist as new technology comes to market, but not IBM. So you want a customer to request a driver for .Net Core 3.1 a technology that has been in production since November 2019. Not officially but through this forum, it was noted that the driver will be released this month, but we supposed to make a request to raise the priority, so maybe then we will get the updated driver ...in what 2 years? 

    I go to Request For Enhancement (RFE) and I see all those comments about .NET 3.1, why even bother to waste my time IBM is not going to do anything. Maybe the #2 item is correct.

    Like I said before totally bizarre.​

    #Db2


  • 32.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 09:08 AM
    1. For me I am specifically talking about DB2 for IBM i. I realize there are different drivers available, but this topic was specifically for the .NET Core 3+ driver. 

    2. I was the one bringing up the 20K license, because again I am talking about the IBM i. To get an Entity Framework capable .NET driver for DB2 for i, it is over $20K. This is NOT the .NET Core 3+ driver. This is just an EF capable .NET driver.

    3. Based on your answer... 2 of your 3 products require at minimum a $20K or more license 

    4. I believe IBM renamed the IBM i from iSeries in 2006. The IBM i does support and come with a .NET driver through ACS. The fact you say there is no .NET stuff at all tells me you might not even know anything about it.

    Why would anyone use ODBC or something based on Java with a large scale .NET application? The .NET driver provided by IBM doesn't support Entity Framework at all. As with other drivers  you have to jump through hoops, get a special download, etc... to even get it. Keep in mind that EF came out in 2008 and IBM still hasn't updated the .NET driver. 2008!!!  There are "technical reasons" for DB2 Connect. You need the $20K license just to use EF from 2008.

    5. There are no driver updates. That is the problem. IBM doesn't have current drivers and the ones they do have are not updated. These drivers don't just "come with your support contract". For the IBM i specifically you have to have ANOTHER licensed product to even get them. Nothing to do with a support contract. Furthermore, when you ask IBM about ANY of these drivers they are just lost. There is obviously zero training provided by IBM about connectivity to their own DB2 databases.  

    6. ​RFE is a joke. The last time .NET Core was listed in an RFE it was closed without any comment from IBM.


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 33.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 09:26 AM
    Now I see why IBM does not respond to these messages, it's because they are clueless about their own product so they are better of not responding.
    Unless there is some other place on IBM's website where you can get these drivers or any information about future development and we are making a big deal out of nothing. 
    IBM is lucky they have these kinds of customers that voice their opinion instead of just leaving. Can you just imagine going to Walmart and there are no carts and a Walmart employee telling you should write a request to have carts ready?

    #Db2


  • 34.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Community Leadership
    Posted Fri June 05, 2020 11:30 AM
    Hi Peter,

    Well, I go to Randall's myself. Walmart kinda gives me the willies, ya know?

    Since your frustrations were brought to my attention, I've been locating the appropriate folks and directing them towards this thread and asking them to help. Prem is already on-thread and responding. I've also asked the OM for the driver portion of the product to take a look, and am reaching out to the part of the org that works on the software as well.

    I apologize for not responding sooner, but as the site manager for all of Hybrid Data Management, it's sometimes difficult to track all the threads of all the forums of the 15+ groups on the community. Feel free to reach out to me in future if you encounter similar frustrations, and I'll do my best to direct the right person to you.

    Doug

    ------------------------------
    Doug Moran
    ------------------------------



  • 35.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 11, 2020 12:04 PM
    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  https://stackoverflow.com/questions/62327380/using-ibm-data-db2-core-to-connect-to-db2-error-when-trying-to-open-connection?noredirect=1#comment110233035_62327380

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to https://community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis
    ------------------------------



  • 36.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 11, 2020 12:58 PM
    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    #Db2


  • 37.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 11, 2020 01:32 PM

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  




     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  https://stackoverflow.com/questions/62327380/using-ibm-data-db2-core-to-connect-to-db2-error-when-trying-to-open-connection?noredirect=1#comment110233035_62327380

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to https://community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

    Original Message:
    Sent: Sun January 12, 2020 11:03 PM
    From: Hosathota Vishwanatha
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi,
     work on .NET Core support is in progress and should be done with in the first half of 2020 or earlier.

    Yes, from .NET Core 2.2 to .NET 3.1, it should have been a simple upgrade but we are noticing many breaking changes in MS .NET Core which is affecting our Entity Framework support.

    I will be following your messages and would try to provide any updates we have. If you are interested in alpha programs of IBM .NET Core 3.1, please contact IBM customer support indicating the same.

    Thanks
    Vishwa

    ------------------------------
    Vishwa hs

    Original Message:
    Sent: Fri January 10, 2020 09:30 AM
    From: Peter Czurak
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    The astonishing thing is IBM bought out Red Hat and Red Hat does support .NET Core 3.1, but IBM to connect to their own database does not.  This puts my employer and me in a rock and a hard place.  We have an ERP system that's using DB2 as the backend so there's zero chance we are going to switch, because of a huge expense. Most of our custom programs written to support this ERP system are written in C# .NET 4.x. And to re-write those in java or anything else is a no go as well for the same reason.  .NET 5 is coming out this year so we should be writing any new projects in .NET Core 3.1, but we are stuck with .NET 4.x.  And what happens if IBM does not create .Net Core 3 DB2 client?

    I don't understand why IBM dropped the ball on this, it's all open source it's not like they don't have specs and they could get those specs for years before it was released as production product.  Especially when they have .NET Core 2.2 Db2 client so I can't imagine it would take a lot to make it work with 3.1.  But at the speed, IBM works even if they started today it would take a couple of years before we would see it so I hope they have something in the works already.  But I am looking for a workaround.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Fri January 10, 2020 08:48 AM
    From: Jeremy Bowling
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Definitely not a good sign and what you have found is consistent with what I have been able to find. After being bounced around to multiple IBM "experts" none of them seem to even know what .NET Core is, much less how IBM is going to support it in the future. IBM should either just stop pretending they want to integrate with other systems or either get serious about it.

    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Thu January 09, 2020 07:54 AM
    From: Peter Czurak
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    From the answers, I am getting nobody has any idea about the status of .NET Core 3.x DB2 EF client, which worries me because it takes IBM years to update anything for .NET.  And .NET Core 2.2 is not supported anymore and there is no DB2 .NET client for .NET 3.1 so we are stuck with .NET 2.2 and developing applications for .NET Core 2.2 or .NET 4.8 or going to Java, maybe that's what IBM wants.  Or maybe I am not looking at the right places.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Thu December 12, 2019 10:18 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    FYI, I did open a case to check on EF 6.3/6.4 support in .NET Core as it would be a very easy way to port existing EF 6 full framework applications to .NET Core, and they currently do not have support.

    I have entered a RFE here. Go vote on it!

    https://ibm-data-and-ai.ideas.aha.io/ideas/DB2CON-I-49

    ------------------------------
    Mr O.

    Original Message:
    Sent: Wed December 11, 2019 11:44 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Let me know if you hear back on a date for support!

    ------------------------------
    Mr O.

    Original Message:
    Sent: Tue December 10, 2019 03:05 PM
    From: Jeremy Bowling
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Great question and I would love to know the answer as well. I have even emailed my IBM Rep. and he doesn't have a clue.

    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Mon December 09, 2019 11:24 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi,

    Anyone around here have any experience using EF 3.1 with DB2 Connect?

    We only find old articles from developerworks in 2017 (which is now going bye bye Jan 1, 2020).

    Seems the DB2 connect folks have not posted any updates recently.

    Is IBM still maintaining the DB2 EF Core driver??

    ------------------------------
    Mr O.
    ------------------------------

    #Db2


  • 38.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 11, 2020 02:43 PM
    Looks like it's going to be a NuGet package, but I don't know where it's going to be hosted.

    #Db2


  • 39.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 12, 2020 12:45 AM
    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 40.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 12, 2020 05:47 AM

    Hi Premkumar, thank you for your email. 

     

    1. Do you know if the issue I am facing will definitely been resolved in the next release?  stackoverflow.com/questions/62327380/...
    2. Is the next release on schedule for end of June 2020 still? 
    3. How can I get hold of the Beta version so I can test sooner?
    4. It is crucial on the project I am working on right now to enable connectivity to on prem DB2 database from Azure (Either using a WebApp or a Function App), either way the code will be written in .Net Core 3.x.  Do you know if this will be supported in your next release? 
    5. Also, if you are not releasing a Nuget package what kind of alternative package can we expect?  I.e.  Dll, installer or drivers?

     

    Thank you again and I look forward to hearing from you.

     

    Dino

     

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Premkumar Swaminathan

    Jun 12, 2020 12:45 AM

    Premkumar Swaminathan

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 12:45:00 AM
    From: Premkumar Swaminathan
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------

    Original Message:
    Sent: Thu June 11, 2020 01:32 PM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  https://stackoverflow.com/questions/62327380/using-ibm-data-db2-core-to-connect-to-db2-error-when-trying-to-open-connection?noredirect=1#comment110233035_62327380

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to https://community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

    Original Message:
    Sent: Sun January 12, 2020 11:03 PM
    From: Hosathota Vishwanatha
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi,
     work on .NET Core support is in progress and should be done with in the first half of 2020 or earlier.

    Yes, from .NET Core 2.2 to .NET 3.1, it should have been a simple upgrade but we are noticing many breaking changes in MS .NET Core which is affecting our Entity Framework support.

    I will be following your messages and would try to provide any updates we have. If you are interested in alpha programs of IBM .NET Core 3.1, please contact IBM customer support indicating the same.

    Thanks
    Vishwa

    ------------------------------
    Vishwa hs

    Original Message:
    Sent: Fri January 10, 2020 09:30 AM
    From: Peter Czurak
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    The astonishing thing is IBM bought out Red Hat and Red Hat does support .NET Core 3.1, but IBM to connect to their own database does not.  This puts my employer and me in a rock and a hard place.  We have an ERP system that's using DB2 as the backend so there's zero chance we are going to switch, because of a huge expense. Most of our custom programs written to support this ERP system are written in C# .NET 4.x. And to re-write those in java or anything else is a no go as well for the same reason.  .NET 5 is coming out this year so we should be writing any new projects in .NET Core 3.1, but we are stuck with .NET 4.x.  And what happens if IBM does not create .Net Core 3 DB2 client?

    I don't understand why IBM dropped the ball on this, it's all open source it's not like they don't have specs and they could get those specs for years before it was released as production product.  Especially when they have .NET Core 2.2 Db2 client so I can't imagine it would take a lot to make it work with 3.1.  But at the speed, IBM works even if they started today it would take a couple of years before we would see it so I hope they have something in the works already.  But I am looking for a workaround.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Fri January 10, 2020 08:48 AM
    From: Jeremy Bowling
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Definitely not a good sign and what you have found is consistent with what I have been able to find. After being bounced around to multiple IBM "experts" none of them seem to even know what .NET Core is, much less how IBM is going to support it in the future. IBM should either just stop pretending they want to integrate with other systems or either get serious about it.

    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Thu January 09, 2020 07:54 AM
    From: Peter Czurak
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    From the answers, I am getting nobody has any idea about the status of .NET Core 3.x DB2 EF client, which worries me because it takes IBM years to update anything for .NET.  And .NET Core 2.2 is not supported anymore and there is no DB2 .NET client for .NET 3.1 so we are stuck with .NET 2.2 and developing applications for .NET Core 2.2 or .NET 4.8 or going to Java, maybe that's what IBM wants.  Or maybe I am not looking at the right places.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Thu December 12, 2019 10:18 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    FYI, I did open a case to check on EF 6.3/6.4 support in .NET Core as it would be a very easy way to port existing EF 6 full framework applications to .NET Core, and they currently do not have support.

    I have entered a RFE here. Go vote on it!

    https://ibm-data-and-ai.ideas.aha.io/ideas/DB2CON-I-49

    ------------------------------
    Mr O.

    Original Message:
    Sent: Wed December 11, 2019 11:44 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Let me know if you hear back on a date for support!

    ------------------------------
    Mr O.

    Original Message:
    Sent: Tue December 10, 2019 03:05 PM
    From: Jeremy Bowling
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Great question and I would love to know the answer as well. I have even emailed my IBM Rep. and he doesn't have a clue.

    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Mon December 09, 2019 11:24 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi,

    Anyone around here have any experience using EF 3.1 with DB2 Connect?

    We only find old articles from developerworks in 2017 (which is now going bye bye Jan 1, 2020).

    Seems the DB2 connect folks have not posted any updates recently.

    Is IBM still maintaining the DB2 EF Core driver??

    ------------------------------
    Mr O.
    ------------------------------

    #Db2


  • 41.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 12, 2020 09:16 AM
    Dino,

    Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license just to get the .NET Core driver. At a minimum you are looking at $20,000 just to be able to connect to their database. 


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 42.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 12, 2020 09:30 AM

    Jeremy, thanks for your message. 

     

    The client I am working with already has a DB2 license.  Are you saying that to connect to their existing DB2 database, which they probably already pay licensing costs towards, they have to pay a further $20k just to connect to it from their Azure infrastructure?   

     

    Thanks, please clarify as this will have a significant impact on our project.  I thought that with the IBM.Data.DB2.Core nuget package I would be able to connect as part of the client's existing DB2 licensing.

     

    Dino

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino, Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Jeremy Bowling

    Jun 12, 2020 9:16 AM

    Jeremy Bowling

    Dino,

    Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license just to get the .NET Core driver. At a minimum you are looking at $20,000 just to be able to connect to their database. 


    ------------------------------
    Jeremy Bowling
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Hi Premkumar, thank you for your email. 

     

    1. Do you know if the issue I am facing will definitely been resolved in the next release?  stackoverflow.com/questions/62327380/...
    2. Is the next release on schedule for end of June 2020 still? 
    3. How can I get hold of the Beta version so I can test sooner?
    4. It is crucial on the project I am working on right now to enable connectivity to on prem DB2 database from Azure (Either using a WebApp or a Function App), either way the code will be written in .Net Core 3.x.  Do you know if this will be supported in your next release? 
    5. Also, if you are not releasing a Nuget package what kind of alternative package can we expect?  I.e.  Dll, installer or drivers?

     

    Thank you again and I look forward to hearing from you.

     

    Dino

     

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Premkumar Swaminathan

    Jun 12, 2020 12:45 AM

    Premkumar Swaminathan

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 01:32 PM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 12:45:00 AM
    From: Premkumar Swaminathan
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 9:16:00 AM
    From: Jeremy Bowling
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino,

    Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license just to get the .NET Core driver. At a minimum you are looking at $20,000 just to be able to connect to their database. 


    ------------------------------
    Jeremy Bowling
    ------------------------------

    Original Message:
    Sent: Fri June 12, 2020 05:47 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Premkumar, thank you for your email. 

     

    1. Do you know if the issue I am facing will definitely been resolved in the next release?  stackoverflow.com/questions/62327380/...
    2. Is the next release on schedule for end of June 2020 still? 
    3. How can I get hold of the Beta version so I can test sooner?
    4. It is crucial on the project I am working on right now to enable connectivity to on prem DB2 database from Azure (Either using a WebApp or a Function App), either way the code will be written in .Net Core 3.x.  Do you know if this will be supported in your next release? 
    5. Also, if you are not releasing a Nuget package what kind of alternative package can we expect?  I.e.  Dll, installer or drivers?

     

    Thank you again and I look forward to hearing from you.

     

    Dino

     

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Premkumar Swaminathan

    Jun 12, 2020 12:45 AM

    Premkumar Swaminathan

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 01:32 PM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 12:45:00 AM
    From: Premkumar Swaminathan
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan

    Original Message:
    Sent: Thu June 11, 2020 01:32 PM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  https://stackoverflow.com/questions/62327380/using-ibm-data-db2-core-to-connect-to-db2-error-when-trying-to-open-connection?noredirect=1#comment110233035_62327380

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to https://community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

    Original Message:
    Sent: Sun January 12, 2020 11:03 PM
    From: Hosathota Vishwanatha
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi,
     work on .NET Core support is in progress and should be done with in the first half of 2020 or earlier.

    Yes, from .NET Core 2.2 to .NET 3.1, it should have been a simple upgrade but we are noticing many breaking changes in MS .NET Core which is affecting our Entity Framework support.

    I will be following your messages and would try to provide any updates we have. If you are interested in alpha programs of IBM .NET Core 3.1, please contact IBM customer support indicating the same.

    Thanks
    Vishwa

    ------------------------------
    Vishwa hs

    Original Message:
    Sent: Fri January 10, 2020 09:30 AM
    From: Peter Czurak
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    The astonishing thing is IBM bought out Red Hat and Red Hat does support .NET Core 3.1, but IBM to connect to their own database does not.  This puts my employer and me in a rock and a hard place.  We have an ERP system that's using DB2 as the backend so there's zero chance we are going to switch, because of a huge expense. Most of our custom programs written to support this ERP system are written in C# .NET 4.x. And to re-write those in java or anything else is a no go as well for the same reason.  .NET 5 is coming out this year so we should be writing any new projects in .NET Core 3.1, but we are stuck with .NET 4.x.  And what happens if IBM does not create .Net Core 3 DB2 client?

    I don't understand why IBM dropped the ball on this, it's all open source it's not like they don't have specs and they could get those specs for years before it was released as production product.  Especially when they have .NET Core 2.2 Db2 client so I can't imagine it would take a lot to make it work with 3.1.  But at the speed, IBM works even if they started today it would take a couple of years before we would see it so I hope they have something in the works already.  But I am looking for a workaround.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Fri January 10, 2020 08:48 AM
    From: Jeremy Bowling
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Definitely not a good sign and what you have found is consistent with what I have been able to find. After being bounced around to multiple IBM "experts" none of them seem to even know what .NET Core is, much less how IBM is going to support it in the future. IBM should either just stop pretending they want to integrate with other systems or either get serious about it.

    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Thu January 09, 2020 07:54 AM
    From: Peter Czurak
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    From the answers, I am getting nobody has any idea about the status of .NET Core 3.x DB2 EF client, which worries me because it takes IBM years to update anything for .NET.  And .NET Core 2.2 is not supported anymore and there is no DB2 .NET client for .NET 3.1 so we are stuck with .NET 2.2 and developing applications for .NET Core 2.2 or .NET 4.8 or going to Java, maybe that's what IBM wants.  Or maybe I am not looking at the right places.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Thu December 12, 2019 10:18 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    FYI, I did open a case to check on EF 6.3/6.4 support in .NET Core as it would be a very easy way to port existing EF 6 full framework applications to .NET Core, and they currently do not have support.

    I have entered a RFE here. Go vote on it!

    https://ibm-data-and-ai.ideas.aha.io/ideas/DB2CON-I-49

    ------------------------------
    Mr O.

    Original Message:
    Sent: Wed December 11, 2019 11:44 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Let me know if you hear back on a date for support!

    ------------------------------
    Mr O.

    Original Message:
    Sent: Tue December 10, 2019 03:05 PM
    From: Jeremy Bowling
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Great question and I would love to know the answer as well. I have even emailed my IBM Rep. and he doesn't have a clue.

    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Mon December 09, 2019 11:24 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi,

    Anyone around here have any experience using EF 3.1 with DB2 Connect?

    We only find old articles from developerworks in 2017 (which is now going bye bye Jan 1, 2020).

    Seems the DB2 connect folks have not posted any updates recently.

    Is IBM still maintaining the DB2 EF Core driver??

    ------------------------------
    Mr O.
    ------------------------------

    #Db2


  • 43.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 12, 2020 09:36 AM
    Sorry, should clarify better. If your client has DB2 LUW (Linux, Unix, Windows) then you should be good because they will have the license. If they are using any other DB2 database like DB2 for i, the license has to be purchased separately. 


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 44.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 12, 2020 09:50 AM

    Hi Jeremy, thanks for clarifying with a swift reply.  I am reliably told that we are on IBM i on the AS/400 OS & hardware platform.  I guess that means we have to license connections from Azure separately - not sure how this will go down with the SLT.

     

    Dino

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Sorry, should clarify better. If your client has DB2 LUW (Linux, Unix, Windows) then you should be good because they will have the license. If... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Jeremy Bowling

    Jun 12, 2020 9:36 AM

    Jeremy Bowling

    Sorry, should clarify better. If your client has DB2 LUW (Linux, Unix, Windows) then you should be good because they will have the license. If they are using any other DB2 database like DB2 for i, the license has to be purchased separately. 


    ------------------------------
    Jeremy Bowling
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Jeremy, thanks for your message. 

     

    The client I am working with already has a DB2 license.  Are you saying that to connect to their existing DB2 database, which they probably already pay licensing costs towards, they have to pay a further $20k just to connect to it from their Azure infrastructure?   

     

    Thanks, please clarify as this will have a significant impact on our project.  I thought that with the IBM.Data.DB2.Core nuget package I would be able to connect as part of the client's existing DB2 licensing.

     

    Dino

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino, Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Jeremy Bowling

    Jun 12, 2020 9:16 AM

    Jeremy Bowling

    Dino,

    Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license just to get the .NET Core driver. At a minimum you are looking at $20,000 just to be able to connect to their database. 


    ------------------------------
    Jeremy Bowling
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Fri June 12, 2020 05:47 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Premkumar, thank you for your email. 

     

    1. Do you know if the issue I am facing will definitely been resolved in the next release?  stackoverflow.com/questions/62327380/...
    2. Is the next release on schedule for end of June 2020 still? 
    3. How can I get hold of the Beta version so I can test sooner?
    4. It is crucial on the project I am working on right now to enable connectivity to on prem DB2 database from Azure (Either using a WebApp or a Function App), either way the code will be written in .Net Core 3.x.  Do you know if this will be supported in your next release? 
    5. Also, if you are not releasing a Nuget package what kind of alternative package can we expect?  I.e.  Dll, installer or drivers?

     

    Thank you again and I look forward to hearing from you.

     

    Dino

     

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Premkumar Swaminathan

    Jun 12, 2020 12:45 AM

    Premkumar Swaminathan

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 01:32 PM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 12:45:00 AM
    From: Premkumar Swaminathan
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 9:16:00 AM
    From: Jeremy Bowling
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino,

    Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license just to get the .NET Core driver. At a minimum you are looking at $20,000 just to be able to connect to their database. 


    ------------------------------
    Jeremy Bowling



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 9:36:00 AM
    From: Jeremy Bowling
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Sorry, should clarify better. If your client has DB2 LUW (Linux, Unix, Windows) then you should be good because they will have the license. If they are using any other DB2 database like DB2 for i, the license has to be purchased separately. 


    ------------------------------
    Jeremy Bowling
    ------------------------------

    Original Message:
    Sent: Fri June 12, 2020 09:29 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Jeremy, thanks for your message. 

     

    The client I am working with already has a DB2 license.  Are you saying that to connect to their existing DB2 database, which they probably already pay licensing costs towards, they have to pay a further $20k just to connect to it from their Azure infrastructure?   

     

    Thanks, please clarify as this will have a significant impact on our project.  I thought that with the IBM.Data.DB2.Core nuget package I would be able to connect as part of the client's existing DB2 licensing.

     

    Dino

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino, Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Jeremy Bowling

    Jun 12, 2020 9:16 AM

    Jeremy Bowling

    Dino,

    Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license just to get the .NET Core driver. At a minimum you are looking at $20,000 just to be able to connect to their database. 


    ------------------------------
    Jeremy Bowling
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Fri June 12, 2020 05:47 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Premkumar, thank you for your email. 

     

    1. Do you know if the issue I am facing will definitely been resolved in the next release?  stackoverflow.com/questions/62327380/...
    2. Is the next release on schedule for end of June 2020 still? 
    3. How can I get hold of the Beta version so I can test sooner?
    4. It is crucial on the project I am working on right now to enable connectivity to on prem DB2 database from Azure (Either using a WebApp or a Function App), either way the code will be written in .Net Core 3.x.  Do you know if this will be supported in your next release? 
    5. Also, if you are not releasing a Nuget package what kind of alternative package can we expect?  I.e.  Dll, installer or drivers?

     

    Thank you again and I look forward to hearing from you.

     

    Dino

     

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Premkumar Swaminathan

    Jun 12, 2020 12:45 AM

    Premkumar Swaminathan

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 01:32 PM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 12:45:00 AM
    From: Premkumar Swaminathan
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 9:16:00 AM
    From: Jeremy Bowling
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino,

    Since you are accessing DB2 from Azure, have you purchased DB2 Connect? If not, be aware IBM will make you purchase this software license just to get the .NET Core driver. At a minimum you are looking at $20,000 just to be able to connect to their database. 


    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Fri June 12, 2020 05:47 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Premkumar, thank you for your email. 

     

    1. Do you know if the issue I am facing will definitely been resolved in the next release?  stackoverflow.com/questions/62327380/...
    2. Is the next release on schedule for end of June 2020 still? 
    3. How can I get hold of the Beta version so I can test sooner?
    4. It is crucial on the project I am working on right now to enable connectivity to on prem DB2 database from Azure (Either using a WebApp or a Function App), either way the code will be written in .Net Core 3.x.  Do you know if this will be supported in your next release? 
    5. Also, if you are not releasing a Nuget package what kind of alternative package can we expect?  I.e.  Dll, installer or drivers?

     

    Thank you again and I look forward to hearing from you.

     

    Dino

     

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    Dino Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Premkumar Swaminathan

    Jun 12, 2020 12:45 AM

    Premkumar Swaminathan

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 01:32 PM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis

    Integration Developer

     

    DinoMerendidis@essentra.com

    www.essentraplc.com

    Essentra

    Avebury House,

    201 ‑ 249 Avebury Boulevard

    Milton Keynes

    Buckinghamshire

    MK9 1AU

    United Kingdom

     

     

     

    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.

    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.

    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

     

     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap




    Original Message:
    Sent: 6/12/2020 12:45:00 AM
    From: Premkumar Swaminathan
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    Dino
    Our new packages would be uploaded to IBM PPA and IBM Fix Central. Uploading to NuGet involves some legal challenges. Hence, its paused for now. We are working on an alternative plan. Will keep you all posted.

    ------------------------------
    Premkumar Swaminathan

    Original Message:
    Sent: Thu June 11, 2020 01:32 PM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Thanks for getting back to me Peter.  It looks like there is going to be a release by end of June 2020 with a fix.  Do you know if there will be a new version of the Nuget package or is there another channel that IBM release fixes on?

     

    Dino Merendidis
    Integration Developer
     
    DinoMerendidis@essentra.com

    www.essentraplc.com
    Essentra
    Avebury House,

    201 ‑ 249 Avebury Boulevard
    Milton Keynes
    Buckinghamshire
    MK9 1AU
    United Kingdom
       
    Given the ever changing impact of COVID-19, Essentra is continuing to closely monitor the situation at each of our sites and countries in which we operate, taking steps in line with local government guidance. We have already implemented measures to ensure the wellbeing of our colleagues, visitors and those whom we have contact with, while maintaining services to our customers. While we have implemented precautionary measures which include restricting non-essential visits to our sites, we will continue to work with our employees and suppliers to maintain a quality level of service to our customers, taking any health precautions necessary.
    This e-mail may contain proprietary information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful. 
    If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this email in error, please delete it and notify us immediately by return email.

    Be aware that Essentra may monitor incoming and outgoing e-mails to ensure compliance with the Essentra End User IT Usage policy.
    Essentra plc | RegisteredNumber: 5444653 | Registered in England and Wales | Registered Office:Avebury House, 201-249 Avebury Boulevard, Milton Keynes, Buckinghamshire, MK91AU 

     

    External email – treat with caution

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver. ------------------------------ Peter Czurak -------------------... -posted to the "Db2 (On Premises and Cloud)" group

    IBM Community

    Db2 On Premise and Cloud

      Post New Message

     

    Re: Using Entity Framework (EF) with .NET Core 3.1

    Peter Czurak

    Jun 11, 2020 12:58 PM

    Peter Czurak

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak
    ------------------------------

      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  


    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  stackoverflow.com/questions/62327380/...

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis



     

     

    You are subscribed to "Db2 On Premise and Cloud" as dinomerendidis@essentra.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.

    Virtual UG Day Recap

    dinomerendidis@essentra.com">




    Original Message:
    Sent: 6/11/2020 12:58:00 PM
    From: Peter Czurak
    Subject: RE: Using Entity Framework (EF) with .NET Core 3.1

    I think this issue has been resolved in the Beta version of .NET Core 3.1 driver.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Thu June 11, 2020 11:46 AM
    From: Dino Merendidis
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi Vishwa, I am trying to connect to IBM DB from an Azure Function V3 using .Net Core 3.1.   Here are the details of the error:  https://stackoverflow.com/questions/62327380/using-ibm-data-db2-core-to-connect-to-db2-error-when-trying-to-open-connection?noredirect=1#comment110233035_62327380

    Any pointers would be much appreciated.

    Also, the links on the IBM Knowledge Base to  Getting started with IBM .NET Provider for .NET Core
    are dead links which take me to https://community.ibm.com/community/user/legacy?lang=en

    Any help or links to actual supporting IBM documentation would be great.

    Thanks in advance.
    Dino

    ------------------------------
    Dino Merendidis

    Original Message:
    Sent: Sun January 12, 2020 11:03 PM
    From: Hosathota Vishwanatha
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi,
     work on .NET Core support is in progress and should be done with in the first half of 2020 or earlier.

    Yes, from .NET Core 2.2 to .NET 3.1, it should have been a simple upgrade but we are noticing many breaking changes in MS .NET Core which is affecting our Entity Framework support.

    I will be following your messages and would try to provide any updates we have. If you are interested in alpha programs of IBM .NET Core 3.1, please contact IBM customer support indicating the same.

    Thanks
    Vishwa

    ------------------------------
    Vishwa hs

    Original Message:
    Sent: Fri January 10, 2020 09:30 AM
    From: Peter Czurak
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    The astonishing thing is IBM bought out Red Hat and Red Hat does support .NET Core 3.1, but IBM to connect to their own database does not.  This puts my employer and me in a rock and a hard place.  We have an ERP system that's using DB2 as the backend so there's zero chance we are going to switch, because of a huge expense. Most of our custom programs written to support this ERP system are written in C# .NET 4.x. And to re-write those in java or anything else is a no go as well for the same reason.  .NET 5 is coming out this year so we should be writing any new projects in .NET Core 3.1, but we are stuck with .NET 4.x.  And what happens if IBM does not create .Net Core 3 DB2 client?

    I don't understand why IBM dropped the ball on this, it's all open source it's not like they don't have specs and they could get those specs for years before it was released as production product.  Especially when they have .NET Core 2.2 Db2 client so I can't imagine it would take a lot to make it work with 3.1.  But at the speed, IBM works even if they started today it would take a couple of years before we would see it so I hope they have something in the works already.  But I am looking for a workaround.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Fri January 10, 2020 08:48 AM
    From: Jeremy Bowling
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Definitely not a good sign and what you have found is consistent with what I have been able to find. After being bounced around to multiple IBM "experts" none of them seem to even know what .NET Core is, much less how IBM is going to support it in the future. IBM should either just stop pretending they want to integrate with other systems or either get serious about it.

    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Thu January 09, 2020 07:54 AM
    From: Peter Czurak
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    From the answers, I am getting nobody has any idea about the status of .NET Core 3.x DB2 EF client, which worries me because it takes IBM years to update anything for .NET.  And .NET Core 2.2 is not supported anymore and there is no DB2 .NET client for .NET 3.1 so we are stuck with .NET 2.2 and developing applications for .NET Core 2.2 or .NET 4.8 or going to Java, maybe that's what IBM wants.  Or maybe I am not looking at the right places.

    ------------------------------
    Peter Czurak

    Original Message:
    Sent: Thu December 12, 2019 10:18 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    FYI, I did open a case to check on EF 6.3/6.4 support in .NET Core as it would be a very easy way to port existing EF 6 full framework applications to .NET Core, and they currently do not have support.

    I have entered a RFE here. Go vote on it!

    https://ibm-data-and-ai.ideas.aha.io/ideas/DB2CON-I-49

    ------------------------------
    Mr O.

    Original Message:
    Sent: Wed December 11, 2019 11:44 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Let me know if you hear back on a date for support!

    ------------------------------
    Mr O.

    Original Message:
    Sent: Tue December 10, 2019 03:05 PM
    From: Jeremy Bowling
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Great question and I would love to know the answer as well. I have even emailed my IBM Rep. and he doesn't have a clue.

    ------------------------------
    Jeremy Bowling

    Original Message:
    Sent: Mon December 09, 2019 11:24 AM
    From: Mr O.
    Subject: Using Entity Framework (EF) with .NET Core 3.1

    Hi,

    Anyone around here have any experience using EF 3.1 with DB2 Connect?

    We only find old articles from developerworks in 2017 (which is now going bye bye Jan 1, 2020).

    Seems the DB2 connect folks have not posted any updates recently.

    Is IBM still maintaining the DB2 EF Core driver??

    ------------------------------
    Mr O.
    ------------------------------

    #Db2


  • 45.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri July 10, 2020 10:14 AM
    Hi all,

    do you know where the official portal or documentation home for DB2 and .NET (Core) is? I'm looking for release notes, known issues, updates etc. Also, is there a twitter or something we can follow to get updates when new releases are available? 

    Best regards,

    Lars

    ------------------------------
    Lars Bjønnes
    ------------------------------



  • 46.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri July 10, 2020 10:38 PM
    Lars
    Db2 Connect Release Notes - https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.common.doc/doc/c0059817.html
    The recent additions on Db2 Connect 11.5.4 including .NET Core enhancements - https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.wn.doc/doc/c_ds_clients_drivers_enhancements.html
    Known issues - will have it updated in a couple of days.

    This community is the primary mode of communication other than the regular support channel.

    Thanks.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 47.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed June 03, 2020 12:09 PM
    So this is the current state of affairs with IBM. IBM and MyCAT Server are the only two that don't support current .NET Core.  IBM DB2 is on the same level as MyCAT SERVER! 

    This is beyond embarrassing. 



    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 48.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed June 03, 2020 12:22 PM
    I disagree! 
    To be embarrassed you have to care.

    So far I don't see any replies from IBM either explaining their position or disproving the claims. 
    But don't despair the .NET Core 3.1 driver will be completed this month according to a post in this forum, magically from Alpha to Production state.

    #Db2


  • 49.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed June 03, 2020 01:26 PM
    You are correct.

    Nothing from IBM since they claimed it would be in production this month. Just disappeared.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 50.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed June 03, 2020 03:46 PM
    It's astonishing that there is no any kind of response from IBM to these comments. But I guess their part-time developer does not have time to read these comments not to mention respond to them. I guess it's time to find a different tool to access DB2 data or if you are in a position to find a different database.

    #Db2


  • 51.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Community Leadership
    Posted Thu June 04, 2020 11:25 AM
    I have reached out to the subject matter experts on this topic here and hopefully they will be weighing in on this topic relatively soon. They're not in my timezone, so I can't tell when they'll receive my message, but I wanted you to know they've been contacted.

    Doug

    ------------------------------
    Doug Moran
    ------------------------------



  • 52.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 04, 2020 12:36 PM
    Thank you Doug. Moving forward, does IBM have any plans to better support Visual Studio, .NET, etc... programming? The slow release and updates has been a problem that has been discussed for years. It's hard to justify paying for DB2 Servers when you can only access the data through limited technologies and you are always 2 versions behind. 


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 53.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Community Leadership
    Posted Fri June 05, 2020 11:14 AM
    Hi Jeremy. I'm going to let Prem field that one, if you don't mind. I'm the overall Community manager for the Hybrid Data Management community, which includes Db2, and so I'm not familiar with all the details of all the product roadmaps. Prem should be able to answer that one for you.

    Doug

    ------------------------------
    Doug Moran
    ------------------------------



  • 54.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 11:32 AM
    Thanks again. If the DB2 Connect guy controls all of this I can see why IBM wants me to pay an additional $22K just to access the database I already paid for. 

    For less money I could purchase the entire software package for Microsoft SQL Server Enterprise. 

    FYI all the other database providers, SQL, MySQL, Oracle, etc... this is included AT NO CHARGE. .NET Core is open-source.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 55.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 11:59 AM
    Edited by System Fri January 20, 2023 04:16 PM
    Yep, even the ORACLE driver is in NuGet: https://www.nuget.org/packages/Oracle.ManagedDataAccess/

    If Oracle can figure it out, surely IBM can, too.


    Also, the Oracle solution is a pure .NET driver, there's no need for any additional client software, unlike the half-baked IBM driver that has to have the CLI driver installed (and takes 90+ MB). In a world where IBM is pushing containerization, that is far too large a file size for an application dependency. (The Oracle driver package is about 3 mb, by the way, Posgres's NuGet package is about 1.5 MB).

    ------------------------------
    Bryan Hamby
    ------------------------------



  • 56.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 01:22 PM
    Bryan
    Sent you a PM, please check and revert. Thank you.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 57.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 01:29 PM
    Great point about the driver size Bryan. MySQL .NET driver supporting 3.1 EF Core and all the other .NET technologies checks in at less than 4 MB. 


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 58.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 01:05 PM
    Jeremy
    You should have got the Beta download link for .NET Core 3.1 by this time. I am looking forward to work with you more closely on email going fwd that would give us more clarity about the eco system that you have. Will check on emails further.
    Thanks!

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 59.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 04, 2020 12:57 PM
    Peter
    I understand your concern and we are for sure, addressing the .NET Core 3.1. The soon to be released [June 30, 2020] has got over a dozen pre-release consumers since March 2020 and several of them reported positive signs of it. We would definitely work with you on a 1-1 email to resolve your situation ASAP. In this regard, I sent you a PM [private message] a week ago. Did you get a chance to look at it?

    Prem
    Senior Manager, Db2 Connect.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 60.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 04, 2020 12:58 PM
    Peter
    I sent you a message through this forum. Not sure if you had a chance to look at it. Please reply and we can work through this.
    There have been multiple customers active on Alpha, now in BETA and to be GA'ed later this month. Feedback is good so far but for some issues that includes a few of yours.
    I would be more than happy to work with you on the scenarios you have challenges. Let me know.

    Prem
    Senior Manager, Db2 Connect.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 61.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 04, 2020 10:58 PM
    I did not receive any messages (I checked the spam mailbox).
    I am on the alpha program, but the last time I checked the errors I experienced were still there.  And I just looked and all the files are gone from my Alpha folders at myshare.rocketsoftware.com and no beta files.

    This has been my constant experience with IBM, just bizarre.

    #Db2


  • 62.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 01:01 PM
    Once logged in, check on the "my inbox" folder from your profile section of this community.
    This is when I sent you a PM.


    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 63.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 01:22 PM
    I have not received any emails with links from you on or after 5/28, I have received several emails from the forum on 05/28 but none of them are from you.
    I checked my spam mailbox and I had our Exchange admin check the spam filter.

    #Db2


  • 64.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 01:25 PM
    Not on your mail box though you might have got a notification based on your subscription type.
    Once logged in to this community, check on the "my inbox" folder from your "profile" section of this community.


    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 65.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 02:03 PM
    a

    ------------------------------
    Michael Connor
    ------------------------------



  • 66.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 02:03 PM
    Hi wanted to confirm Prem's statement about planned GA late this month of the .NET Core 3.1 driver.  Also wanted to follow up with those on this discussion that we recognize we need to do better re MS support and timelines.  I know both prem and I would welcome a discussion in person with those interested to discuss your experiences and roadmaps.

    ------------------------------
    Michael Connor
    ------------------------------



  • 67.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri June 05, 2020 02:10 PM
    Michael,
    I would like to be a part of that discussion.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 68.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 11, 2020 02:29 PM
    I'd like to be included as well. I've communicated with folks at IBM about this a few years ago, but I haven't seen much come from it. My guess is internally there are funding decisions being made that is probably putting all things .NET on the backlog. It would be interesting to see what plan you have for .NET Core 5 coming out in November of this year.

    ------------------------------
    Mr O.
    ------------------------------



  • 69.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 18, 2020 11:55 AM
    Michael are you still planning on having discussions about the experiences and roadmaps?

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 70.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 18, 2020 12:20 PM
    Hi - yes I am.  I'd like to time it shortly after the upcoming GA at the end of this month.
     
     

    Michael Connor
    Program Director, Hybrid Data Management -
    Open Source Db Offering Management
    IBM Software Group
    919 543 4385






  • 71.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 23, 2020 05:01 PM
    What version will be posted of the EF Core DB2 package?

    We are engaging in a project to add support for DB2 in a handful of our applications that use Entity Framework and the 1.3.0.100 version posted on nuget.org were causing some odd SQL to be created. We saw that there is a v2 of this package but I was unable to find it in the IBM Passport Advantage or the Fix Central. Is this the version that is referenced in this thread of a GA of 6/30 for .NET Core 3.1?

    If that's the case, where will it posted and what access is required in order to find the download?

    ------------------------------
    IT Staff
    ------------------------------



  • 72.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed June 24, 2020 10:04 AM

    It took us a long time to find it as well, including a support chat to IBM (which didn't help, and disconnected part way through).

    We found it in Parter World, under the following two names (for Linux, there are separate Windows and OS X versions). One uses .net in the name (vs dotnet which was more common for core, though that is changing now), while the other doesn't mention this at all. Note the names do not reference DB2 or Informix (our use case) so unless you knew what it was called, you'll never find it by searching for "db2 .net".

    • IBM Data Server provider for Entity Framework Core 2.0 for Linux on AMD64 and Intel EM64T systems (x64) Multilingual (CC2BRML )
    • IBM Data Server provider for .NET Core 2.0 for Linux® on AMD64 and Intel® EM64T systems (x64) Multilingual (CC2BNML )

    The current version appears to be 2.0.0.100

    ------------------------------
    Chris Irwin
    ------------------------------



  • 73.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 25, 2020 01:24 AM
    Hi Chris,
     we will be uploading the next version of Db2 .NET drivers to IBM downloads by 30th of June. Once uploaded I will share the exact details here for everyone's reference.
    Here is the complete list of v11.5 drivers available for download from IBM downloads including the ones you have indicated.

    https://www.ibm.com/support/pages/node/957531

    Thanks and regards
    Vishwa


    ------------------------------
    Hosathota Vishwanatha
    ------------------------------



  • 74.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 11:59 AM
    Hi, is there any update on this? The release was scheduled for today.

    ------------------------------
    Thalita Carvalho
    ------------------------------



  • 75.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 12:06 PM
    https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=11.5.*&platform=Windows+64-bit,+x86&function=all

    If the above link doesn't work, you may start from https://www.ibm.com/support/fixcentral/ and search for "IBM Data Server Client Packages" for the version 11.5.* that would get you all the latest releases available as of today.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 76.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 01:03 PM
    Be aware the bug I reported in the Beta version of the EF client .NET Core 3.1 is still in the production version of (EF) .NET Core 3.1.
    Don't run a program that uses this library from a directory that contains '#' in any of the directory names in the path. At least on Windows.

    #Db2


  • 77.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 01, 2020 12:15 PM
    Peter
    This seem to be a Microsoft bug. We have a ticket raised and awaiting their feedback. So, unless you have a bug other than '#​' in the path, you should be OK. Feel free to reach out to us if you have another bug through email or private message.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 78.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 02:14 PM
    I found the package in DB2 11.5 Version Fix Packages. My version of DB2 is older than that. Is there support for older versions of DB2 ?

    ------------------------------
    Thalita Carvalho
    ------------------------------



  • 79.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 03:33 PM
    The documentation doesn't even mention this new driver. Where can I find the documentation to support it?

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 80.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 01:00 PM
    Hello Thalita, yes, I just checked with the Db2 Lead.    
     
    The Db2 update is still planned for today - including updates to fix central for both Db2 and the Drivers.  .  .  
     

    Michael Connor
    Program Director, Hybrid Data Management -
    Open Source Db Offering Management
    IBM Software Group
    919 543 4385
     
     





  • 81.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 02:52 PM
    Where is the nupkg to be found? I checked passport advantage and only the old 2.0 version is there.

    I also checked fix center and See Fix Pack 0 for 11.5, but not sure where .nupkg can be found.

    ------------------------------
    Mr O.
    ------------------------------



  • 82.  RE: Using Entity Framework (EF) with .NET Core 3.1



  • 83.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 01, 2020 01:07 PM
    Edited by System Fri January 20, 2023 04:44 PM
    I installed the package and found some bugs (i cant use .Skip and .Take commands, slowness and onthers). Is there a place to send this bugs?
    It would very helpfull to have the documentation, with the requires and limitations of IBM.EntityFrameworkCore

    ------------------------------
    Thalita Carvalho
    ------------------------------



  • 84.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Fri May 05, 2023 10:18 AM

    Hi Thalita! did you get any answers regarding these BUGs? I'm using the latest version available on nuget and this same "Skip and take" problem continues to occur.



    ------------------------------
    Lucas Klein
    ------------------------------



  • 85.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu June 25, 2020 01:18 AM
    Hi,
     the last version which was uploaded to NuGet was version 1.3.0.100 and after that we have made a release of 2.0.x.x into IBM Passport Advantage (PPA). We also have v2.2 to support .NET Core 2.2 but that is not available in IBM downloads since .NET Core 2.2 went out of support quickly. By next week we will upload next version of Db2 .NET Core which is v3.1 into IBM downloads.

    Thanks and regards
    Vishwa

    ------------------------------
    Hosathota Vishwanatha
    ------------------------------



  • 86.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Mon June 29, 2020 03:04 PM
    Since IBM will be releasing v3.1 either today or tomorrow, what will be the release schedule for the next version supporting .NET 5?  Microsoft will be releasing .NET 5 in November which is only 5 months away and they have had a preview for developers like IBM available since March. So just curious how IBM plans on staying current with the .NET releases moving forward?


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 87.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Mon June 29, 2020 11:16 PM
    IBM is targeting .NET 5 supported driver by Dec 2020. We are actively working on it and if things go well, we might be able to see a pre-release version of driver working on the .NET preview soon. I will keep the community updated of the timeline as soon as we have one.
    Also, I would create a new thread for .NET 5 related discussion.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 88.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 10:01 AM
    "Since IBM will be releasing v3.1 either today or tomorrow, what will be the release schedule for the next version supporting .NET 5?  Microsoft will be releasing .NET 5 in November which is only 5 months away and they have had a preview for developers like IBM available since March. So just curious how IBM plans on staying current with the .NET releases moving forward?"

    I am also very interested to know if a project is already in flight at IBM with a goal to release a new version with .NET 5 support at or shortly after launch in November.


    ------------------------------
    Ryan Masilionis
    ------------------------------



  • 89.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Tue June 30, 2020 11:54 AM
    Ryan
    Hope you saw my posting thats above yours. Duplicating it for your reference.

    *****
    IBM is targeting .NET 5 supported driver by Dec 2020. We are actively working on it and if things go well, we might be able to see a pre-release version of driver working on the .NET preview soon. I will keep the community updated of the timeline as soon as we have one.

    Also, I would create a new thread for .NET 5 related discussion.
    *****

    Though there have been a few gaps in the recent past, we have corrected them in quick time.
    We continue to put our best efforts to stay on current.

    ------------------------------
    Premkumar Swaminathan
    ------------------------------



  • 90.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 01, 2020 12:14 PM

    Last March I stared with the Alpha version of .net v3.1 IBM client and immediately encountered an issue that would not allow me to use that version, I reported the issue and waited almost 2 months and there was no reply or info from IBM.  I complained in this forum and was offered the Beta version of the same client. Immediately I encountered another issue which was verified by IBM but this time I had a workaround that allowed me to use the library and again I have not heard anything about the fix or any other updates. Here they are saying they will be releasing the GA version of the client any day now and they have not offered the fixed version of the product to the people who found an issue beforehand. So is it fixed or not?  Keep in mind maybe all of the bugs have been fixed and tested, but wouldn't you think IBM would want as many people as possible to test the product especially the ones that encountered and reported the bugs? 

    So I guess you will have to make up your own mind on the timely availability of .NET 5 client. But don't expect any communication from IBM.



    #Db2


  • 91.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Community Leadership
    Posted Thu July 02, 2020 02:26 PM
    Hi Peter,

    In the last month or so since I was made aware of your concerns, this thread has been engaged by IBMers Prem Swaminathan, Michael Connor, and myself, as well as Hosathota Vishwanatha of Rocket. We've provided updates about new releases and reports of issues including a problem at the Microsoft rather than the IBM end. Your specific issues have been reported on to the product team by Prem and Michael for review and consideration. There's also been considerable product discussion on this thread.

    I absolutely understand your frustration and weariness at waiting; I'm not a bonehead. I've worked in development, support, and QA my own self. And please understand that we're engaged. You have the attention of four people on this thread. Have you taken the opportunity to reach out to Prem, Michael, or Hoshathota through the community  contact system? If not, please give it a try; just click their bio link and send them a message, and you can message them directly. Perhaps that might work better for you.

    Best,

    Doug

    ------------------------------
    Doug Moran
    ------------------------------



  • 92.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu July 02, 2020 03:36 PM
    I have not seen any updates about any of the issues, there was one mention of the problem regarding Microsoft which said that's not your fault but that was it and only after I asked about it. How about providing a fix, it's open source? And for some reason, only DB2 has that issue, but I don't know the issue so maybe that can only be fixed by Microsoft.
    The first issue I reported was when I was on Alpha version and I never received any info that it was fixed nor any requests to test the fix or a link to a fixed version, same with Beta version, nothing. The Beta version issue you said was a Microsoft issue, but how about providing a link to the issue, how about telling us about the issue or you just want everyone to struggle and find the problem on their own, how about documenting a workaround, or you just let everyone struggle to see how far they get - very funny?  You said "And please understand that we're engaged." since when, today? Because I don't see it, I just see you ignoring us - two months waiting for a response and getting a response only after asking for it is not being engaged. Can you imagine customers begging for Alpha and Beta versions and IBM says "I don't think so"? Then you finally release the production version and people can't find it because you did not provide a link just some name that IBM thinks everybody should know. The link was provided only after people could not find it. But as long as you guys are engaged.

    #Db2


  • 93.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Community Leadership
    Posted Thu July 02, 2020 04:08 PM
    Hi Peter,

    Prem has responded to this thread at least ten times, Hosathota something like half a dozen, beginning in January. May I again suggest you reach out to either Prem or Michael Conner directly through the messaging capability in the community and ask them your questions directly?

    Doug

    ------------------------------
    Doug Moran
    ------------------------------



  • 94.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Thu July 02, 2020 04:45 PM
    Perm has responded at least 10 times about the Fixed issue or link to the Beta? I don't think so. Show me one that was sent before I asked for it multiple times.

    I had no issues whatsoever reporting the problems and I got responses to the original posts, it's the followup responses to those problems I have issues with or lack them of. 
    I don't think I should keep checking the messaging if they don't bother to update me.  Have you ever tried using the messaging from the Internet, it's slow as molasses, you can't even type because it's 2 strokes behind. I don't have the same issues with Outlook or Gmail.
    So in Alpha and Beta versions, you want me to report a problem when I find one and then keep checking for a response and if I don't get one I should email through messaging?

    #Db2


  • 95.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 22, 2020 10:03 AM
    Hosathota,

    Today's date is July, 21, 2020 and still no sign of support for IBM.EntityFrameworkCore on .NET CORE 3.1.

    I have been checking on the updates since IBM has posted that it will be available on June, 2020. 

    I am currently using the following version, IBM.EntityFrameworkCore 1.3.0.100 that is the only version available and compatible with EFCore 2.2.

    Please provide concrete information on how to proceed forward using Nuget Package manager in order to obtain the latest version that would be compatible with EFCore 3.1.

    Best Regards,
    Mohammed Benslimane

    ------------------------------
    Mohammed Benslimane
    ------------------------------



  • 96.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 22, 2020 10:39 AM
    It was released on 6/24/2020, 
    https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=11.5.*&platform=Windows+64-bit,+x86&function=all

    It's the second item on the list.  You will have to create your own NuGet repository.
    Leave it to IBM to make it confusing instead of following industry standards. It took years for everyone to agree on the NuGet repository, but I guess IBM thinks it can do better (the lawyers, not the developers, but they'll get the brunt of it). This confusion is all on IBM, 


    #Db2


  • 97.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 22, 2020 11:28 AM
    Peter,

    Thank you for the clarification. I'm going to go ahead and try it the way you suggested.

    Unfortunately, IBM seems to always make things more difficult. They already have a nugget package for IBM.EntityframeworkCore v1.3.0.100. Why can't they just push an update through the Nugget package repository and make it easier for their users !

    I hope they can fix this by providing an update through Nugget repository. 

    Mohammed Benslimane

    ------------------------------
    Mohammed Benslimane
    ------------------------------



  • 98.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 22, 2020 01:27 PM
    Please vote up the nuget request I submited in Dec 2019 here: https://ibm-data-and-ai.ideas.aha.io/ideas/DB2CON-I-50

    It seems strange to me that IBM keeps saying this is an issue due to export compliance in face of the following:

    1. Does that mean microsoft, Oracle, MySQL, etc are in export compliance violation???

    2. IBM still has the old drivers posted. So how is it the old drivers don't suffer from the same "export compliance" issue?

    My 2 cents.

    ------------------------------
    Mr O.
    ------------------------------



  • 99.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed July 22, 2020 01:45 PM
    Voted and I agree. If IBM has done it in the past (and they have) then there is no reason they shouldn't be able to do it again. I don't think we are getting the whole story. Every other database company has figured out how to do it. IBM continues to make doing business with them as difficult as possible.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 100.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed October 14, 2020 09:30 AM
    I guess IBM figured out how to get around the "export restrictions" that Microsoft, Oracle and hundreds of others never had an issue with. The Nuget packages are now posted. 


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 101.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Wed October 14, 2020 09:27 AM
    So I guess you decided to scrap the idea of having discussions with end users?

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 102.  RE: Using Entity Framework (EF) with .NET Core 3.1

    Posted Mon May 08, 2023 05:09 PM

    Add EF to your project: First, you need to add the EF NuGet package to your project. You can do this by opening the NuGet Package Manager in Visual Studio or by adding the following line to your project's .csproj file:

    xml
    <ItemGroup> <PackageReference Include="Microsoft.EntityFrameworkCore" Version="3.1.0" /> </ItemGroup>

    Create a DbContext: Next, you'll need to create a DbContext class that represents your database. This class will contain DbSet properties for each table in your database, and you can use LINQ queries to interact with these tables. Here's an example of a simple DbContext class:

    csharp
    public class MyDbContext : DbContext { public DbSet<Customer> Customers { get; set; } public DbSet<Order> Orders { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer("your-connection-string-here"); } }

    Use the DbContext in your code: Once you have your DbContext, you can use it in your code to interact with the database. Here's an example of adding a new customer to the Customers table:

    csharp
    using (var db = new MyDbContext()) { var customer = new Customer { Name = "John Doe" }; db.Customers.Add(customer); db.SaveChanges(); }


    ------------------------------
    alishan khan
    ------------------------------