Greg McGuffey (08/31/2009)
SF should work fine with OLEDB connections. Just to be clear what's been done, this is what you should have done:
1. In VS, added a BO. At this point you just give it a name.
2. Open the BO Mapper, it will search through project(s) and show them in a list. They won't be configured.
3. Click on the project in your solution with the BO, then click on Configure project in panel on right.
4. This opens up a configuration form. You'd select OLE and then enter your connection string. I'd highly recommend that you just use the builder, which will test the connection while building it.
5. Click OK to save those changes.
6. Expand the project and you should see your BO, but it isn't configured.
7. Click on it then click on configure in right panel.
8. Select database, then table/view and click OK.
9. Now there should be a list of columns, pulled from table selected.
10. Right click on BO and select Build Partial.
11. After it is done, close dialog and BO is ready for use....
Except that you need to setup the runtime connection in AppMain.vb (program.cs if C#). In the SetDataSources method, you'll need to either setup a required data source with the connection manager OR just set the datasource up manually. I'd recommend using the first method until you get a bit farther along. Have you done all of this? If so were is it breaking?Oh..okay so here is my main question. I have been programming in .NET for awhile now, and without any kind of additional framework. I create business object classes all the time. I guess my assumption was, that the business object mapper would show all the tables in a given connection string...and automatically map those to business object I could then interact with.
Is this not the case? Is there a good example somewhere I can look at?
I don't mean to be a pain, but we've looked at a LOT of frameworks..and quite frankly I really like the seemless integration of StrataFrame the best..but I need to resolve this to justify it.
Thanks
Nick