KhatiExtendedAdo

Published At 2025/Jun/24
No Image Found

📦 KhatiExtendedAdo – Clean ADO.NET Made Simple

🔧 What It Does

KhatiExtendedAdo is a lightweight .NET library that simplifies and standardizes core ADO.NET operations like Insert, Update, Delete, Bulk Insert, and Get. It abstracts away repetitive boilerplate code while allowing direct control over SQL execution—making ADO.NET more developer-friendly without sacrificing performance.

✅ The Benefits

  • Clean & Maintainable Code: Reduces clutter by encapsulating common database logic.

  • High Performance: Keeps the speed and efficiency of raw ADO.NET.

  • Rapid Development: Helps developers quickly implement CRUD operations without manually writing every SQL statement.

  • Bulk Operation Support: Includes optimized methods for bulk data insertion.

  • Lightweight: Unlike heavy ORMs, it doesn't introduce overhead—ideal for lean applications.

💡 Why Should It Be Used?

Use KhatiExtendedAdo if:

  • You're working with raw ADO.NET and want a cleaner, reusable approach.

  • You prefer control over your SQL logic but dislike repetitive coding.

  • Your project doesn't require a full ORM (like Entity Framework) but still needs structured database operations.

  • You want to improve code readability and reduce code smell in data access layers.

Create Your Database First.

Add Connection String

  1.  "ConnectionStrings": {
  2.     "DevConnection": "Server=BS-483;Database=KhatiExtendedEFImple;Trusted_Connection=True;MultipleActiveResultSets=True;"
  3.   },

Create Context

  1.  public class PersonContext : AdoProperties , IPersonContext
  2.     {
  3.         private readonly IConfiguration _configuration;
  4.         public PersonContext(IConfiguration configuration)
  5.         {
  6.             _configuration = configuration;
  7.         }
  8.         public override string ConnectionString()
  9.         {
  10.             return _configuration.GetConnectionString("DevConnection"); 
  11.         }
  13.         public override int TimeOut()
  14.         {
  15.             return 300;
  16.         }
  17.     }
  1.  public interface IPersonContext : IAdoProperties
  2.     {
  4.     }

Add Entity

  1.  public class Student
  2.     {
  3.         [JsonProperty("id")]
  4.         public int Id { get; set; }
  5.         [JsonProperty("Name")]
  6.         public string? Name { get; set; }
  7.     }

Add Middleware

  1. builder.Services.AdoDependency();
  2. builder.Services.AddSingleton<IPersonContext, PersonContext>();

Inside Controller

  1. public class HomeController : Controller
  2.     {
  3.         private readonly ILogger<HomeController> _logger;
  4.         private readonly IPersonContext _personContext;
  5.         public HomeController(ILogger<HomeController> logger, IPersonContext personContext)
  6.         {
  7.             _logger = logger;
  8.             _personContext = personContext;
  9.         }
  11.        public async Task<IActionResult> Index()
  12. {
  13.     var insert = await _personContext.SqlWriteAsync("Insert into Student(Name) values (@Name)", 
  14.         new Dictionary<string, object>() { { "@Name", "Washiq Anwar Shamsi" }, });
  16.     List<Student> students = new List<Student>() 
  17.     { 
  18.         new Student() { Name = "The Rock"},
  19.         new Student() { Name = "Brock Lesner"}
  20.     };
  22.     await _personContext.SqlBulkUploadAsync(students,"Student");
  24.     var readAll = await _personContext.SqlReadAsync<List<Student>>("select * from Student");
  26.     var readFilter = await _personContext.SqlReadAsync<List<Student>>("select * from Student where Name = @Name",
  27.         new Dictionary<string, object>() { { "@Name", "Brock Lesner" }, });
  29.     var firstOrDefault = await _personContext.SqlReadScalerModelAsync<Student>("select Top 1 * from Student");
  31.     var readScalerValue = await _personContext.SqlReadScalerValueAsync<int>("select count(*) from Student"); 
  33.     return Ok(new 
  34.     {
  35.         readAll=readAll.Data,
  36.         readFilter = readFilter.Data,
  37.         firstOrDefault=firstOrDefault.Data,
  38.         readScalerValue=readScalerValue.Data
  39.     });
  40. }
  41.     }

Open Source

Open Source Link

Implementation

Implementation Demo

Nuget Package Link

Download Nuget Package