sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.08k stars 498 forks source link

How can I generic `where column>1+column1`? #636

Closed Cricle closed 1 year ago

Cricle commented 1 year ago

I try to use Where but only can simple unary expression.

kenzouno1 commented 1 year ago

With expression you need use Raw method (WhereRaw,HavingRaw,OrderByRaw....)

ahmad-moussawi commented 1 year ago

as @kenzouno1 said, using .WhereRaw() is the best in this case. Does this answer your question?

Cricle commented 1 year ago

Thanks.