Entity framework provider error with IBM DB2 I Series database

Question

Ok here's my problem I want to use entity framework with a DB2 for I series database, in a database first way, but it has been really complicated to get a successful connection.

First I was trying to create an Entity Data model using the "IBM DB2 and IDS Servers" Data source but although I created a successful connection to a LUW DB2 I haven't been able to do it with the DB2 for I series, I have tried ports 446 it said there was a licence problem, 9471 generated a connection error, 8471 kept waiting and 50000 with no success, I even tried using no port, but it didn't work.

So I choosed to use the IBM DB2 for i data source, this option allows me to connect but when I try to use Entity Framework 6.1.3 I get an error telling me that EF 6.x is not compatible with this version.

So, I downgraded EF to version 5.0 to try to create the Entity Model any way and then upgrade the EF version, but, when I click on next after selecting EF 5.0 the Entity Data Model Wizard disappears before showing the database objects and settings and the model doesn't get created.

Then I decided I didn't need an edmx file I could do the mapping manually now that the connection is working so I started creating the classes to do the mapping:

AppContext:

public class AppContext: DbContext
{
    public AppContext() : base( "connectionString" )
    {
    }

    public DbSet Datas { get; set; }
}

Data: [Table("data")] public class Data { [Column("id")] public int Id { get; set; }

    [Column("name")]
    public string Name { get; set; }
}

And finally the test:

public class Program
{
    static void Main(string[] args)
    {

        using (var ctx = new AppContext())
        {
            Data data = new Data() { Id = 1, Name = "A Name" };

            ctx.Datas.Add(data);
            ctx.SaveChanges();                
        }
    }
}

I installed the EntityFramework.IBM.DB2 nuget version 6.0.7 and changed my Web.config to add the connection string, I found there a new provider named "IBM.Data.DB2" and tested the connection but I began having the same problems I had with the first connection, with the different ports.

So I thought that this provider must be the one for the first connection and I needed the one for I series son I changed provider to "IBM.Data.DB2.iSeries" and tried again changing some parameters in the connection string but now I'm getting this error:

The 'Instance' member of the Entity Framework provider type 'IBM.Data.DB2.iSeries.iDB2Factory, IBM.Data.DB2.iSeries, Version=12.0.0.0, Culture=neutral, PublicKeyToken=9cdb2ebfb1f93a26' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later; see http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

Here are my connection strings and providers from my Web.config:

I also found a new IBM I Access that is supposed to replace the old IBM DB2 i series for windows provider, but couldn't find a data source that works with it

Ok so I'm running out of ideas, Can anyone help me to use entity framework with IBM DB2 for i series?

Thanks

Entity framework provider error with IBM DB2 I Series database

Answers (1)

Related Questions