Hi ti-distribucion,

You can use the Evaluate Snippet command to run isolated snippets of c# code. These can be mapped to existing variables in your Studio script, or you can create temp variables in the snippet itself.

In case you need to import a library which is not included as default, you can install the Nuget package dependency from package manager and import the needed libraries to your project from "Imports" tab:

Hope this helps!

Hello Nataly,

Thanks for your answer. I have a question, how can i employ c# libraries?

Hi ti-distribucion,

I understand the case, because of the limitations SQL provides for simple queries, datatable is not supported as an input parameter type. For a case like the above described, we would need to setup a loop, and add the individual datarows or employ c# libraries (if possible).

However, I will take your suggestion to the product team to add a database bulk-add command and add it to our Studio backlog as a feature request.

​

Thanks!

Hello Nataly,

But for example, i have a datatable with 4000 rows. I want to insert 4000 lines in a bulk, not line by line. Is there a way to do that?

Thanks

Hi ti-distribucion,

You can use the Execute Database Query command to perform an insert database query to your existing database connection. You can include multiple parameters in each query execution.

As an alternative, you can store operations in a stored procedure, and invoke it from the Execute Database Stored Procedure command.

Hope this helps!