25 packages tagged with “SqlKata”
Extension methods for using SqlKata to generate SQL queries for PetaPoco.
Package Description
SqlKata + Dapper + Canducci Wrapper Extensions + PostGres
SqlKata + Dapper + Canducci Wrapper Extensions
SqlKata + Dapper + Canducci Wrapper Extensions + MySQL
A set of extensions for working with HotChocolate GraphQL and Database access with micro-orms such as RepoDb (or Dapper). This extension pack provides access to key elements such as Selections/Projections, Sort arguments, & Paging arguments in a significantly simplified facade so this logic can be leveraged in the Resolvers (and lower level Serivces/Repositories that encapsulate all data access) without dependency on IQueryable deferred execution (e.g. EntityFramework).
SqlKata + Dapper + Canducci Wrapper Extensions + SqlServer
A library that is meant to extend the SqlKata Query Builder with objects that represent Database and Database Tables. This allows a 'Database' object with its own tables to be constructed, then queried more easily via methods that help build (or run) the query. This differs from Dapper and SqlKata.Execution (which uses Dapper) in that it models the concept of the database, but it also returns raw values and DataTables. SqlKata is just being used behind the scenes to generate the SQL commands. Example: The 'DataBaseTable.Select(params string[] columns)' method will return a query that requests the specified columns from the DataBaseTable object. The TableName is descibed as a property of the DataBaseTable object. The 'DataBaseTable.GetDataTable(params string[] columns)' will use the method described above to create the query, then will run the query against the parent Database object, and finally return a System.Data.DataTable.
Contains several Extension Methods for the SqlKata library. Including but not limited to: - ToDbCommand() -- Create a System.Data.Common.DbCommand of a specified type from a Query object - AsInsert() -- Extension Overload that accepts a single Column+Value combination - AsUpdate() -- Extension Overload that accepts a single Column+Value combination Also contains helper objects that can assist with creating Select statements and WHERE clauses for evaluating single column conditions - The 'SelectStatementBuilder' will compile into a SqlKata Query. - The 'IWhereCondition' interface objects will apply their conditions to that Query.
Extends RFBCodeWorks.DatabaseObjects to provides objects that represent an MSAccess database, as well as an MS EXcel workbook. Using SQL to query an excel workbook also requires some special syntax, so the ExcelWorkSheet object is also provided to ease that translation. The OLEDBConnection string will also be generated depending on the file extension (.xls vs .xslx/.xlsm), since each file format requires a different connection adapater. The AccessDatabase object is a concrete class to use the MSAccess Compiler provided by RFBCodeWorks.SqlKata.MSOfficeCompilers (required nuget pkg) Note: Due to requiring the OLEDB driver, this package is compiled for x86/x64 only.
C# Sql Where Clause Parser to be used as Rest Parameters to filter data
Adds the 'SqlLiteDatabase' class to the RFBCodeWorks.DatabaseObjects.DatabaseTypes namespace. This class uses System.Data.Sqlite.Core's SqliteConnection and SqliteCommand to communicate with the db, and Sqlkata.Compilers.SqliteCompiler to compile the queries.
A set of extensions for working with HotChocolate GraphQL and RepoDb as the data access micro-orm without dependency on IQueryable. This enables fully encapsulated control over SQL queries in every way within a Service or Repository layer of your application. This extension pack provides a significantly simplified facade to access critial elements such as Selections/Projections, Sort arguments, & Paging arguments with support for mapping them to Models using built in RepoDb functionality. It also leverages RepoDb to provide a generic, Relay spec compatible, cursor pagination/slice query api for Sql Server.
.NET library that aims to facilitate the combination of DbContexts (EntityFrameworkCore) and SqlKata queries.
The fluent way to build sql queries
Provides SqlKata compilers for Microsoft Access and Excel Workbooks
SqlKata QueryBuilder implementation for RestSQL
Helper Methods to make interacting with MS Access Dao easier. - Contains methods for reading/writing properties to the database - Contains methods for creating new tables / fields via DAO - Contains a method for using the 'Compact' functionality of an MS Access database.
Adds the 'SqlServerDatabase' class to the RFBCodeWorks.DatabaseObjects.DatabaseTypes namespace. This class uses System.Data.Sqlclient's SqlConnection and SqlCommand to communicate with the db, and Sqlkata.Compilers.SqlServerCompiler to compile the queries.
With this package you can issue SQL queries from .NET Core API to backend using SqlKata (Dapper)
The primitives and helpers needed for RepoDbExtensions.SqlServer.PagingOperations pacakge; used for working with modern pagination approaches such as Cursor based paging, as well as Offset based pagination, using the RepoDb ORM with Sql Server.
A set of extensions for working with modern pagination approaches such as Cursor based paging, as well as Offset based pagination, using the RepoDb ORM with Sql Server.
A unified, JSON-driven query engine for .NET that converts a single QueryRequest model into executable queries for SqlKata (raw SQL) and EF Core (IQueryable<T>). Supports filtering, sorting, pagination, joins, grouping, and more.
A powerful .NET 8 database manager library that implements the cache-aside pattern using PostgreSQL (via SqlKata) and Redis for caching. Supports generic repositories, query builders, and automatic cache invalidation.