A lightweight and practical C# helper class for performing common MSSQL operations using ADO.NET.
Provides simplified methods for SELECT, INSERT, UPDATE, DELETE, Stored Procedure, and BulkInsert.

• 🔹 Get data from table, raw SQL, or stored procedure
• 🔹 Insert and update data dynamically with property mapping
• 🔹 Delete records with condition enforcement
• 🔹 Execute stored procedures with input/output parameters
• 🔹 Perform high-performance BulkInsert with DataTable conversion

public class Person
{
    public int Id { get; set; } // Identity
    public string Name { get; set; }
    public int Age { get; set; }
}

var people = DbHelper.GetList<Person>("Person"); // SELECT * FROM Person

var person = new Person { Name = "Burak", Age = 30 };
int newId = DbHelper.Insert("Person", person);

var result = DbHelper.GetListProcedure<Person>("GetPeopleByAge", new { Age = 25 });

Update the connection string returned by AppSettings.GetConnection() method, for example:

public static class AppSettings
{
    public static string GetConnection()
    {
        return "Server=localhost;Database=YourDbName;Trusted_Connection=True;";
    }
}

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