DotSQL
Integrated Database-Helper for .NET

Available for:

• .NET Standard 2.0
• .NET 6.0+

Supported Platforms:

• Windows 10+ (x86, amd64, arm64)
• Linux Distos (amd64, arm64)
• OSX 11+ (amd64, arm64)

Supported Databases:

• MySQL, MariaDB (MySQL Family)
• SQLite (amd64 only on Linux, OSX)

---

Install

dotnet add package DotSQL
# or specific version
dotnet add package DotSQL --version {version}

Usage

• Sequentials

usingDotSQL.Builders.Sequential;usingDotSQL.Engines;varengine=newSequentialEngine(newMariadbBuilder{UserID="{UserID}",Password="{Password}",Host="{Host}",Port={Port},Database="{Database}"});varresult=engine.Execute("{query}");// use ExecuteAsync method also.varresult=awaitengine.ExecuteAsync("{query}");result.AsRecord();// to List of Dictionaryresult.AsDict();// to Dictionary of String and Listresult.AsJson();// to Json, Format of Dict and Recordresult.AsDataFrame();// to Pandas.NET.Dataframeresult.AsTable();// to System.Data.DataTableresult.AsModel<{ModelClass}>();// to List of ModelClass

ToDo

• MSSQL Support
  • Cause no Windows machines
• Non-Sequential Support