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
hi, i'm wondering if I can use "on conflict" clause with sqlkata. I can't find anything about it in the documentation, so it seems this isn't possible, but I may...
SqlException (0x80131904): Arithmetic overflow error converting numeric to data type numeric. Code: **Issue : TotalExperience is a Numeric(3,2) field. please help.** using (TransactionScope scope = new TransactionScope()) { int affected...
I only just discovered that calling most methods on the existing Query modifies/mutates the query instance instead of returning new instance. So even if no left-side assignment is made the...
When the right hand side of Union(), Intersect() or Except() contains Common Table Expressions these are not written because CteFinder currently has no support for traversing AbstractCombine nodes. As I...
WhereConains fails when when object is guid and contains {}, e.g. {65F52295-439B-4D3D-A0E3-67563EBC514C} var myGuid = Guid.Parse({65F52295-439B-4D3D-A0E3-67563EBC514C}); var licenseTransactionLog = new Query("CMP_LicenseTransactionLog") .Select("CMP_Log_GUID") .Where("CMP_LTL_Type", "Saved order to DB") .WhereContains("CMP_LTL_Data", myGuid); Error:...
By refering to https://github.com/sqlkata/querybuilder/issues/261 and https://github.com/sqlkata/querybuilder/issues/212 I tried to implement the attribute map in my model ``` using SqlKata; namespace PrismDemo.Models { public class User { [Ignore] [Column("user_id")] public int...
Currently, the view height of the editor screen is hardcoded to 400px. I have a 27-inch monitor and half the screen is taken up by the bottom of the screen...
`new Query().From("my_table").Distinct().Select("a_column").Paginate(pageIndex, pageSize)` Will generate: SELECT COUNT(*) AS `count` FROM (SELECT DISTINCT * FROM `my_table`) AS `countQuery` should be: SELECT COUNT(*) AS `count` FROM (SELECT DISTINCT a_column FROM `my_table`) AS...
When trying to open the license in Visual Studio (nuget), the URL [`https://github.com/sqlkata/querybuilder/licence`](https://github.com/sqlkata/querybuilder/licence) is opened in browser, for which nothing is found (HTTP 404).
Oracle: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production SQLKata: 2.3.3 .Net Core 3.1 C#: ``` c# var subQuery = Db.Query(userAlias) .Take(10) .Select(bean) .WhereFalse(userAlias.Col(x => x.IsDeleted)) .WhereTrue(userAlias.Col(x => x.IsEnabled))...
