I am taking a first look at SubSonic and it looks great!

I tried the screencasts with a MSSQL db and everything works with no problems.

My problem started when I tried to use Oracle on a small project. Either with the BuildProvider or the class generator tool I can get the classes fine, but the relationships collections are not being created.

Let's say I have an Order table and an OrderDetail table. In MSSQL the Order class will have a collection of OrderDetails defined. In Oracle, the collection simply doesn't show up.

Is there any special parameter on App.config or Web.config to make the code understand the Oracle relationships?

Any help is greatly appreciated.

Again, great piece of software. Keep up the great work.

You have to have primary key / foreign key relationships defined in your Oracle DB. Do you have those? 

Thank you for your answer.

Yes, I have the primary and foreign keys correctly defined on the database.

I also looked into the generated code and on the section for the foreign key objects I don't have anything, it is empty.

BTW, I am using Oracle 10g.

Any ideas?.

I don't know any other solutions for you, other than searching for Oracle in the forums.

Thank you for your help ranomore.

I will search around and see if I can find a solution. If so I will post here.