winform快速插入大批量数据至sqlite

接口请求数据回来后，插入本地sqlite

stringbuilder组字符串后执行查询

                var strsql = new StringBuilder();
                strsql.Append("insert into CodeRecord(MdCode,CreateDate) values ");
                foreach (var item in CodeRecordList)
                {
                    strsql.AppendFormat("('{0}','{1}'),", item.MdCode, item.CreateDate.ToString("s"));
                }
                var inserSql = strsql.ToString();
                var sql = inserSql.Substring(0, inserSql.LastIndexOf(','));
           
                
                int rows = _conn.Execute(sql, null);