I have a EF class with a connection to a sql server database "mydb", I like to update data on another database (suppose mydb2.dbo.anothertable) on same server, Can I create a entity that is related to this "another" database using the same connection? (excuse me for my grammar errors, I speak in spanish)
A:
Based off this thread, I'd say you're out of luck. You'll have to create a separate ADO Entity item for each database and update using separate connections.
If you want to build a transaction against both of these connections, you can use TransactionScope to coordinate your transaction.
Randolpho
2009-07-10 21:18:01
thanks 4 reply, I only need to update a single table on another database without a transaction, can I do that?
2009-07-10 21:25:12
Not on the same connection, no. You need two separate ADO Entity repositories, with two separate connections.
Randolpho
2009-07-10 21:38:31
thanks I will follow that path :)
2009-07-14 14:04:45