DatabaseCS 1.0.4

Requires NuGet 1.0 or higher.

Install-Package DatabaseCS -Version 1.0.4
dotnet add package DatabaseCS --version 1.0.4
<PackageReference Include="DatabaseCS" Version="1.0.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DatabaseCS --version 1.0.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DatabaseCS, 1.0.4"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install DatabaseCS as a Cake Addin
#addin nuget:?package=DatabaseCS&version=1.0.4

// Install DatabaseCS as a Cake Tool
#tool nuget:?package=DatabaseCS&version=1.0.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Database.cs

Small note

In the examples right below you'll see that i use a lot of strings variables starting with $"my string" it is because it allow me to easily concat variables into my string, it also automatically convert the type of the variable into a string.

Also please note that english is not my main language, i'm a computer science student and as i use this library a lot i've choosed to share it with you :3

Depedencies

This packages is using mysql.data

How to use it

After downloading the project you just have to include it in your usings using → using DatabaseCS.

After that you'll have to establish the connection with the database using the Database.Connect() (do not forget to surround it with a try-catch because an error will be thrown if the connection failed) The connection method has an overloard containing a password in case if your database needs a password. Argument → ( (Server, Database, Username, (Password) )

Example without password
//Establish a connection without a password
Database.Connect("localhost", "MyDb", "root");
Exeample with a password
//Establish a connection with a password
Database.Connect("localhost", "MyDb", "root", "password");

Utilisation

Since the 1.0.2 the usage of this library is way easier, and also faster. <sub>*Before attempting to execute ANY request you HAVE to establish a connection with the server.</sub>

  • Select The Select method return a list of dictionnary containing your data, the keys to the date is the column name. It might look a bit scary but using a var type variable makes it easier.

There are two ways of executing a select request.

Exemple standard
var Data = Database.Select($"SELECT prenom, nom, age FROM tbl_users WHERE id={this.Id}");

<sub>(The argument of the method is a String, you can also put a string variable containing your request in here)</sub>

Example using the extension method
var Data = strRequest.Select();

or

var Data = "SELECT * FROM tbl_users".Select();

  • How to use the fetched datas Once the select done you can check all of the datas using a foreach.
If you know that your request only return one record you can do something like this
var Data = strRequete.Select();
Console.WriteLine(Data[0]["firstname"]);

<sub>This will display in the console the firstname of the first fetched record.</sub>

  • This example will display the names of all of the user in my db, user by user
var Data = "SELECT * FROM tbl_users".Select();
foreach(Dictionnary<string, string> row in Data){
Console.WriteLine(row["name"]);
}

If this example looks a bit too complicated you can also do it like this :

var Data = "SELECT * FROM tbl_users".Select();
foreach(var row in Data){
Console.WriteLine(row[nom]);
}

<sub> Be careful ! doing it this way might frighten your teachers..</sub>

  • Insert <sub>The argument to pass in parameter is your sql request.</sub>
Database.Write($"INSERT INTO tbl_users(prenom, nom, age) VALUES(\"{firstname}\",\"{name}\",{age}");

Or

$"INSERT INTO tbl_users(prenom, nom, age) VALUES(\"{firstname}\",\"{name}\",{age}".Write();
  • Update
Database.Write($"UPDATE tbl_users SET age={age} WHERE nom = \"{name}\"");

OU

$"UPDATE tbl_users SET age={age} WHERE nom = \"{name}\"".Write();

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.4 60 9/16/2021
1.0.3 56 9/16/2021
1.0.2 116 9/12/2021
1.0.1 116 9/12/2021
1.0.0 43 9/12/2021