Apricot.Fetcher.BuildUpdateStatement C# (CSharp) Метод

BuildUpdateStatement() приватный Метод

private BuildUpdateStatement ( Entry entry ) : string
entry Entry
Результат string
        private string BuildUpdateStatement(Entry entry)
        {
            StringBuilder updateSqlBuilder = new StringBuilder("UPDATE Entry SET ");

            if (entry.Title != null)
            {
                updateSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "Title = '{0}', ", entry.Title.Replace("'", "''"));
            }

            if (entry.Description != null)
            {
                updateSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "Description = '{0}', ", entry.Description.Replace("'", "''"));
            }

            if (entry.Author != null)
            {
                updateSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "Author = '{0}', ", entry.Author.Replace("'", "''"));
            }

            updateSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "Modified = '{0}' WHERE Resource = '{1}' AND '{2}' > Modified", entry.Modified.ToString("G", DateTimeFormatInfo.InvariantInfo), entry.Resource.ToString().Replace("'", "''"), entry.Modified.ToString("G", DateTimeFormatInfo.InvariantInfo));

            return updateSqlBuilder.ToString();
        }