querybuilder
querybuilder copied to clipboard
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
``` var fQuery = new Query("SomeTable", "This is the comment associated with the selects"); var fquerysql = compiler.Compile(fQuery).ToString(); ``` The above snippet of code generates the below output `SELECT *...
Hello. SqlKata already has FromRaw method to allow write queries WITH (NOLOCK) operation but it's something needed to be fluent and doesn't need to write manually all the methods. Maybe...
Dear maintainers, We are looking to use SqlKata in one of our products. Our use case is that we want to be able to write queries that we can run...
CONTAINSTABLE is being escaped when I'm trying to use join. It seems like a JoinRaw option would be appropriate here? ``` var query = new Query("Activity as a") .Join("CONTAINSTABLE(Activity, *,...
We ran into an issue due to using strong named assemblies, and the QueryBuilder assembly does not appear to be strong-named: ``` CSC : warning CS8002: Referenced assembly 'QueryBuilder, Version=1.1.7.0,...
Hi everyone So we are using the SQL builder to create query from OData, and we want to use the FOR AUTO JSON to have results directly wrapped in a...
I tried to use WhereDatePart and I saw I had no results even when I have data on the DB, so I get the sqlkata generated SQL and I see...
The ability to ignore a property, override the column name, when using the `Insert(object)` and `Update(object)` overloads. ```cs class Entry { [Ignore] public string Type {get; set;} [Column("user_name")] public string...
## Expected Behavior Binary backwards compatibility within a major version (Semver) ## Current Behavior The addition of optional parameters in releases after 2.2.0 make the packages incompatible. ## Possible Solution...
I found an error in the test suite for single/double values, here: https://github.com/sqlkata/querybuilder/blob/422878cd703d75e245e023de89d2ac2ab693f554/QueryBuilder.Tests/ParameterTypeTests.cs#L25 and here: https://github.com/sqlkata/querybuilder/blob/422878cd703d75e245e023de89d2ac2ab693f554/QueryBuilder.Tests/ParameterTypeTests.cs#L27 You convert the string to a Single, using InvariantCulture: OK After that you convert...