MVC: Simple Export to CSV file

gistfile1

var db = new PetaPoco.Database(ConnectionHelper.ConnectionStringName);
var internalUsers = db.Fetch<InternalUser>("Order by InternalUserID");

StringWriter sw = new StringWriter();
sw.WriteLine("\"UserID\",\"FirstName\",\"LastName\",\"EmailAddress\"");

foreach (var user in internalUsers)
{
    sw.WriteLine(string.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\"",
        user.UserID,
        user.FirstName,
        user.LastName,
        user.EmailAddress));
}

Response.AddHeader("Content-Disposition", "attachment; filename=internal-users.csv");
Response.ContentType = "text/csv";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.Write(sw);
Response.End();

return View();