DBHelper.NET 5.1.0

DBHelper.NET DBHelper.NET is a powerful and extensible .NET library designed to simplify SQL Server database operations. It provides a rich set of helper methods for querying, updating, and managing data using ADO.NET, LINQ, and even API-based access.

📦 Installation Install via NuGet Package Manager:

Install-Package DBHelper.NET

Or via .NET CLI:

dotnet add package DBHelper.NET

🚀 Features Data Lookup Helpers: DLookup, DMax, DMin, DFirst, DLast, DSum, DAverage, DCount Existence Checks: Exist methods to verify record presence Update Helpers: DUpdate for updating records Direct SQL Execution: ExecuteReaderQuery, ExecuteNonReader API Integration: Execute SQL queries via web APIs with JSON serialization Record Management: Save and Delete methods for class-based persistence Lambda to SQL Translation: Convert LINQ expressions to SQL WHERE clauses File Transfer Support: Upload and download files via API

🧠 Usage Examples Lookup a Value

		string connStr = "...";
		var name = DBHelper.DLookup<string>(connStr, "Name", "Users", "Id = 1");
		
	Count Records
		long count = conn.DCount("*", "Orders", "Status = 'Pending'");
		
	Update a Record
		int rowsAffected = conn.DUpdate("Status", "Orders", "Id = 1", "Completed");
		
	Execute SQL Query
		DataTable dt = conn.ExecuteReaderQuery("SELECT * FROM Products
		
	Save a Class Object
		var product = new Product { Id = 1, Name = "Widget", Price = 9.99 };
		product.Save(connStr);
	
	Lambda to SQL
		string sqlWhere = LambdaToSqlTranslator.Translate<Product>(p => p.Price > 10 && p.IsActive);
		
	API Integration
		DataTable dt = conn.ExecuteReaderQuery("SELECT * FROM Products", "your-api-key", "https://api.example.com");
	
	File Transfer
		bool uploaded = DBHelper.UploadFile("local/file.txt", "/server/path", "api-key", "https://api.example.com");
		

Class Oriented Usage 💾 Saving a Class Object To use the Save<T> method, your class must:

	Be a public class.
	Include a public field named KeyList containing a comma-separated list of key property names.
	Have properties that match the column names in the corresponding SQL table.
	🧪 Example: Saving a Product Object
		
		public class Product
		{
			// Required: Comma-separated list of key fields
			public static string KeyList = "Id";

			// Properties must match SQL table column names
			public int Id { get; set; }
			public string Name { get; set; }
			public decimal Price { get; set; }
			public bool IsActive { get; set; }
		}
		
💡 Save a Single Record
	
	var product = new Product
	{
		Id = 1,
		Name = "Super Widget",
		Price = 19.99m,
		IsActive = true
	};

	int result = product.Save(connectionString);

💡 Save a List of Records var products = new List<Product> { new Product { Id = 1, Name = "Widget A", Price = 9.99m, IsActive = true }, new Product { Id = 2, Name = "Widget B", Price = 14.99m, IsActive = false } };

int result = products.Save(connectionString);

		

🧩 Requirements .NET Framework 4.6.1+ or .NET Core 3.1+ SQL Server Newtonsoft.Json

📄 License MIT License