SQLite查询-如何在一个查询中从数据库读取配置?这可能吗?

Question

可以有人告诉我的例子，我如何能从一个查询数据库读取配置值?下面是我的代码:

public string ReadString(string Sql)
{
using (cmd = new SQLiteCommand(Sql, conn))
{
conn.Open();
object result = cmd.ExecuteScalar();
conn.Close();
return (result == null ? "" : result.ToString());
}            
}

string ftpHost = DAL.ReadString("SELECT ftpHost FROM Ftp WHERE Id = '1'");
string ftpLogin = DAL.ReadString("SELECT ftpLogin FROM Ftp WHERE Id = '1'");
string ftpPassword = DAL.ReadString("SELECT ftpPassword FROM Ftp WHERE Id = '1'");
string ftpSerialPath = DAL.ReadString("SELECT ftpSerialPath FROM Ftp WHERE Id = '1'");
//Need only one query to use it in FtpClient                    
FtpClient client = new FtpClient(ftpHost, ftpLogin, ftpPassword);

我试着在stackoverflow上找一些例子，但是我找不到。

Answer 1

我用ExecuteReader

来解决这个问题

while (reader.Read())
{
object[] values = new object[reader.FieldCount];
reader.GetValues(values);
return string.Join(",", values);
}