SELECT with selective columns

SQL Server Query

            
SELECT CustomerID, CompanyName, ContactName AS Name, ContactTitle AS Tile  

FROM Customers; 

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

  .Select().Columns("CustomerID","CompanyName")  

  .Column("ContactName", "Name")  

  .Column("ContactTitle", "Title")  

  .From("Customers")  

.Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT CustomerID,
       CompanyName,
       ContactName AS Name,
       ContactTitle AS Title
FROM Customers;


            
        

Parameters (If used)

Query Results: