Apricot.Fetcher.BuildInsertStatement C# (CSharp) Method

        private string BuildInsertStatement(Entry entry)
        {
            StringBuilder insertSqlBuilder = new StringBuilder("INSERT INTO Entry(Resource, Title, Description, Author, Created, Modified) VALUES(");

            if (entry.Resource == null)
            {
                insertSqlBuilder.Append("NULL, ");
            }
            else
            {
                insertSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "'{0}', ", entry.Resource.ToString().Replace("'", "''"));
            }

            if (entry.Title == null)
            {
                insertSqlBuilder.Append("NULL, ");
            }
            else
            {
                insertSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "'{0}', ", entry.Title.Replace("'", "''"));
            }

            if (entry.Description == null)
            {
                insertSqlBuilder.Append("NULL, ");
            }
            else
            {
                insertSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "'{0}', ", entry.Description.Replace("'", "''"));
            }

            if (entry.Author == null)
            {
                insertSqlBuilder.Append("NULL, ");
            }
            else
            {
                insertSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "'{0}', ", entry.Author.Replace("'", "''"));
            }

            insertSqlBuilder.AppendFormat(CultureInfo.InvariantCulture, "'{0}', '{1}')", entry.Created.ToString("G", DateTimeFormatInfo.InvariantInfo), entry.Modified.ToString("G", DateTimeFormatInfo.InvariantInfo));

            return insertSqlBuilder.ToString();
        }