Topic
  • 3 replies
  • Latest Post - ‏2013-07-11T05:53:13Z by PhaniKrishnaV
PhaniKrishnaV
PhaniKrishnaV
25 Posts

Pinned topic Visual Studio 2012 Informix EntityFramework

‏2013-07-08T23:00:52Z |

I am trying to connect Informix database using Entity Framework 5.0. But i couldn't find IBM DB2, IDS and U2 Servers in change data source window.

Here is the environment:

VS 2012

Framework 4.0

Informix Developer Edition

Informix Client SDK (have both 3.5 and 4.0).

Any help would great help.

  • Devendra_Bhadauria
    Devendra_Bhadauria
    43 Posts

    Re: Visual Studio 2012 Informix EntityFramework

    ‏2013-07-09T14:38:37Z  

    AFAIK, no version of Informix CSDK supports EF and VSAI.

    Please use DB2 Common .NET provider and Visual Studio Add Ins to have this support enabled. We introduced VS 2012 support in Galileo fp2 i.e. 10.1.2.

    http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/c0051507.html

    IBM Data Server Provider for .NET:

    http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.swg.im.dbclient.adonet.doc/doc/c0010960.html

    DB2 integration in Visual Studio:

    http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.swg.im.dbclient.adonet.doc/doc/c0010780.html

    These are recommended packages, please install in the same order:

    http://www-933.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm/Information+Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=10.1.*&platform=Windows+32-bit,+x86&function=fixId&fixids=*FP002&includeSupersedes=0

    Item no. 2 (DSDRIVER) and then item no.3 (VSAI) for 32-bit platforms.

    Hope this helps!

     

  • PhaniKrishnaV
    PhaniKrishnaV
    25 Posts

    Re: Visual Studio 2012 Informix EntityFramework

    ‏2013-07-10T21:27:50Z  

    AFAIK, no version of Informix CSDK supports EF and VSAI.

    Please use DB2 Common .NET provider and Visual Studio Add Ins to have this support enabled. We introduced VS 2012 support in Galileo fp2 i.e. 10.1.2.

    http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/c0051507.html

    IBM Data Server Provider for .NET:

    http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.swg.im.dbclient.adonet.doc/doc/c0010960.html

    DB2 integration in Visual Studio:

    http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.swg.im.dbclient.adonet.doc/doc/c0010780.html

    These are recommended packages, please install in the same order:

    http://www-933.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm/Information+Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=10.1.*&platform=Windows+32-bit,+x86&function=fixId&fixids=*FP002&includeSupersedes=0

    Item no. 2 (DSDRIVER) and then item no.3 (VSAI) for 32-bit platforms.

    Hope this helps!

     

    Thank you Devendra.

    After installation  IBM DB2, IDS and U2 Servers are showing up in Change Data Source window.

    And I have installed FP too.

    When i tried for Database first approach with Entity Framework, i am getting below error (no entity classes are generated):

    Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
    ERROR [IX000] [IBM][IDS/NT32] System error - unexpected null pointer encountered.
    '.
    Loading metadata from the database took 00:00:01.7868065.
    Generating the model took 00:00:00.8301834.
    Added the connection string to the App.Config file.
    Writing the .edmx file took 00:00:00.0020817.
     

    When i tried with Code first approach i am getting below error:

    ERROR [42000] [IBM][IDS/NT32] The specified table (dbo.xxxxx) is not in the database. (-111 ISAM error:  no record found.) 

     

  • PhaniKrishnaV
    PhaniKrishnaV
    25 Posts

    Re: Visual Studio 2012 Informix EntityFramework

    ‏2013-07-11T05:53:13Z  

    Thank you Devendra.

    After installation  IBM DB2, IDS and U2 Servers are showing up in Change Data Source window.

    And I have installed FP too.

    When i tried for Database first approach with Entity Framework, i am getting below error (no entity classes are generated):

    Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
    ERROR [IX000] [IBM][IDS/NT32] System error - unexpected null pointer encountered.
    '.
    Loading metadata from the database took 00:00:01.7868065.
    Generating the model took 00:00:00.8301834.
    Added the connection string to the App.Config file.
    Writing the .edmx file took 00:00:00.0020817.
     

    When i tried with Code first approach i am getting below error:

    ERROR [42000] [IBM][IDS/NT32] The specified table (dbo.xxxxx) is not in the database. (-111 ISAM error:  no record found.) 

     

    Code First issue has been solved.

    Entity Framework prefixed  "dbo"  to all tables in queries. When i changed to add to actual owner name, it is working fine now.