querybuilder

querybuilder copied to clipboard

Add support for MySQL, USE INDEX on TABLE and JOIN.

1

msmudde

Rc/0.0.2

1

betine

Fix for issue #592, json query fix when question mark is used in data

3

Fix places where the parameterPlaceholder is hardcoded to a question mark ? Since the SqlResult still contained **ToString** method which had the hardcoded placeholder, here is what I've done: 1)...

kamisoft-fr

Added `readonly` modifier to `private` fields that are never modified

1

I am verifying that the project is alive

Lehonti

I noticed that Dapper requires a different syntax for parameters in query depending on which type of connection you use. I'm using a SQL Server database. This is the code...

mconca-kube

Maybe You will be interested in hosting API Explorer online: https://www.robiniadocs.com/d/querybuilder/api/SqlKata.html This is ready-to-go, so above link can be added to README for other people to see it. Or using...

NeuroXiq

2.4.0 DISTINCT FirstOrDefault without Order By defined adds wrong Order BY statement - SqlServerCompiler

2

Query: ``` var query = Db.Query("tdProducts") .Select("tdProductTypes.IsStock", "tdProductVariants.MainVariantID") .Distinct() .Join("tdProductTypes", "tdProductTypes.ProductTypeID", "tdProducts.ProductType") .Join("tdProductVariants", "tdProductVariants.ProductID", "tdProducts.ProductID") .Join("tdDimensionCombinations", "tdDimensionCombinations.VariantID", "tdProductVariants.VariantID") .Join("tdDimensions", j => j.On("tdDimensions.DimensionID", "tdDimensionCombinations.DimensionID") .WhereIfNotNull("tdDimensions.scnlDimensionUnit", 0)) .Join("tdDimensionValues", j => j.On("tdDimensionValues.DimensionID", "tdDimensions.DimensionID")...

nielslucas

seems like this commit is required for queries like this to compile properly: new Query("Alert").Join("AlertDefinition", "AlertDefinition.Id", "Alert.AlertDefinitionId") .Where("AlertDefinition.Id", (int)5) .AsDelete();

ElderOrb

Hi, What's the recommended way to use Oracle connection pooling when using SqlKata.Execution? Should I create a new QueryFactory (and new OracleConnection) in every place that I would have created...

galarlo

Hi, We're running a sysdig security scan which is reporting two vulnerabilities in system.private.uri/4.3.0 - https://github.com/advisories/GHSA-xhfc-gr8f-ffwc and https://github.com/advisories/GHSA-5f2m-466j-3848 I believe I've tracked it down to the dependency that sqlkata/querybuilder has...

AnyFlippingUsernameWillDo