public void ShouldConcatMultipleWhereCallsWithLogicalAnd() { var builder = new StringBuilder(); var context = new TextContext <Book>(new StringWriter(builder)); var query = context.Where(x => x.Id == 1).Where(x => x.Author == "Scott"); query.FirstOrDefault(); Assert.AreEqual(Expected(), Source(builder)); }
public void ShouldAssertObjectNameAsSpecifiedInNameAttribute() { var builder = new StringBuilder(); var context = new TextContext <Library>(new StringWriter(builder)); var query = from libary in context select libary; query.Count(); Assert.AreEqual(Expected(), Source(builder)); }
public void ShouldAssertSimpleSelect() { var builder = new StringBuilder(); var context = new TextContext <Book>(new StringWriter(builder)); var query = from book in context select book; query.Count(); Assert.AreEqual(Expected(), Source(builder)); }
public void ShouldAssertSimpleWhereThatHasMethodCall() { var builder = new StringBuilder(); var context = new TextContext <Book>(new StringWriter(builder)); var query = from book in context where book.Author == GetAuthor(1) select book; query.Count(); Assert.AreEqual(Expected(), Source(builder)); }
public void ShouldAssertOrderByDescending() { var builder = new StringBuilder(); var context = new TextContext <Book>(new StringWriter(builder)); var query = from book in context orderby book.Author descending select book; query.Count(); Assert.AreEqual(Expected(), Source(builder)); }
public void ShouldAssertWhereWithNestedLeftAndRightLogicaExpression() { var builder = new StringBuilder(); var context = new TextContext <Book>(new StringWriter(builder)); var query = from book in context where (book.Id == 10 && book.Author == "Plarosi") || (book.Id == 1 && book.Author == "Charlie") select book; query.Count(); Assert.AreEqual(Expected(), Source(builder)); }
public void ShouldAssertSimpleWhereWithLogicalExpression() { var builder = new StringBuilder(); var context = new TextContext <Book>(new StringWriter(builder)); var query = from book in context where book.Id == 1 && book.Author == "Charlie" select book; query.Count(); Assert.AreEqual(Expected(), Source(builder)); }
public void ShouldJoinWhereUsingAndWhenNextCallHavingLogicalExpr() { var builder = new StringBuilder(); var context = new TextContext <Book>(new StringWriter(builder)); var query = context .Where(x => x.ISBN == "111") .Where(x => x.Id == 1 || x.Author == "Scott" || x.IsAvailable); query.FirstOrDefault(); Assert.AreEqual(Expected(), Source(builder)); }