BlogEngine.Core.Providers.DbBlogProvider.SavePackageFiles C# (CSharp) Method

        public override void SavePackageFiles(List<PackageFile> packageFiles)
        {
            using (var conn = CreateConnection())
            {
                if (conn.HasConnection)
                {
                    var sqlQuery = string.Format("INSERT INTO {0}PackageFiles (PackageId, FileOrder, FilePath, IsDirectory) VALUES ({1}PackageId, {1}FileOrder, {1}FilePath, {1}IsDirectory)", this.tablePrefix, this.parmPrefix);

                    foreach (var file in packageFiles)
                    {
                        using (var cmd = conn.CreateTextCommand(sqlQuery))
                        {
                            var parms = cmd.Parameters;
                            parms.Add(conn.CreateParameter(FormatParamName("PackageId"), file.PackageId));
                            parms.Add(conn.CreateParameter(FormatParamName("FileOrder"), file.FileOrder));
                            parms.Add(conn.CreateParameter(FormatParamName("FilePath"), file.FilePath));
                            parms.Add(conn.CreateParameter(FormatParamName("IsDirectory"), file.IsDirectory));

                            cmd.ExecuteNonQuery();
                        }
                    }
                }
            }
        }