GPAL Fluent: High-level fluent C# API

//WithTableName is the simplest query option - GPAL generates 'SELECT TOP n * FROM tableName'. Use WithSQLCommand or WithStoredProcedure when you need filtering, joins, or custom column selection.

// the grid is declared, because out var cannot choose between the SaveTo overloads

IGPALGrid<string> products;

IGPALGrid<string> customers;

IGPALGrid<string> orders;

// Query via SQL command

GPAL.Database

.WithConnectionString(connStr)

.WithSQLCommand("SELECT TOP 100 * FROM Products ORDER BY Name")

.ToGPALObject()

.Read

.SaveTo(out products);

// Query via table name (auto-generates SELECT)

GPAL.Database

.WithConnectionString(connStr)

.WithTableName("Customers")

.WithRowCount(500)

.ToGPALObject()

.Read

.SaveTo(out customers);

// Call a stored procedure

GPAL.Database

.WithConnectionString(connStr)

.WithStoredProcedure("usp_GetActiveOrders")

.ToGPALObject()

.Read

.SaveTo(out orders);