Join Multiple Data Source c#

Question

Hi How to join the multiple data source (E.g: i need to join MYSQL and MS SQL data table ) run the query in c# We need a tool like Query builder with different data sources(MS SQLMS ACCESSORACLEMYSQL).

balaji palani · Answer

Hi Rajeev Thanks for your message. Similarly Can we perform MS SQL to MS ACCESS or ORACLE ? I attached some diagram for ref.

Rajeev Punhani · Answer

Hi Balaji  You can create a linked server .For connecting MYSQL and MSSQL I have shared an article.Please find the link below http://www.c-sharpcorner.com/article/create-a-linked-server-mysql-to-sql-server/ Similarly you can do for oracle. If the above solution is helpful then accept the answer.