using Tr3v.RSS;

// Instantiate a new Channel.
Channel channel = new Channel("Tr3v RSS Feed", new Uri("http://tr3v.net/"), "Tr3v.net Blog Feed");

// Add a new Item to the Channel.Items collection.
channel.Items.Add(new Item("Tr3v RSS Feed 1", new Uri("http://tr3v.net"), "Tr3v.RSS Example 1"));

/* Then call the Save method to save the RSS Feed to an .xml file.*/
channel.SaveAs(new System.IO.FileInfo(@"c:\test.xml"));

<?xml version="1.0"?>
<rss version="2.0">
    <channel>
    <title>Tr3v RSS Feed</title>
    <link>http://tr3v.net/</link>
    <description>Tr3v.net Blog Feed</description>
    <generator>Tr3v.RSS</generator>
    <item>
        <title>Tr3v RSS Feed 1</title>
        <link>http://tr3v.net/</link>
        <description>Tr3v.RSS Example 1</description>
    </item>
</channel>
</rss>

Channel channel = new Channel("Tr3v RSS Feed", new Uri("http://tr3v.net/"), "Tr3v.net Blog Feed");
try
{
    using (SqlConnection connection = new SqlConnection("your connection string"))
    {
        using (SqlCommand command = new SqlCommand("your SQL query", connection))
        {
            command.CommandType = CommandType.Text;
            command.Connection.Open();
            SqlDataReader dataReader = command.ExecuteReader();
            while (dataReader.Read())
            {
                channel.Items.Add(new Item(dataReader["title"],
                                          new Uri(dataReader["link"]),
                                          dataReader["description"]);
            }
        }
    }
}

...
item.Author = new System.Net.Mail.MailAddress("fred.flintstone@bedrock.com", "Fred Flintstone");
...

<item>
    ...
    <author>fred.flintstone@bedrock.com (Fred Flintstone)</author>
    ...
</item>