Thanks both of you Michael and Mike
I have obtained Mygen and created the Info & Controller classes for my external DB. What I want in the end is a separate DLL that has the Biz & DB layer for my external DB. I do not need a extra DAL abstraction layer, the DAL+ model is sufficient.
I have now some problems with the "plumbing". Within the DB class I want to use the CBO.Fillxx routine from DNN. In the code below I get an error
Error 2: 'Instance' is not a member of 'Provider'.
Public Function GetCustomerByCustomerID(ByVal lCustomerID As Integer) As CustomerInfo
Return CType(CBO.FillObject(Provider.Instance().GetCustomerByCustomerID(lCustomerID), GetType(CustomerInfo)), CustomerInfo)
End Function
What will I need to place instead of the word 'Provider'. I tried to reference the class in all sorts of ways. If I fully reference it I get an error "Error 2 'GetCustomerByCustomerID' is not a member of 'DotNetNuke.Data.DataProvider', even though there is no reference to it. The DBprovider class must be instantiated here, but I can't quite work out how to get it happening.
I think it may all be a problem with the namespace. The Biz and Info objects are in MyCompany.Data and the provider in MyCompany.Data.Provider . Is this correct?
Any help much appreciated...
Felix