SELECT Top columns

SQL Server Query

            
SELECT TOP (20) EmployeeID, LastName, FirstName, Title, TitleOfCourtesy, BirthDate,  

HireDate, Address, City, Region, PostalCode, Country, HomePhone,  

Extension, Photo, Notes, ReportsTo, PhotoPath FROM Employees; 

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

  .Select().Top(20)  

  .Columns("EmployeeID","LastName","FirstName","Title","TitleOfCourtesy","BirthDate")  

  .Columns("HireDate","Address","City","Region","PostalCode","Country","HomePhone")  

  .Columns("Extension","Photo","Notes","ReportsTo","PhotoPath")  

  .From("Employees")  

.Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT TOP 20 EmployeeID,
              LastName,
              FirstName,
              Title,
              TitleOfCourtesy,
              BirthDate,
              HireDate,
              Address,
              City,
              Region,
              PostalCode,
              Country,
              HomePhone,
              Extension,
              Photo,
              Notes,
              ReportsTo,
              PhotoPath
FROM Employees;


            
        

Parameters (If used)

Query Results: