FonsecaFramework.Sql 2026.5.21.1

FonsecaFramework.Sql

SQL Server and PostgreSQL database utilities for .NET.

Overview

FonsecaFramework.Sql is a .NET 9 library that simplifies database operations for both Microsoft SQL Server and PostgreSQL. It provides SqlExecuter classes for each provider, extension methods on DbConnection and DbCommand, a repository pattern implementation backed by stored procedures, and a SqlJsonObject helper for JSON-based data access.

Installation

dotnet add package FonsecaFramework.Sql

Features

Examples

Execute a Query with SQL Server

using FonsecaFramework.Sql.Microsoft;

var executer = new SqlExecuter("Server=myserver;Database=mydb;Trusted_Connection=True;");

// Or with explicit credentials
var executer2 = new SqlExecuter("myserver", "mydb", "user", "password");

Execute a Query with PostgreSQL

using FonsecaFramework.Sql.Postgres;

var executer = new SqlExecuter("Host=localhost;Database=mydb;Username=user;Password=pass;");

Using the Generic SqlExecuter

using FonsecaFramework.Sql;
using Microsoft.Data.SqlClient;

var executer = new SqlExecuter(() => new SqlConnection("Server=myserver;Database=mydb;Trusted_Connection=True;"));

var command = new SqlCommand("INSERT INTO Products (Name, Price) VALUES (@Name, @Price)");
command.Parameters.AddWithValue("@Name", "Widget");
command.Parameters.AddWithValue("@Price", 19.99);

await executer.ExecuteNonQueryAsync(command);

DbCommand Extensions — Query to JSON

using FonsecaFramework.Sql;
using Microsoft.Data.SqlClient;

using var connection = new SqlConnection("Server=myserver;Database=mydb;Trusted_Connection=True;");
var command = new SqlCommand("SELECT * FROM Products FOR JSON PATH");

List<Product> products = await command.ExecuteSqlToJsonAsync<List<Product>>(connection);

DbCommand Extensions — Query to DataTable

using FonsecaFramework.Sql;
using Microsoft.Data.SqlClient;

using var connection = new SqlConnection("Server=myserver;Database=mydb;Trusted_Connection=True;");
var command = new SqlCommand("SELECT * FROM Products");

DataTable table = await command.ExecuteSqlAsync(connection);
foreach (DataRow row in table.Rows)
    Console.WriteLine(row["Name"]);

SqlJsonObject — Map JSON Rows to Entities

using FonsecaFramework.Sql.Infastructure;

// When your SQL returns JSON + ID columns:
var jsonObjects = new List<SqlJsonObject>
{
    new SqlJsonObject { ID = 1, Json = "{\"Name\":\"Widget\"}" }
};

List<Product> products = SqlJsonObject.ToList<Product>(jsonObjects);

Requirements

• .NET 9.0
• Microsoft SQL Server and/or PostgreSQL

License

Copyright 2025 Steven Fonseca / VLR Creations

Licensed under the Apache License, Version 2.0. You may use this library free of charge, provided you include the required attribution notices. See the LICENSE file for full terms.