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();
}