querybuilder
querybuilder copied to clipboard
sqlkata
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
how to use include. I use code example : ``` var q = db.Query().From("SysUser"); //db.Statement q.IncludeMany("UserRoles", db.Query("SysUserRole"),"Uid","Id"); var d1= db.Get(q).ToList(); ``` the table SysUserRole has one record ,but the d1...
Hello I know it is possible to combine multiple `SELECT` statements, but I have a use case where I could use some sort of combine `Query` for delete + insert....
Dabatase: Postgres Function body sample: ``` create function code__search(p_lang_code text, p_search_text text, p_type_ids integer[]) returns TABLE(id bigint, name text) language sql as ... ``` Code Sample for calling function: ```...
Hi Team, We's running Synk scan and it show a vulnerability for for System.Text.RegularExpressions 4.3.0. check this link https://security.snyk.io/vuln/SNYK-DOTNET-SYSTEMTEXTREGULAREXPRESSIONS-174708 I tracked it down to the dependency of sqlkata, found that...
I have a query with joins and a select distinct for some columns. The query gives normal results, but when I want to get a count of the query with...
I would like to add hints like OPTION (RECOMPILE). which comes on the end of queries. https://blogs.msdn.microsoft.com/robinlester/2016/08/10/improving-query-performance-with-option-recompile-constant-folding-and-avoiding-parameter-sniffing-issues/ I couldn't find a way to do this. Are there any plans to...
I think I found an error in your documentation in the "data pagination" section. ```c# // users is of type `PaginationResult` var users = query.Paginate(1, 10); foreach(var user in users.Each)...
Hi Replaced simple component names with string constants. In my opinion it will be more understandable and convenient for further maintenance.
The same issue still exists: #437 Could you please specify if am I doing something wrong, because I just need to have generated SQL? ``` public class ClientMode { public...
