DbEasy 1.4.0

📦 DbEasy

Version: 1.4.0

DbEasy is a Lightweight, secure and validated SQL helper for .NET.

It simplifies ADO.NET without abstracting SQL away.

🚀 Overview

DbEasy simplifies SQL execution while providing built-in validation and security features.

It focuses on:

⚡ Lightweight SQL access

🔐 SQL injection protection

✅ SQL parameter validation

📋 Logging & warnings

🧠 Safe Mode enabled by default

📦 Installation

dotnet add package DbEasy

or via NuGet Package Manager:

Install-Package DbEasy

⚡ Quick Start

using var connection =
    new SqlConnection(connectionString);

var users = connection.Query<User>(
    "SELECT * FROM Users WHERE Id = @Id",
    new
    {
        Id = 1
    });

🔐 SQL Parameter Validation

DbEasy automatically validates SQL parameters before execution.

✅ Missing Parameters Detection

db.Query<User>(
    "SELECT * FROM Users WHERE Id = @Id");

Result:

SQL parameters are required but none were provided.

⚠️ Unused Parameters Warning

db.Query<User>(
    "SELECT * FROM Users WHERE Id = @Id",
    new
    {
        Id = 1,
        Username = "ammar"
    });

[DbEasy WARNING] Unused SQL parameter detected: 'Username'

⚠️ Null Parameter Warning

db.Query<User>(
    "SELECT * FROM Users WHERE Name = @Name",
    new
    {
        Name = (string?)null
    });

❌ Unsupported Parameter Types

db.Query<User>(
    "SELECT * FROM Users WHERE Data = @Data",
    new
    {
        Data = new User()
    });

Result:

Unsupported SQL parameter type: 'User'

🔐 Safe Mode

Safe Mode is enabled by default.

DbEasyOptions.SafeModeEnabled = true;

📋 Built-in Validation Pipeline

DbEasy automatically executes:

✔ SQL injection validation

✔ Missing parameter validation

✔ Unused parameter validation

✔ Type validation

✔ Null validation

✨ Features

✔ Lightweight API

✔ SQL parameter support

✔ SQL injection protection

✔ Validation pipeline

✔ Safe Mode enabled by default

✔ Logging & warnings

✔ Async support

🪪 License

MIT License © Abdelwaheb Ammar

✅ Compatibility

.NET 6, .NET 7, .NET 8,.NET9,.Netstandard2.0,Netstandard2.1

SQL Server (more DBMS support planned)

📄 License

MIT License

👨‍💻 Author

Developed by 💬Abdelwaheb AMMAR