AndotNet.MariaDB
1.0.0
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package AndotNet.MariaDB --version 1.0.0
NuGet\Install-Package AndotNet.MariaDB -Version 1.0.0
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="AndotNet.MariaDB" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="AndotNet.MariaDB" Version="1.0.0" />
<PackageReference Include="AndotNet.MariaDB" />
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 AndotNet.MariaDB --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: AndotNet.MariaDB, 1.0.0"
#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 AndotNet.MariaDB@1.0.0
#: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=AndotNet.MariaDB&version=1.0.0
#tool nuget:?package=AndotNet.MariaDB&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Add connection string in Startup.cs constructor
public Startup(IConfiguration configuration)
{
DataAccessLayer.DBTools.DBConfig.ConnectionString = Configuration.GetSection("DBConfig").GetValue<string>("ConnectionString");
}
Create class Person, add [JsonConvertable] attribute, and implement IErrMsg interface
[JsonConvertable]
public class Person : Base, IPerson, IErrMsg
{
public int? ID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string ErrMsg { get; set; } // implemented from IErrMsg interface
public Person()
{
}
}
Create function, call stored procedure from MariaDB
public async Task<Person> GetAsync()
{
try
{
//stored procedure parameters
List<SPParam> par = new List<SPParam>
{
new SPParam("id", this.ID),
new SPParam("languageID", this.Language?.ID),
new SPParam("RoleInAction",this.RoleInAction),
new SPParam("UserInAction",this.UserInAction),
};
Person item = await MySQLDataAccess<Person>.ExecuteSPItemAsync("GetPerson", par); // GetPerson is the name of stored procedure
return item;
}
catch (Exception ex)
{
return null;
}
finally
{
}
}
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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 was computed. 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. net9.0 was computed. 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. |
| .NET Core | netcoreapp3.1 is compatible. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETCoreApp 3.1
- MySqlConnector (>= 0.62.0)
- Newtonsoft.Json (>= 12.0.3)
- System.Data.SqlClient (>= 4.8.1)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.