private static IList <User> GetUsersFromDataBase() { IRepositorySettings repositorySettingss = new RepositorySettings(); DbUserRepository userRepository = new DbUserRepository(repositorySettingss); return(userRepository.GetAll()); }
public static void Main(string[] args) { XmlDocument doc = new XmlDocument(); doc.Load("../../conf.xml"); string dbname = ""; try { foreach (XmlNode node in doc.DocumentElement.ChildNodes) { string text = node.InnerText; if (node.Name.Equals("database")) { dbname = text; } } } catch (NullReferenceException e) { Console.WriteLine(e.Message); return; } AbstractDbRepository <User, int> db = new DbUserRepository(dbname, "user"); var lst = db.GetAll(); foreach (var keyValuePair in lst.ToArray()) { Console.WriteLine("" + keyValuePair.Key + " " + keyValuePair.Value.Username); } Console.WriteLine("------------"); db.Save(new User(19, "qwe", 3)); lst = db.GetAll(); foreach (var keyValuePair in lst.ToArray()) { Console.WriteLine("" + keyValuePair.Key + " " + keyValuePair.Value.Username); } Console.WriteLine("------------"); db.Delete(18); lst = db.GetAll(); foreach (var keyValuePair in lst.ToArray()) { Console.WriteLine("" + keyValuePair.Key + " " + keyValuePair.Value.Username); } Console.WriteLine("------------"); db.Update(new User(19, "asd", 5)); lst = db.GetAll(); foreach (var keyValuePair in lst.ToArray()) { Console.WriteLine("" + keyValuePair.Key + " " + keyValuePair.Value.Username); } Console.WriteLine("------------"); }