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.
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.
// Install AndotNet.MariaDB as a Cake Addin #addin nuget:?package=AndotNet.MariaDB&version=1.0.0 // Install AndotNet.MariaDB as a Cake Tool #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. |
.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.