public void GetListBatchLoading() { using (var ds = new DataService()) { ds.ResetDatabase(); for (int a = 1; a <= 100; a++) { var newProduct1 = new T_E_Product(); newProduct1.Ranking = a; newProduct1.Description = a + " Product"; newProduct1 = ds.Add(newProduct1); var newPicture = new T_E_Picture(); newPicture.Name = "picture " + newProduct1.Description; newPicture.ProductId = newProduct1.ProductId; newPicture = ds.Add(newPicture); } var navPictureList = new List <System.Linq.Expressions.Expression <Func <T_E_Picture, object> > >(); navPictureList.Add(x => x.T_E_Product); if (ds.GetList <T_E_Picture>(null, navPictureList).ToList().Where(x => x.T_E_Product != null).Count() != 100) { throw new Exception(); } if (ds.GetList <T_E_Picture>().ToList().Enum().Where(x => x.T_E_Product != null).Count() != 0) { throw new Exception(); } var iquery = ds.GetListBatchLoading <T_E_Picture, long>(x => x.PictureId, System.ComponentModel.ListSortDirection.Descending, navPictureList, null, 10, 10); if (iquery.Where(x => x.T_E_Product == null).IsNotNullAndNotEmpty()) { throw new Exception(); } ds.ResetDatabase(); } }
public void GetSingle() { using (var ds = new DataService()) { ds.ResetDatabase(); var newProduct1 = new T_E_Product(); newProduct1.Ranking = 1; newProduct1.Description = "Product"; newProduct1 = ds.Add(newProduct1); var newPicture = new T_E_Picture(); newPicture.ProductId = newProduct1.ProductId; newPicture.Name = "picture"; newPicture = ds.Add(newPicture); var get1 = ds.GetSingle <T_E_Product>(x => x.Ranking == 1); if (get1.Ranking != 1) { throw new Exception(); } if (get1.Description != "Product") { throw new Exception(); } var navPictureList = new List <System.Linq.Expressions.Expression <Func <T_E_Picture, object> > >(); navPictureList.Add(x => x.T_E_Product); var get2 = ds.GetSingle <T_E_Picture>(x => x.Name == "picture", navPictureList); if (get2.T_E_Product == null) { throw new Exception(); } ds.ResetDatabase(); } }
public void GetList() { using (var ds = new DataService()) { ds.ResetDatabase(); for (int a = 1; a <= 100; a++) { var newProduct1 = new T_E_Product(); newProduct1.Ranking = a; newProduct1.Description = a + " Product"; newProduct1 = ds.Add(newProduct1); var newPicture = new T_E_Picture(); newPicture.Name = "picture " + newProduct1.Description; newPicture.ProductId = newProduct1.ProductId; newPicture = ds.Add(newPicture); } //GetList<T> if (ds.GetList <T_E_Product>().Count() != 100) { throw new Exception(); } if (ds.GetList <T_E_Product>(x => x.Description.Contains("Product")).Count() != 100) { throw new Exception(); } var navPictureList = new List <System.Linq.Expressions.Expression <Func <T_E_Picture, object> > >(); navPictureList.Add(x => x.T_E_Product); if (ds.GetList <T_E_Picture>(null, navPictureList).ToList().Where(x => x.T_E_Product != null).Count() != 100) { throw new Exception(); } if (ds.GetList <T_E_Picture>().ToList().Enum().Where(x => x.T_E_Product != null).Count() != 0) { throw new Exception(); } //GetList<T,Tkey> var iquery = ds.GetList <T_E_Product, int>(null, null, x => x.Ranking, System.ComponentModel.ListSortDirection.Descending); if (iquery.First().Ranking != 100) { throw new Exception(); } if (iquery.Last().Ranking != 1) { throw new Exception(); } iquery = ds.GetList <T_E_Product, int>(null, null, x => x.Ranking, System.ComponentModel.ListSortDirection.Descending, 10, 10); if (iquery.Count() != 10) { throw new Exception(); } if (iquery.First().Ranking != 90) { throw new Exception(); } if (iquery.Last().Ranking != 81) { throw new Exception(); } ds.ResetDatabase(); } }