EaSQL 1.3.3

.NET 9.0 This package targets .NET 9.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package EaSQL --version 1.3.3
                    


                    

                
NuGet\Install-Package EaSQL -Version 1.3.3
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="EaSQL" Version="1.3.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="EaSQL" Version="1.3.3" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="EaSQL" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add EaSQL --version 1.3.3
                    


                    

                
#r "nuget: EaSQL, 1.3.3"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package EaSQL@1.3.3
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=EaSQL&version=1.3.3
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=EaSQL&version=1.3.3
                    


                            Install as a Cake Tool

EaSQL

EaSQL (/ˈiː.siːkwəl/) provides some quality of life functions that will make a developer's life easier when working with SQL queries.

It allows to perform SQL queries like this:

using IDbConnection dbConnection = /* obtain database connection */
int id = 42;

using IDataReader reader = dbConnection.RunQuery($"select * from users where user_id = {id}");

There are different extension methods for different scenarios: The created command instance will contain the query string with all used parameters from the string as SQL parameters.

  • RunQuery: allows to run a query against the database
  • RunCommand: allows to run a single command (e.g. stored procedure call, update) against the database
  • GetSingleValue: allows to run a query against the database that expects to return only a single result (e.g. count queries)

It also allows to define mappings between a data reader to a model type:

public class User
{
	public int Id { get; set; }
	public string Name { get; set; }
}

Mapper<User> mapper = new()
	.DefineMapping(u => u.Id, "id")
	.DefineMapping(u => u.Name, "user_name");

IDataReader reader = // perform database query

User user = mapper.ApplyMapping(new(), reader);
Product Compatible and additional computed target framework versions.
.NET net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • net9.0

    • No dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.