MySqlOptimizer 1.3.0

MySqlOptimizer

Version 1.3

A simple and efficient C# library for performing common MySQL database operations. This library provides methods for executing queries, stored procedures, and managing database connections.

Features

• Execute SQL Queries and Commands: Run SQL commands directly against the database.
• Execute Stored Procedures with Parameters: Call stored procedures and pass parameters easily.
• Execute Scalar Queries: Retrieve single values from the database.
• Execute Data Readers with Parameters: Read data using a MySqlDataReader with parameters.
• Check Database Connection Status: Verify if the database connection is successful.

Installation

You can install the package via NuGet Package Manager:

Install-Package MySqlOptimizer

Or using the .NET CLI:

dotnet add package MySqlOptimizer

Usage

1. Check Database Connection

using MySqlOptimizer;

var mysql = new MysqlShort();

bool isConnected = mysql.CheckConnection("YourConnectionString");

2. Execute a Scalar Query

using MySqlOptimizer;

var mysql = new MysqlShort();

object result = mysql.ExecuteScalar("YourConnectionString", "SELECT COUNT(*) FROM YourTable");

3. Execute a Stored Procedure

using MySqlOptimizer; using System.Collections.Generic;

var mysql = new MysqlShort();

var parameters = new Dictionary<string, object> { { "@param1", value1 }, { "@param2", value2 } };

bool success = mysql.ExecuteStoredProcedure("YourConnectionString", "YourStoredProcedureName", parameters);

4. Execute a Reader with Parameters

using MySqlOptimizer; using MySql.Data.MySqlClient;

var mysql = new MysqlShort();

var parameters = new MySqlParameter[] { new MySqlParameter("@param1", value1), new MySqlParameter("@param2", value2) };

using (MySqlDataReader reader = mysql.ExecuteReaderWithParameters("YourConnectionString", "SELECT * FROM YourTable WHERE Column1 = @param1", parameters)) { while (reader.Read()) { // Process each row } }

Exception Handling

The library throws exceptions for various error conditions. You can catch these exceptions to handle errors gracefully:

try { // Your database operation } catch (Exception ex) { Console.WriteLine(ex.Message); }

Contributing

Contributions are welcome! Please feel free to submit a pull request or create an issue if you find a bug or have a feature request.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgments

• MySQL Connector/NET
• C# and .NET community