DotSQL 0.0.6
dotnet add package DotSQL --version 0.0.6
NuGet\Install-Package DotSQL -Version 0.0.6
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="DotSQL" Version="0.0.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DotSQL --version 0.0.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DotSQL, 0.0.6"
#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.
// Install DotSQL as a Cake Addin #addin nuget:?package=DotSQL&version=0.0.6 // Install DotSQL as a Cake Tool #tool nuget:?package=DotSQL&version=0.0.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
<h1 align="center"> <br /> DotSQL <br /> <font style="font-size:18px;">Integrated Database-Helper for .NET</font> <br /> <br /> </h1> <br /> Available for:
- .NET Standard 2.0
- .NET 6.0+
<br /> Supported Platforms:
- Windows 10+ (x86, amd64, arm64)
- Linux Distos (amd64, arm64)
- OSX 11+ (amd64, arm64)
<br /> Supported Databases:
- MySQL, MariaDB (MySQL Family)
- SQLite (amd64 only on Linux, OSX)
<br /> <hr> <br /> <br />
Install
dotnet add package DotSQL
# or specific version
dotnet add package DotSQL --version {version}
<br /> <br />
Usage
- Sequentials
using DotSQL.Builders.Sequential;
using DotSQL.Engines;
var engine = new SequentialEngine(new MariadbBuilder {
UserID = "{UserID}", Password = "{Password}",
Host = "{Host}", Port = {Port},
Database = "{Database}"
});
var result = engine.Execute("{query}");
// use ExecuteAsync method also.
var result = await engine.ExecuteAsync("{query}");
result.AsRecord(); // to List of Dictionary
result.AsDict(); // to Dictionary of String and List
result.AsJson(); // to Json, Format of Dict and Record
result.AsDataFrame(); // to Pandas.NET.Dataframe
result.AsTable(); // to System.Data.DataTable
result.AsModel<{ModelClass}>(); // to List of ModelClass
<br /> <br />
ToDo
- MSSQL Support
- Cause no Windows machines
- Non-Sequential Support
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- Microsoft.CSharp (>= 4.7.0)
- MySqlConnector (>= 2.2.5)
- Pandas.Net (>= 0.4.0)
- System.Data.SQLite (>= 1.0.117)
-
net7.0
- Microsoft.CSharp (>= 4.7.0)
- MySqlConnector (>= 2.2.5)
- Pandas.Net (>= 0.4.0)
- System.Data.SQLite (>= 1.0.117)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.