C# Sqlite 問い合わせ

未分類
    public string GetData(int peck_id, string user)
    {
        string json = string.Empty;

        var sqlConnectionSb = new SQLiteConnectionStringBuilder { DataSource = @"pigeonpeck.db" };

        using (var cn = new SQLiteConnection(sqlConnectionSb.ToString()))
        {
            cn.Open();

            using (var cmd = new SQLiteCommand(cn))
            {
                //テーブル作成
                cmd.CommandText = "SELECT * FROM peck WHERE id > "+ peck_id;
                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        json += (string)reader["peck"];
                    }
                }
            }
        }

        return json;
    }