我想用Dapper写一个CSV文本文件，用Console.WriteLine从sql数据库中读取仪表表。

using Dapper;

string connectionString = "YourConnectionString";
using (var connection = new SqlConnection(connectionString))
{
    // 代码逻辑
}

string query = "SELECT * FROM YourTable";
var result = connection.Query(query);

var csvContent = new StringBuilder();

foreach (var row in result)
{
    // 逐行遍历结果集，将数据按CSV格式拼接到StringBuilder对象中
    csvContent.AppendLine(string.Join(",", row.Property1, row.Property2, row.Property3)); // 替换Property1, Property2, Property3为具体属性名
}

string filePath = "YourFilePath.csv";
File.WriteAllText(filePath, csvContent.ToString());

string query = "SELECT * FROM YourTable";
var result = connection.Query(query);

foreach (var row in result)
{
    Console.WriteLine(row.ColumnName); // 替换ColumnName为具体列名
}