将数据库表写入列表

Question

我构建了一个函数来根据表名查询 sqlite 数据库中的特定表。现在我的调试行返回正确的信息。我想做的下一件事是将这些数据写入列表。我该怎么做？

public void RetrieveDriftData(string driftID)

    {

        string sql = "SELECT * FROM \"" + driftID + "\" ";

        GameManager.Drift = dbManager.Query<Drift>(sql);

        foreach (Drift drift in GameManager.Drift)

        {

            Debug.Log(drift.DriftStep);

        }

    }

Answer 1

如果您不需要任何特定的自定义，您可以使用C#的List(T) 类。using System;using System.Collections.Generic;List<Drift > driftList = new List<Drift>();...public void RetrieveDriftData(string driftID){&nbsp; &nbsp; string sql = "SELECT * FROM \"" + driftID + "\" ";&nbsp; &nbsp; GameManager.Drift = dbManager.Query<Drift>(sql);&nbsp; &nbsp; foreach (Drift drift in GameManager.Drift)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; Debug.Log(drift.DriftStep);&nbsp; &nbsp; &nbsp; &nbsp; driftList.Add(drift);&nbsp; &nbsp; }}

Answer 2

好吧，这就是如何从您的可枚举创建列表...public void RetrieveDriftData(string driftID){&nbsp; &nbsp; string sql = $"SELECT * FROM {driftID}";&nbsp; &nbsp; GameManager.Drift = dbManager.Query<Drift>(sql);&nbsp; &nbsp; var driftList = GameManager.Drift.ToList();}