MySQL using bulk SQL statements with c# -

i realize load data infile can used load text/csv data. however, seems limited inserts. however, there way mysql bulk import sql files using c#.

my hope build sql in text file , send connection. since process daily, need automated not have have user intervention once program started. takes long inserting , updating when can done in bulk.

have tried mysqlbulkloader, it's c# class wraps load data infile.