抜粋

StudyMagager.cs

using UnityEngine;
using UnityEngine.UI;
using System.Collections;
using System.Linq;

public class StudyManager : MonoBehaviour {
	
	[SerializeField] QuestionDB qDB;
	private int[] indexList = new int[10];

	// Use this for initialization
	void Start () {
		//指定のカテゴリIDのリストを抽出
		var cList = qDB.list.FindAll(qData => qData.categoryID == SQLMethods.CerrentID());
		//データベースの更新
		SQLMethods.InsertQDB(cList);
		//datetime昇順で並べ替え
		var newList = cList.OrderBy(p => p.datetime);
		//idを配列に移す
		int i = 0;
		foreach(var n in newList){
			if(i < 10){
				indexList[i] = n.id;
			}else{
				break;
			}
			i++;
		}
	}
}