DataCrud.DBOps.AspNetCore 1.0.1

DataCrud.DBOps

DataCrud.DBOps is a premium, high-performance database maintenance and job orchestration library for .NET. Designed to bridge the gap between modern cloud-native architectures and legacy enterprise systems, it provides a unified interface for database backups, index optimization, and real-time operational monitoring.

✨ Key Features

• ⚡ Intelligent Maintenance: Automated database shrinking and sophisticated index management (Reorganize/Rebuild) to ensure peak performance.
• 🛡️ Resilient Backups: Automated full-database backup workflows with high-ratio compression and integrity verification.
• ☁️ Multi-Cloud Sync: Native, high-performance integration with AWS S3 and Azure Blob Storage for off-site redundancy.
• 📊 Embedded Dashboard: A stunning, lightweight operational dashboard built with HTMX and Alpine.js, providing real-time job control and log visibility.
• 📝 Centralized Logging: Robust IJobStorage architecture supporting SQL Server and LiteDB, featuring parent/child log relationships for granular auditing.
• 🚀 Cross-Platform Heritage: First-class support for ASP.NET Core (DI-friendly) and Legacy .NET Framework (OWIN/Console).

🏗️ Architecture: Centralized History

Unlike traditional maintenance scripts, DBOps utilizes a centralized orchestration engine. All database providers report to a unified IJobStorage backend, ensuring that your maintenance history is consistent across all servers.

• Parent Logs: Summary of job type, execution status, and duration.
• Child Logs: Detailed execution traces, warnings, and error stack traces for every step of the process.

🛠 Supported Ecosystem

Category	Supported Providers	NuGet Status
Databases	SQL Server, PostgreSQL, MySQL, Oracle, MongoDB
Cloud Storage	AWS S3, Azure Blob Storage
Target Frameworks	.NET 9.0, .NET Standard 2.0, .NET Framework 4.7+
Core Components	Core Engine, Middleware, Backup, Maintenance

💻 Getting Started

1. Modern .NET (ASP.NET Core)

Install the core and your preferred provider via NuGet:

dotnet add package DataCrud.DBOps.AspNetCore
dotnet add package DataCrud.DBOps.SqlServer

Configure with Dependency Injection:

builder.Services.AddDatabaseOps(options =>
{
    // Configure Storage (Centralized History)
    options.UseSqlServerStorage("YourHistoryDbConnectionString");
    
    // Configure Jobs
    options.EnableBackupJob(cron: "0 0 * * *"); // Daily midnight backup
    options.EnableIndexMaintenance = true;
    
    // Multi-Cloud Sync
    options.AddAwsPush("bucket-name", "region");
});

2. Embedded Dashboard

Access the premium dashboard by mapping the middleware in your startup:

app.UseDatabaseOpsDashboard(options => 
{
    options.Path = "/dbops";
    options.Security.RequireAdminRole = true;
});

🔒 Security

DBOps includes built-in security filters for the dashboard, supporting:

• Basic Auth: For quick internal deployments.
• Role-based Authorization: Full integration with ASP.NET Identity and OWIN security contexts.

📜 Professional Services & Support

DataCrud.DBOps is maintained for enterprise-grade stability. For custom provider development or specialized cloud integrations, please reach out to the DataCrud team.

📄 License

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