C#_SimpleSQLでクラスを作成
まだ動作確認をしていない。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
using System.Collections.Generic;//LIST using SimpleSQL; using System; public class Tuser //T_USER { public SimpleSQL.SimpleSQLManager dbManager; // Start is called before the first frame update [PrimaryKey] public int ID { get; set; } public int ID_USER_MASTER { get; set; } public int LEVEL { get; set; } public int physical_strength { get; set; } public int Knowledge { get; set; } public int experience { get; set; } public int waint_retire { get; set; } public int sex_type { get; set; } public int next_level_to { get; set; } public int IS_VALID { get; set; } public int IS_RETIRE { get; set;} public DateTime DATE_CREATE { get; set; } public DateTime DATE_UPDATE { get; set; } void Start() { string sql = "SELECT * FROM T_USER"; List<Tuser> users = dbManager.Query<Tuser>(sql); } } |