public void WriteListToDb() { var repository = new NHibernateRepository <Artist>(); NHibernateHelper.CreateDatabaseIfNeeded(); var testData = @"[{ ""Id"": 760, ""Name"": ""\""Weird Al\"" Yankovic"" }, { ""Id"": 3, ""Name"": "".38 Special"" }, { ""Id"": 1, ""Name"": ""3 Doors Down"" }]" ; var testObject = JSONToDatabaseReader.JSON.Serialization.Deserialize <List <Artist> >(testData); var resultingList = ReadJSONAndWriteToDb.FilterEnumerable(testObject, x => x.Name.Contains("3")); foreach (var item in resultingList) { repository.Save(item); } var nrOfArtists = repository.GetAll().Count; Assert.IsTrue(nrOfArtists == 2); }
public void CheckNumberOfEntities(int numberOfEntities) { var testEntityRepository = new NHibernateRepository <TestEntity>(); var testEntities = testEntityRepository.GetAll(); testEntities.Count.ShouldEqual(numberOfEntities); }
static void Main(string[] args) { var flagRepostory= new NHibernateRepository<Flag>(); var langRepository = new NHibernateRepository<Language>(); var langInfoRepository= new NHibernateRepository<LanguageInfo>(); //var langInfo = langInfoRepository.GetAll(); var flags = flagRepostory.GetAll(); //var lang = langRepository.Get(2); //LanguageInfo langInfo = new LanguageInfo(); //langInfo.LongPath = "test"; //langInfo.ShortPath = "test1"; //langInfo.AddLanguage(lang); //lang.AddLanguageIcon(langInfo); //langRepository.Save(lang); //langInfoRepository.Save(langInfo); Flag flag = new Flag(); flag.Name = " F*****g programe"; flag.Description = " Flag Descrption2"; var lang = langRepository.Get(2); var languageInfo = new LanguageInfoNew { LongPath = "@C:Test1", ShortPath = "@d:tet2" }; languageInfo.AddLanguage(lang); //lang.AddLanguageIcon(new LanguageInfo { LongPath = "Test1", ShortPath = "test1" }); flag.AddLanguage(languageInfo); flagRepostory.Save(flag); }
public void IntegrationTest() { IList<Banana> bananas = new List<Banana>(); bananas.Add(new Banana() { Color = "Brown" }); bananas.Add(new Banana() { Color = "Yellow" }); IRepository<Banana> bRepo = new NHibernateRepository<Banana>(); foreach (Banana b in bananas) bRepo.Save(b); Assert.IsTrue(bRepo.GetAll().Count == bananas.Count); IList<Monkey> monkeys = new List<Monkey>(); monkeys.Add(new Monkey() { Name = "George", FlingsPoo = true, Bananas = bananas }); monkeys.Add(new Monkey() { Name = "Magilla", FlingsPoo = false }); IRepository<Monkey> mRepo = new NHibernateRepository<Monkey>(); foreach (Monkey m in monkeys) mRepo.Save(m); Assert.IsTrue(mRepo.GetAll().Count == monkeys.Count); Monkey tempMonkey; tempMonkey = mRepo.Get(monkeys[0].Id); Assert.IsNotNull(tempMonkey); tempMonkey = mRepo.Get(-1); Assert.IsNull(tempMonkey); IMonkeyRepository imRepo = new MonkeyRepository(); Assert.IsTrue(imRepo.GetPooFlingingMonkeys().Count == 1); foreach (Banana b in bananas) bRepo.Delete(b); Assert.IsTrue(bRepo.GetAll().Count == 0); foreach (Monkey m in monkeys) mRepo.Delete(m); Assert.IsTrue(mRepo.GetAll().Count == 0); }
public void MappingTest() { var testObject = new Artist { Id = 123, Name = "TestBoodschap" }; var repository = new NHibernateRepository <Artist>(); NHibernateHelper.CreateDatabaseIfNeeded(); repository.Save(testObject); var result = repository.Get(123); Assert.IsTrue(testObject == result); Assert.IsTrue(repository.GetAll().Count > 0); }
/// <summary> /// Método para obtener un usuario. /// </summary> /// <returns></returns> public IList <Usuario> ObtenerUsuarios() { IList <Usuario> usuario; try { IRepository <Usuario> uRepo = new NHibernateRepository <Usuario>(); usuario = uRepo.GetAll(); return(usuario); } catch (Exception e) { log.Error(e.Message, e); throw new DataAccessException(DataAccessException.EXCEPTION, e); } }
/// <summary> /// Método para obtener una lista de proveedores. /// </summary> /// <returns></returns> public IList <Proveedor> ObtenerProveedores() { IList <Proveedor> proveedor; try { IRepository <Proveedor> pRepo = new NHibernateRepository <Proveedor>(); proveedor = pRepo.GetAll(); return(proveedor); } catch (Exception e) { log.Error(e.Message, e); throw new DataAccessException(DataAccessException.EXCEPTION, e); } }
public void getall_should_get_a_list_of_customers() { var repository = new NHibernateRepository<Customer>(); var customers = repository.GetAll<Customer>(); Assert.That(customers, Is.Not.Empty); }
public void CheckNumberOfEntities(int numberOfEntities) { var testEntityRepository = new NHibernateRepository<TestEntity>(); var testEntities = testEntityRepository.GetAll(); testEntities.Count.ShouldEqual(numberOfEntities); }
static void Main(string[] args) { //create tables from mapping new SchemaExport(NHibernateHelper.Configuration).Create(false, true); #region use_inline //open connection to db using (ISession session = NHibernateHelper.SessionFactory.OpenSession()) { #region add using (ITransaction tx = session.BeginTransaction()) { for (int i = 0; i < 30; i++) { var employee = new Employee { Name = new Name { FirstName = "Employee", LastName = string.Format("{0}", i) } }; var employer = new Employer { Name = string.Format("Employer {0}", i) }; var employment = new Employment { Employee = employee, Employer = employer, StartDate = System.DateTime.Now, EndDate = System.DateTime.Now.AddDays(i) }; session.Save(employee); session.Save(employer); session.Save(employment); } tx.Commit(); } #endregion #region list using (var tx = session.BeginTransaction()) { //dont forget ToList() var employments = session.Query <Employment>().ToList(); foreach (var employment in employments) { Console.Out.WriteLine("Employee: " + employment.Employee.Name.LastName + " end date " + employment.EndDate + " at employer " + employment.Employer.Name); } tx.Commit(); } #endregion } #endregion #region using_repository IRepository <Employment> EmploymentRepository = new NHibernateRepository <Employment>(); IRepository <Employee> EmployeeRepository = new NHibernateRepository <Employee>(); IRepository <Employer> EmployerRepository = new NHibernateRepository <Employer>(); #region add for (int i = 0; i < 30; i++) { var employee = new Employee { Name = new Name { FirstName = "Employee", LastName = string.Format("{0}", i) } }; var employer = new Employer { Name = string.Format("Employer {0}", i) }; var employment = new Employment { Employee = employee, Employer = employer, StartDate = System.DateTime.Now, EndDate = System.DateTime.Now.AddDays(i) }; EmployeeRepository.Save(employee); EmployerRepository.Save(employer); EmploymentRepository.Save(employment); } #endregion #region show foreach (var employment in EmploymentRepository.GetAll()) { Console.Out.WriteLine("Employee: " + employment.Employee.Name.LastName + " end date " + employment.EndDate + " at employer " + employment.Employer.Name); } #endregion #endregion }