EasyDatabaseManager 1.0.0

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package EasyDatabaseManager --version 1.0.0
                    


                    

                
NuGet\Install-Package EasyDatabaseManager -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="EasyDatabaseManager" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="EasyDatabaseManager" Version="1.0.0" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="EasyDatabaseManager" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add EasyDatabaseManager --version 1.0.0
                    


                    

                
#r "nuget: EasyDatabaseManager, 1.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package EasyDatabaseManager@1.0.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=EasyDatabaseManager&version=1.0.0
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=EasyDatabaseManager&version=1.0.0
                    


                            Install as a Cake Tool

EasyDatabaseManager

A self-contained ASP.NET Core SQL data explorer built on ADO.NET only.

Features

  • No dependency on DbContext or EF Core
  • Connection string and database type are passed from Program.cs
  • Hidden columns are never returned to the UI or API
  • Masked columns are returned as ••••••••
  • Optional soft delete column support with All / Active / Deleted filtering
  • Update endpoint for editable fields only
  • Works with SQL Server, PostgreSQL, MySQL, and SQLite

Program.cs

using EasyDatabaseManager.Configuration;
using EasyDatabaseManager.Endpoints;

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddSqlDataExplorer(options =>
{
    options.ConnectionString = builder.Configuration.GetConnectionString("DefaultConnection")!;
    options.DatabaseType = SqlDataExplorerDatabaseType.SqlServer;

    options.RoutePrefix = "/dev/sql-data-explorer";
    options.EnableWriteOperations = true;
    options.SoftDeleteColumn = "DeletedAt";

    options.HiddenColumns.Add("PasswordHash");
    options.HiddenColumns.Add("RefreshToken");

    options.MaskedColumns.Add("ApiKey");
    options.MaskedColumns.Add("PrivateKey");
    options.MaskedColumns.Add("SecretKey");
});

var app = builder.Build();

app.MapSqlDataExplorer();

app.Run();

Open the explorer

/dev/sql-data-explorer

Pack

dotnet pack ./EasyDatabaseManager.csproj -c Release

Push to NuGet

dotnet nuget push ./bin/Release/EasyDatabaseManager.1.0.0.nupkg --api-key <YOUR_API_KEY> --source https://api.nuget.org/v3/index.json

Notes

  • The package itself has no third-party package dependency.
  • The host application must already reference the database provider it uses at runtime, such as Microsoft.Data.SqlClient, Npgsql, MySqlConnector, or Microsoft.Data.Sqlite.
  • Hidden columns are not included in query results, record details, or inline editing.
  • Masked columns are shown masked and cannot be edited from the explorer.
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • net8.0

    • No dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.