AndotNet.MariaDB 1.0.0

.NET Core 3.1 This package targets .NET Core 3.1. 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 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" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="AndotNet.MariaDB" />
                    


                            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 AndotNet.MariaDB --version 1.0.0
                    


                    

                
#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
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=AndotNet.MariaDB&version=1.0.0
                    


                            Install as a Cake Tool

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 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.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on AndotNet.MariaDB:

Package Downloads
BFAdvertisement

.NET 8 support

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
7.0.0 188 3/25/2024
6.0.0 602 7/7/2021
5.0.0 438 4/18/2021
3.0.0 528 11/26/2020
2.0.0 514 11/17/2020
1.0.0 573 8/11/2020