ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery 7.0.0-preview1

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

.NET 6.0

This is a prerelease version of ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery.

Requires NuGet 5.0 or higher.

dotnet add package ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery --version 7.0.0-preview1

NuGet\Install-Package ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery -Version 7.0.0-preview1

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery" Version="7.0.0-preview1" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery --version 7.0.0-preview1

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery, 7.0.0-preview1"

#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.

// Install ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery as a Cake Addin
#addin nuget:?package=ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery&version=7.0.0-preview1&prerelease

// Install ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery as a Cake Tool
#tool nuget:?package=ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery&version=7.0.0-preview1&prerelease

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Materialize abritary classes from EF Core using raw SQL

Provides the SqlQueryAsync<T> method to help you populate arbitrary classes from a raw SQL query.

Sample usage

var context = new ChinookContext();

var result = await context.SqlQueryAsync<MyDto>("SELECT * FROM MyTable");

Feedback

Please report any issues, questions and suggestions here

Product	Versions
.NET	net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows

Compatible target framework(s)

Additional computed target framework(s)

Learn more about Target Frameworks and .NET Standard.

net6.0
- Microsoft.EntityFrameworkCore.SqlServer (>= 7.0.0-rc.2.22472.11)

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery:

Repository	Stars
ErikEJ/EFCorePowerTools Entity Framework Core Power Tools - reverse engineering, migrations and model visualization for EF Core	1.4K

Version	Downloads	Last updated
7.0.0-preview1	90	10/13/2022
6.0.0-preview1	4,696	11/13/2021
5.0.0-preview1	1,530	7/14/2021
5.0.0-alpha2	180	5/30/2021
5.0.0-alpha1	141	5/13/2021