c# - Sql query containing 2 databases -

c# - Sql query containing 2 databases -

in c# want execute query utilize 2 different databases (one access local, , other distant , mysql)

i'm able in vba access, how can create same thing in c# ??

this how made in access:

link 2 differents table/databases in table

in vba:

ssql = "insert db1tblclient select * db2tblclient" currentdb.execute ssql

how can execute sql in c# ? (what object use, etc... illustration code if can)

thanks !

there 2 ways this. 1 set linked tables on access , run single query. other run both queries c# , bring together them linq.

the first way better. if have linq, here sample code:

dwconnection.open(); dwdataadaptor.selectcommand = dwcommand1; dwdataadaptor.fill(queryresults1); dwdataadaptor.selectcommand = dwcommand2; dwdataadaptor.fill(queryresults2); dwconnection.close(); ienumerable<datarow> results1 = (from events in queryresults1.asenumerable() events.field<string>("event_code").tostring() == "a01" || events.field<string>("event_code").tostring() == "st" select events ) ienumerable<datarow>; var results2 = events1 in queryresults1.asenumerable() bring together events2 in queryresults2.asenumerable() on (string)events1["event_code"] equals (string)events2["event_code"] select new { f1 = (string)events1["event_code"], f2 = (string)events2["event_name"] }; datatable newdatatable = new datatable(); newdatatable = results1.copytodatatable<datarow>();

see why said linked tables better?

c# mysql sql database ms-access