There is some List <> that is in memory.

Can I somehow implicitly connect to the table from the database (ORM is not there)?

I have an idea, to create a # table and in it to make an INSERT from a sheet, and then a request to perform a connection, but can there be any implicit approach that will do it for me?

You can still generate a request with IN and send it to the server, but this is not universal, since IN has limitations on the number of values, and IN in performance is slower than JOIN.

  • Heber for large sheets creates a temporary label for the sheet, on which it joins. You can do the same if your ORM does not know how. - Monk
  • It can be the other way round: get data from a database to another List, then link these two lists as you please. What is better depends on the amount of data in the first List and the amount of data obtained from the database. - Alexander Petrov
  • On the other hand, creating a temporary table may be slower than IN . So test, and on your data. Performance issues without testing - guessing the coffee grounds. - VladD

0