I saw that Umbraco comes with PetaPoco and if I add a table to the Umbraco database, I can do crud operations against that table, but what if I have a table that is on a different database on a different server, what is the best way to get data from their, for example, in a dropdown list?
Accessing data from another database?
I saw that Umbraco comes with PetaPoco and if I add a table to the Umbraco database, I can do crud operations against that table, but what if I have a table that is on a different database on a different server, what is the best way to get data from their, for example, in a dropdown list?
Hello Saied!
As I understand it, you can still use PetaPoco, but you have to include the code for connecting to a external database.
This forum topic may help. https://our.umbraco.org/forum/developers/razor/49750-Accessing-external-database-from-partial-view-macro-
Specifically this comment from Graeme. https://our.umbraco.org/forum/developers/razor/49750-Accessing-external-database-from-partial-view-macro-#comment-194291
is working on a reply...