pengdows.crud 1.0.1751541717

pengdows.crud

pengdows.crud is a SQL-first, strongly-typed, testable data access layer for .NET. It’s built for developers who want full control over SQL, predictable behavior across databases, and no ORM magic.

No LINQ. No tracking. No surprises.

🔍 Why pengdows.crud?

• Built by a dev who actually writes SQL, understands ACID, and doesn’t want ORMs rewriting queries behind their back.
• Works across databases using consistent, standards-compliant behavior.
• Handles parameterization, enums, JSON, audit fields, and transactions—out of the box.
• Offers full dependency injection, fine-grained connection control, and true multi-tenancy.

✅ Key Features

• EntityHelper<TEntity, TRowID>: automatic CRUD with custom SQL injection points.
• Full support for:
  • Enums
  • JSON
  • GUIDs
  • UTC timestamps
• Built-in audit tracking per entity and per field.
• Safe SQL generation with strict parameterization (@, :, or ? depending on provider).
• Connection lifecycle modes: New, Shared, KeepAlive.
• Scoped transactions via TransactionContext.
• Works cleanly with DI and ADO.NET—no leaky abstractions.

🧩 Supported Databases

Tested and tuned for:

• SQL Server / Express / LocalDB
• PostgreSQL / TimescaleDB
• Oracle
• MySQL / MariaDB
• SQLite
• Firebird
• CockroachDB

All tested against .NET 8 with native ADO.NET providers. Must support DbProviderFactory and GetSchema("DataSourceInformation").

❌ Not Supported

Due to missing or outdated .NET providers:

• TimesTen
• DB2
• Informix
• Sybase ASE
• SQL Anywhere

Want support? Ask the vendor to ship a real ADO.NET provider.

🚫 Not an ORM — On Purpose

pengdows.crud doesn't:

• Track entities
• Auto-generate complex queries
• Obfuscate SQL

Instead, it helps you write real SQL that's:

• Predictable
• Testable
• Secure

🧠 Philosophy

• Primary keys ≠ pseudokeys
• Open late, close early — manage connections responsibly
• Parameterize everything — always
• Audit everything — store in UTC
• Don't assume — use provider metadata (DbProviderFactory, GetSchema)
• Test in production-like environments — not theory

🔬 Tool Comparison

📚 Documentation

Topics include:

• EntityHelper<TEntity, TRowID>
• SqlContainer
• DbMode and connection management
• Audit and UTC logging
• Transaction scopes
• Type coercion and mapping
• Primary vs. pseudokeys
• Extending core helpers

🛠️ Getting Started

dotnet add package pengdows.crud

using System.Data.SqlClient;
using pengdows.crud;

var db = new DatabaseContext("your-connection-string", SqlClientFactory.Instance);
var helper = new EntityHelper<MyEntity, long>(db);