public void Should_be_able_to_execute_read_and_write_queries_to_same_session() { //arrange var b1 = new Book { Title = "The Silmarillion" }; var crit = new SearchCriteria { Compare = ComparisonType.Equals, PropertyName = "Title", Value = "The Silmarillion" }; //act _repo.Create(b1); var b2 = _repo.Search(crit)[0]; _repo.Delete(b1); //assert Assert.AreEqual(b1.Title, b2.Title); }
public void Should_be_able_to_Search_by_SQL() { //arrange var advCrit = new AdvancedSearchCriteria(); var crit = new SearchCriteria(); crit.Compare = ComparisonType.SqlExp; crit.Value = "Condition = 1"; advCrit.SearchFilter = new List<SearchCriteria> { crit }; advCrit.OrderBy = new List<OrderCriteria>(); var expectedTitle = "The Hobbit"; var expectedRecords = 2; //act var books = _repo.Search(advCrit); var actualTitle = books[0].Title; var actualRecords = books.Count; //assert Assert.AreEqual(expectedRecords, actualRecords); Assert.AreEqual(expectedTitle, actualTitle); }
public void Should_be_able_to_Search_by_InGuid() { //arrange var advCrit = new AdvancedSearchCriteria(); var crit = new SearchCriteria(); crit.Compare = ComparisonType.InGUID; crit.PropertyName = "BookGuid"; crit.Value = new List<Guid> { new Guid("11111111-1111-1111-1111-111111111111"), new Guid(), new Guid("33333333-3333-3333-3333-333333333333") }; advCrit.SearchFilter = new List<SearchCriteria> { crit }; advCrit.OrderBy = new List<OrderCriteria>(); var expectedTitle = "The Hobbit"; var expectedRecords = 2; //act var books = _repo.Search(advCrit); var actualTitle = books[0].Title; var actualRecords = books.Count; //assert Assert.AreEqual(expectedRecords, actualRecords); Assert.AreEqual(expectedTitle, actualTitle); }
public void Should_be_able_to_Search_by_InInt() { //arrange var advCrit = new AdvancedSearchCriteria(); var crit = new SearchCriteria(); crit.Compare = ComparisonType.InInt; crit.PropertyName = "Condition"; crit.Value = new List<int> { 2, 3, 4 }; advCrit.SearchFilter = new List<SearchCriteria> { crit }; advCrit.OrderBy = new List<OrderCriteria>(); var expectedTitle = "Fellowship of the Ring"; var expectedRecords = 1; //act var books = _repo.Search(advCrit); var actualTitle = books[0].Title; var actualRecords = books.Count; //assert Assert.AreEqual(expectedRecords, actualRecords); Assert.AreEqual(expectedTitle, actualTitle); }
public void Should_be_able_to_Search_by_InString() { //arrange var advCrit = new AdvancedSearchCriteria(); var crit = new SearchCriteria(); crit.Compare = ComparisonType.InString; crit.PropertyName = "Title"; crit.Value = new List<String> { "The Hobbit", "Starship Troopers", "The Two Towers" }; advCrit.SearchFilter = new List<SearchCriteria> { crit }; advCrit.OrderBy = new List<OrderCriteria>(); var expectedTitle = "The Hobbit"; var expectedRecords = 2; //act var books = _repo.Search(advCrit); var actualTitle = books[0].Title; var actualRecords = books.Count; //assert Assert.AreEqual(expectedRecords, actualRecords); Assert.AreEqual(expectedTitle, actualTitle); }
public void Should_be_able_to_Search_by_LikeAnywhere() { //arrange var advCrit = new AdvancedSearchCriteria(); var crit = new SearchCriteria(); crit.Compare = ComparisonType.LikeAnywhere; crit.PropertyName = "Title"; crit.Value = "The"; advCrit.SearchFilter = new List<SearchCriteria> { crit }; advCrit.OrderBy = new List<OrderCriteria>(); var expectedTitle = "The Hobbit"; var expectedRecords = 4; //act var books = _repo.Search(advCrit); var actualTitle = books[0].Title; var actualRecords = books.Count; //assert Assert.AreEqual(expectedRecords, actualRecords); Assert.AreEqual(expectedTitle, actualTitle); }