为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8.0
【操作系统】：linux
【CPU】:
【问题描述】*：
netcore中如何执行sql脚本，并没有找到类似mysql的MySqlScript的东西，直接读取整个sql文本，然后用dapper直接执行会提示“第1 行附近出现错误:不支持的语句类型”，用CreateCmmand也是一样

代码

using (var connection = new DmConnection(DatabaseConnectionHelper.Dmsql))
{
    string sql = await File.ReadAllTextAsync(initSqlFilePath);
    await connection.ExecuteAsync(sql);
}

部分sql

truncate table "cmss"."es_index_config";
INSERT INTO "cmss"."es_index_config" VALUES('1','1','0');
INSERT INTO "cmss"."es_index_config" VALUES('1','2','1');
INSERT INTO "cmss"."es_index_config" VALUES('1','3','1');
INSERT INTO "cmss"."es_index_config" VALUES('1','4','0');
INSERT INTO "cmss"."es_index_config" VALUES('1','7','0');
INSERT INTO "cmss"."es_index_config" VALUES('1','8','0');
INSERT INTO "cmss"."es_index_config" VALUES('1','9','0');
INSERT INTO "cmss"."es_index_config" VALUES('1','12','0');
INSERT INTO "cmss"."es_index_config" VALUES('1','22','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','24','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','26','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','27','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','29','0');
INSERT INTO "cmss"."es_index_config" VALUES('1','34','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','35','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','37','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','38','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','39','0');
INSERT INTO "cmss"."es_index_config" VALUES('0','40','0');