public static IEnumerable <User> ReadUsers() { using (var command = new SQLiteCommand(DataAccess.Instance.Connection)) { command.CommandText = "SELECT id, name, userrole FROM users"; using (var reader = command.ExecuteReader()) { while (reader.Read()) { var id = reader.GetInt64(0); var userRole = UserRoleData.Find(reader.GetInt64(2)); var user = new User() { Id = id, Name = reader[1].ToString(), UserRole = userRole }; yield return(user); } reader.Close(); } } }
private void CreateDemoData() { DiscountData.CreateDemoData(); UserRoleData.CreateDemoData(); UserData.CreateDemoData(); }