Found 940 packages
The Dapper SqlBuilder component, for building SQL queries dynamically.
A powerful Dynamic Sql Query Builder supporting SQL Server, MySql, PostgreSql, Sqlite, and Oracle
Adds the execution capabilities for SqlKata
Package Description
This client library allows ADO.NET developers to create applications that implement and use the pattern known as database sharding in Azure SQL Database. Sharding is a scale-out strategy that spreads data across a number of independent databases. The library includes APIs for creating and managing shard maps, routing SQL operations to the appropriate shard, and performing queries that cross many shards. To learn more about elastic database tools, check out http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-documentation-map/.
Akka.NET streams support for ADO.NET Persistence middleware.
LLBLGen Pro is a leading ORM framework and entity modelling solution for .NET. This package contains the Dynamic Query Engine for Microsoft SQL Server.
Provide an easy way of mapping objects to SQL Server database table by using Attributes. If you want to query a database table but do not want to write complex and complicated SQL query, you can use this package. By just specifying some metadata on class and its property using attributes, you can start querying the table in no time. Sub-framework: KininTech.SqlMapping.ORM Important Note: The main class for this package, EntityTable, implements IEnumerable interface, so you can easily use Linq to query the entities in the EntityTable as the entities are mapped to the records in the database table.
re-linq Frontend: A foundation for parsing LINQ expression trees and generating queries in SQL or other languages. Key features: - Transforms expression trees into abstract syntax trees resemblying LINQ query expressions (from ... select syntax) - Simplifies many aspects of this tree (sub queries, transparent identifieres, pre-evaluation ...) - Provides basic infrastructure for backend development (e.g. SQL generation) - Provides a framework for user-defined query extensions and transformations
SQL Builder using Fluent API and String Interpolation
Visual SQL Query Builder for classic ASP.NET and MVC environemnts, Razor and ASPX view engines, with full support of all popular database servers and appropriate SQL dialects. Working with Active Query Builder the end-user can combine visual query building with direct SQL query text editing. Active Query Builder allows for parsing of complex SQL queries for their visual representation as well as for programmatic analysis and modification.
SqlHydra.Query is an F# query builder powered by SqlKata.Query that supports SQL Server, PostgreSQL, Sqlite, MySQL and Oracle.
Old version of the DbGate class for MS SQL Server. This package is deprecated now. Please use Korzh.EasyQuery.SqlServerGate instead. Korzh.EasyQuery.SqlServerGate package contains exactly the same classes and data structures as in Korzh.EasyQuery.MsSqlGate but it references the new package for working with SQL Server database (Microsoft.Data.SqlClient) instead of the old one (System.Data.SqlClient). Microsoft still supports both these packages but all the new features will be added to the first one only, so it's better to switch to it in your projects. For more information on this topic please take a look at https://devblogs.microsoft.com/dotnet/introducing-the-new-microsoftdatasqlclient/ If for some reason, you prefer to stay with the old SQL Server package (System.Data.SqlClient), you can continue to use this package (Korzh.EasyQuery.MsSqlServerGate) as well but we strongly recommend you make that switch as soon as possible.
A simplistic ADO.NET wrapper.
Dapper Query Builder using Fluent API and String Interpolation
EasyQuery DbGate class for Postgre SQL
EasyQuery DbGate class for MySQL
LLBLGen Pro is a leading ORM framework and entity modelling solution for .NET. This package contains the Dynamic Query Engine for PostgreSql. This package has an indirect dependency on Npgsql, the ADO.NET provider for PostgreSql, and it has to be present on the system at runtime. For .NET 4.5.2 and up it's not necessary to reference the ADO.NET provider directly in your project. For .NET Standard 2.0 and up, you have to reference the Npgsql package as well. See the LLBLGen Pro Runtime Framework documentation for details.
EasyQuery components add visual query designer in your ASP.NET MVC application. It will be quite helpful if you need a form for advanced search or some filtering functionality for your CRUD views. Users do not need to know about your database design, tables, joins, etc - all queries are constructed visually simply by assembling a phrase in natural language. EasyQuery can generate queries for different query languages (SQL, Entity SQL, Linq, Filter expression) and all popular databases (SQL Server, MySQL, Oracle, Access, Postgre SQL, etc). This package also supports Scaffold commands to quickly add an "advanced search" form to your MVC application. Command examples: PM> Scaffold EasyQuery.MvcController {ControllerName} -ConnectionName {ConnectionName} or PM> Scaffold EasyQuery.MvcController {ControllerName} -DbContext {DbContextName}
EasyQuery DbGate class for MS SQL Server