I have two providers in a web project and it appears that the schema is not being generated for any of my tables and views in the second provider. SubStage builds the table and view classes ok - I've visually compared the classes generated for my second provider to those of my first provider and they seem to be complete; however, when I try to use any of the objects, I receive an "Object reference not set..." error.
More specifically, I have traced the error down to Line 591 of SqlDataProvider.cs:
DataRow[] drColumns = dsColumns.Tables[Name].Select(String.Format("TableName ='{0}'", tableName), "OrdinalPosition ASC");
For some reason, the dsColumns dataset does not contain any column information for any of my objects in the second data provider.
Perhaps I am missing a setting somewhere that tells SubSonic to generate the column information for additional providers.
Any thoughts from anyone?
Thank you for your help in advance.