Yes, the Db2DataSourceItem can be used with any ADO.NET provider that implements the System.Data.Common classes and provides a DbProviderFactory class.  However, when you swap to a new ADO.NET provider, you will need to swap the places where you pass Db2Commands to the FillDataTable() methods of the business object to use the new provider as well.

Just to close this out, I am up and running on DataDirect's DB2 Provider for ADO.NET with the SF framework, just the changes Ben mentioned above and a syntax change to the INSERT SQL statement was required.



Thank you.

Keith Chisarik

Yes, DB2 can auto-generate primary keys. Here's a CREATE TABLE statement with an auto-generated key field:







I think you can reset the starting number with a table alter, but I've not had any requirement to do that yet, so I'm not sure what the SQL is. Here's the DB2 v9 SQL reference, though. It should (hopefully) have the information in there.



http://publibfp.boulder.ibm.com/epubs/pdf/dsnsqk10.pdf



Peter

Thanks Peter, I had finally discovered that on my own, just took me a while






Keith Chisarik