We are currently evaluating es and I am stumpted. I have added 5 entries to web.config, one for DNN itself plus one for each of the country specific databases our host will support via multiple portals on the same site. I have also configured global.asax to register the loader. The web site will always use the DNN database for DNN/module specific stuff, but use the specific country's database for application data. The databases are SQL Server and replicated from the target country's local database to the web server and visa versa. Consequently there is no opportunity to place all tables in the one database. Therefore each module needs to interact with data from two databases, depending on whether the data is DNN/Module data or application data.
Firstly, I keep getting an error in the module "Object reference not set to an instance of an object" as soon as I try to execute any data retrieval method; LoadByPrimaryKey, LoadAll, etc. I have verified that prior to the read request, the database default has been set to the correct database. I'm not getting anywhere with this due to the lousy degbugging in .NET (the DNN server is not local so cannot use runtime debugging) so any help would be greatly appreciated.
Secondly, I need to know how to handle the database switching for the two sets of tables. Is this efficient in the es environment, or is it just too hard/inefficient and I should go back to DNN DAL where I have absolute control?