Hello! The situation is as follows.

  1. According to the data from the form, a request to the oracle database is generated.
  2. Using ado.net, data is loaded into the datable from oracle.
  3. After that, you need to unload another table from another MSSQL db based on the id field loaded in step 2. That is, in essence, zatzhoynit table in datatable and table in DB mssql.

Mssql and oracle are read only. The cycle to send requests for each record loaded into a datatable is not an option, because there may be more than 400 thousand records in it and this will be delayed for several days.

Advise how it is possible to implement loading in datatable described in item 3 on c #?

  • Whether I don’t understand something, you don’t know how to use queries, in fact, received data, took an id-schnick, requested data for it, if you need a set of id, then use or id=1 or id=2 or ... - Monomax
  • one
    To form a block (s) from a set of id's ( WHERE id IN (...) , but without going beyond the allowed limit of the size of the query text) and request information from MS SQL on the whole block at once. - Akina
  • Alternatively, load the obtained id into a temporary table on MS SQL, and make a selection using it. - Akina
  • You can not load into mssql, because read only access. To form through or it will be something, because more than 400 thousand records. - Dilitand
  • I would like something like linq between datatable and sql, but I didn’t find how to implement it at all - Dilitand

0