CODEWITHSUNDEEP
c#.netdapper
user2783193
user2783193

Reputation: 1022

proper way of using OR inside sql statement

I'm using dapper micro orm in conjuction with sql server. 

 string author = "some author name";
 var get_book_from_name = "SELECT BookId FROM Author WHERE FirstName OR LastName LIKE('%' +@AuthorName +'%')";
 var data = this.db.Query<Book>(getBookFromAuthorName, new { AuthorName = author }).SingleOrDefault();

and I'm getting error using OR statement in query statement.

Upvotes: 0

Views: 60

Answers (1)

Ant P
Ant P

Reputation: 25221

SELECT BookId FROM Author WHERE
    FirstName LIKE '%'+@AuthorName+'%' OR LastName LIKE '%'+@AuthorName+'%'

Upvotes: 4

Related Questions