48 packages tagged with “tsql”
Library for Parsing SQL Server T-SQL Scripts
TSQL Formatting tool
TSQL Module for KY-Generator Download KY.Generator to use this module
A fully tested wrapper class for querying stored procedures.
Common interfaces for TSQLLint Console, Lib, and Plugins
Facil generates F# data access source code from SQL queries and stored procedures. Optimized for developer happiness.
Miracle Devs ORM Sql Server Connector library.
Implements an F# type provider for SQL statements.
This is the SQL Server connector for ETLBox. It enables integration with Microsoft SQL Server for handling structured data in ETL workflows. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
Fling significantly reduces boilerplate needed to efficiently save/load complex domain entities to/from multiple tables.
Scan dependencies and identifiers contained in TSQL scripts.
SqExpress is a SQL query builder that allows you to create SQL expressions directly in C# code with strong typing and IntelliSense (without LINQ!). The library provides a generic SQL syntax tree with export to MS T-SQL, PostgreSQL, and MySQL text. It includes polyfills to compensate for features lacking in certain databases, such as the "MERGE" command. It also provides a set of builders and operators that will help you build complex SQL expressions. It does not use LINQ, and your C# code will be as close to real SQL as possible. This makes it ideal when you need full SQL flexibility to create efficient DB requests. SqExpress comes with a simple but efficient data access mechanism that wraps ADO.Net DbConnection and can be used with MS SQL Client, Npgsql, or MySQL Connector. You can use SqExpress together with the “Code First” concept when you declare SQL tables as C# classes with the possibility to generate recreation scripts for a target platform (MS SQL or PostgreSQL or MySQL). You can also use it in conjunction with the “Database First” concept using an included code modification utility. The utility can also be used to generate flexible DTO classes with all required database mappings. Here’s an article that explains the library principles: [“Syntax Tree and Alternative to LINQ in Interaction with SQL Databases”](https://itnext.io/syntax-tree-and-alternative-to-linq-in-interaction-with-sql-databases-656b78fe00dc?source=friends_link&sk=f5f0587c08166d8824b96b48fe2cf33c)
SQL Server driver companion for CommonNetFuncs.Sql.Common
Tools and extensions for working with data.
Removes the boilerplate needed to use Fling with Facil.
Package Description
This library is SQL database schema version control, This library will execute SQL schema migration query list in .net projects. It's useful for software developers who don't want to use something like Entinty Framework code first and they prefer write their schema migration query by themselves.
Provides abstractions for TxCommand.Sql, including ITxCommand, ISession and ISessionFactory.
Helper methods that deal with preparing and executing queries.
Adds config for using Rezoom.SQL.Provider with MS SQL Server.
Executes any number of sql files on MS SQL Server. Since the code doesn't know the order to execute the files, it uses a retry mechanism until each batch in the file executes successfully
Library for Colorizing SQL Server T-SQL Scripts
.Net Library for Parsing Database Object Dependencies from T-SQL Scripts
A fixture for XUnit that start up a Microsoft SQL Server DB to test your code with. Whilst it was built for XUnit it should be framework agnostic.
C#/VB.NET database utility to write pure Microsoft SQL queries with beautifull API, to load data into environment variables and instances and to execute any pure SQL nonquery.
Translate GraphQL queries to T-SQL
Attribute based sql bulk wrapper
C#/VB.NET database utility to write pure Microsoft SQL/MySQL/PostgreSql/Oracle/SQLite/ODBC/OleDb queries and load data into environment variables and instances. This is core package only. Install this package only by installing specific database package like: Databasic.<DatabaseType>. Then this package will be installed automaticly with the specific database package.