Option to use instead of table value based type to stored procedure with C# in mysql?
Posted by: Pınar Miray
Date: February 08, 2022 04:39PM

I have been trying to convert t-sql codes that I wrote for ms sql for a long time to mysql.

Since there is no table value based type on the mysql side, frankly, on the C# side, I couldn't quite figure out how to send the tables as parameters to the stored procedure.

Instead, I will try to do a parameterized insert operation by protecting it from injection on the C# side, but the number of rows I will insert is too many.

My only option for this is the addwithparameters method with a foreach loop with the IDbCommand class?

What are your recommendations?

Options: ReplyQuote


Subject
Written By
Posted
Option to use instead of table value based type to stored procedure with C# in mysql?
February 08, 2022 04:39PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.