Multiple database on DoInsert

Old forum URL: forums.lhotka.net/forums/t/9912.aspx

allp posted on Monday, January 03, 2011

Hi,

Here's my problem. I have an entity (User) on database A, and an extension table (UserEx, no entity) on database B. On User.DoInsert, I have code to insert a new record on UserEx, but it doesn't get saved and no exception is thrown. How can I achieve this or is it even possible to have multiple database.

Marjon1 replied on Monday, January 03, 2011

It is possible to have values put into multiple databases, but can cause some issues with the MSDTC if using the standard transaction attributes on the DataPortal_XYZ methods.

If you can post a bit more detail with the code you have inside your DataPortal_Insert() method it would be beneficial.