Found 347 packages
The current data provider for SQL Server and Azure SQL databases. This has replaced System.Data.SqlClient. These classes provide access to SQL and encapsulate database-specific protocols, including tabular data stream (TDS). Commonly Used Types: Microsoft.Data.SqlClient.SqlConnection Microsoft.Data.SqlClient.SqlException Microsoft.Data.SqlClient.SqlParameter Microsoft.Data.SqlClient.SqlDataReader Microsoft.Data.SqlClient.SqlCommand Microsoft.Data.SqlClient.SqlTransaction Microsoft.Data.SqlClient.SqlParameterCollection Microsoft.Data.SqlClient.SqlClientFactory When using NuGet 3.x this package requires at least version 3.4.
The Microsoft SQL Server Data-Tier Application Framework (DacFx) is a .NET library which provides application lifecycle services for database development and management for Microsoft SQL databases. DacFx supports various database deployment and management scenarios, including extracting / exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premises to Microsoft Azure. DacFx can target all supported versions of SQL Server, as well as Microsoft Azure SQL and SQL in Fabric. If you would like to use DacFx functionality from the command-line for creating and deploying .dacpac and .bacpac packages, please use the [SqlPackage](https://www.nuget.org/packages/Microsoft.SqlPackage) CLI as a dotnet tool or downloadable exe. Learn more about SqlPackage from http://aka.ms/sqlpackage.
SqlPackage is a command-line utility that automates database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs.
The Microsoft SQL Server Data-Tier Application Framework (DacFx) is a component which provides application lifecycle services for database development and management for Microsoft SQL Server and Microsoft Azure SQL Databases. DacFx supports various database deployment and management scenarios for SQL Server and Microsoft Azure SQL Databases including extracting/exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premise SQL Server to Microsoft Azure. This functionality is exposed via the DacFx API. DacFx can target SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017 and Microsoft Azure SQL Databases. This nuget package is a lightweight version of DacFx. If you would like to use the command-line utility SqlPackage.exe for creating and deploying .dacpac and .bacpac packages, please download DacFramework.msi from Microsoft download page.
Contains the necessary SMO dependencies to allow execution of full client-side SQL scripts (eg. containing the GO command) to be executed from .NET. Such scripts can be executed from within Management Studio but will fail when executed through ADO.NET. This package contains the dependencies to allow that to happen. Example usage: public static void ExecuteSqlScript(SqlConnection conn, string script) { var serverConnection = new Microsoft.SqlServer.Management.Common.ServerConnection(conn); var server = new Microsoft.SqlServer.Management.Smo.Server(serverConnection); server.ConnectionContext.ExecuteNonQuery(script); } PS. Anyone can download Sql Server Express (for free!) and copy these assemblies from the installation folder, but having a simple package just saves so much pain.
Unofficial package for the SqlPackage command-line utility from Microsoft. Command line SqlPackage.exe to integrate in build. Taken from SQL2017 (v14) installation.
SqlCommandProvider provides statically typed access to input parameters and result set of T-SQL command in idiomatic F# way.SqlProgrammabilityProvider exposes Stored Procedures, User-Defined Types and User-Defined Functions in F# code.
The Microsoft SQL Server Data-Tier Application Framework (DacFx) is a component which provides application lifecycle services for database development and management for Microsoft SQL Server and Microsoft Azure SQL Databases. DacFx supports various database deployment and management scenarios for SQL Server and Microsoft Azure SQL Databases including extracting/exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premise SQL Server to Microsoft Azure. This functionality is exposed via the DacFx API. DacFx can target SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017 and Microsoft Azure SQL Databases. This nuget package is a lightweight version of DacFx. If you would like to use the command-line utility SqlPackage.exe for creating and deploying .dacpac and .bacpac packages, please download DacFramework.msi from Microsoft download page.
Fluent API wrapper for ADO.NET DbCommand with automatic object mapping, caching, and SQL query builder support
Fluent Wrapper for DbCommand with SQL Server support using Microsoft.Data.SqlClient
Microsoft SQL Server provider for Paramore.Brighter Command Processor. Provides common components for connecting to SQL Server, including connection and transaction management for inbox, outbox, and messaging gateway implementations.
Fluent.Sql designed to simplify a work with SqlConnection, SqlTransaction, SqlCommand and SqlDataReader objects
Displays a SqlCommand as a full SQL string with all parameters inline. Makes it easy to debug (copy paste to db tool). Please submit pull requests on GitHub.
Microsoft SQL Server outbox implementation for Paramore.Brighter Command Processor. Provides reliable message publishing with outbox pattern using SQL Server for transactional consistency and guaranteed delivery.
Entity Framework Core integration for Microsoft SQL Server provider in Paramore.Brighter Command Processor. Provides connection and transaction providers to obtain SQL Server connections from Entity Framework Core DbContext.
Azure Identity integration for Microsoft SQL Server provider in Paramore.Brighter Command Processor. Provides connection providers for Access Token authentication using Azure.Identity, supporting managed identities and Azure AD authentication.
Command line tool to create tables and indexes in a Microsoft SQL Server database for distributed caching.
Command line tool to create tables and indexes in a Microsoft SQL Server database for distributed caching. This package was built from the source code at https://github.com/dotnet/dotnet/tree/c2435c3e0f46de784341ac3ed62863ce77e117b4
Lightweight infrastructure for doing command handling and eventsourcing using aggregates.
Adds basic support for "Upsert" operations to EF Core. Uses `INSERT … ON CONFLICT DO UPDATE` in PostgreSQL/Sqlite, `MERGE` in SqlServer and `INSERT INTO … ON DUPLICATE KEY UPDATE` in MySQL. Also supports injecting sql command generators to add support for other providers