Topic
  • 3 replies
  • Latest Post - ‏2014-08-29T03:40:51Z by krmilligan
Mike_DBA
Mike_DBA
5 Posts

Pinned topic IBM Data Server Provider / Entity Framework Support

‏2014-08-26T16:42:11Z |

I stumbled upon this article that indicates the "IBM Data Server Provider for .NET" works with DB2 for i (V5R4) and the Microsoft Entity Framework.

http://www.ibm.com/developerworks/data/library/techarticle/dm-0903linqentity/

The downloads are listed here:

http://www-01.ibm.com/support/docview.wss?uid=swg21385217

Has anyone successfully used this data provider with Visual Studio 2012 or 2013?   I have a machine with VS 2010, 2012 and 2013.  After applying the latest hot fix I could find (HF3), I can see the DB2 provider in VS 2010.   VS 2012 won't start and VS 2013 doesn't show the provider as an option.  

 

I'm trying to create a Lightswitch HTML client app against DB2 using the Entity Framework.  I'd prefer to do this in VS 2013.

 Thanks

  • krmilligan
    krmilligan
    450 Posts

    Re: IBM Data Server Provider / Entity Framework Support

    ‏2014-08-28T14:24:08Z  

    This thread shows a client successfully using the VS 2012. 

    https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014952029&ps=25

     

    I'm assuming that you have the DB2 Connect license that's required to use the Data Server Provider against a DB2 for i server?

  • Mike_DBA
    Mike_DBA
    5 Posts

    Re: IBM Data Server Provider / Entity Framework Support

    ‏2014-08-28T16:43:44Z  

    This thread shows a client successfully using the VS 2012. 

    https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014952029&ps=25

     

    I'm assuming that you have the DB2 Connect license that's required to use the Data Server Provider against a DB2 for i server?

    Hi Kent

    Thanks for the reply.

    It looks like the VS 2012 thread you reference is using the IBM.Data.DB2.iSeries .NET provider which does not (AFAIK) support the entity framework.

    As for the DB2 Connect license, no I do not have one (other than possibly a developer license).   I didn't see that requirement referenced in the article.  I knew DB2 Connect was an option for accessing the entity framework but I guess I thought I had stumbled upon a free tool from IBM that could be used with the IBM i.

    That being the case I'll probably just uninstall the data service provider tools and VS add-ins and see if my various Visual Studio installations start working again.

  • krmilligan
    krmilligan
    450 Posts

    Re: IBM Data Server Provider / Entity Framework Support

    ‏2014-08-29T03:40:51Z  
    • Mike_DBA
    • ‏2014-08-28T16:43:44Z

    Hi Kent

    Thanks for the reply.

    It looks like the VS 2012 thread you reference is using the IBM.Data.DB2.iSeries .NET provider which does not (AFAIK) support the entity framework.

    As for the DB2 Connect license, no I do not have one (other than possibly a developer license).   I didn't see that requirement referenced in the article.  I knew DB2 Connect was an option for accessing the entity framework but I guess I thought I had stumbled upon a free tool from IBM that could be used with the IBM i.

    That being the case I'll probably just uninstall the data service provider tools and VS add-ins and see if my various Visual Studio installations start working again.

    The DB2 Connect license is only a requirement when using the IBM Data Server Provider to access DB2 for i and DB2 for z/OS servers.

    You're right about me getting the threads confused.  Only the IBM Data Server Provider supports Entity Framework.

    It it possible to get an evaluation license for DB2 Connect, if you want to check it out.