Db2 (On Premises and Cloud)

nested-group-icon.png

DB2

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.
    ------------------------------


  • 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

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



  • 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.



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



  • 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 6 days ago
    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.

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



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

    Posted 2 days ago
    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 19 hours ago
    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
    ------------------------------