I need to setup Entity Framework to work with a DB2 database. The main reason is to have nice object model instead of data sets and stored procedures.
The questions I have:
Regarding your questions:
Please take a look at our data provider dotConnect for DB2 with Entity Framework support (including EF6):
The DataDirect also provides a data provider for DB2 - http://www.datadirect.com/support/product-documentation/product-information/support-matrices/datadirect-connect-for-ado-net/entity-framework-data-providers , however, it doesn't provide support for Entity Framework 6.
Good news: there is a nuget package from IBM you can use: http://www.nuget.org/packages/EntityFramework.IBM.DB2/