ISqlQuery queryBuilder = SQLBuilderFactory.GetBuilder(); queryBuilder.Select("column1", "column2") .From("table1") .Where("column3 = @param") .OrderBy("column1") .Limit(10); // Execute the query var result = queryBuilder.Execute(new { param = "value" }); // Display the result foreach (var row in result) { Console.WriteLine($"{row.column1} {row.column2}"); }
var builder = SQLBuilderFactory.GetBuilder(); // Build a complex query using subqueries var subquery1 = builder.Select("column1").From("table1").Where("column2 = @param1"); var subquery2 = builder.Select("column3").From("table2").Where("column4 = @param2"); var query = builder.Select("*") .From(subquery1, "t1").Join(subquery2, "t2").On("t1.column1 = t2.column3") .Where("t1.column5 = @param3").OrderBy("t2.column3"); // Execute the query var result = query.Execute(new { param1 = "value1", param2 = "value2", param3 = "value3" }); // Display the result foreach (var row in result) { Console.WriteLine($"{row.column1} {row.column3}"); }In this example, we create a new instance of the SQL query builder and use it to build a complex query that involves subqueries, joins, and sorting. We then execute the query using multiple parameter values, and display the results. The package library for ISqlQuery GetBuilder varies depending on the specific implementation being used. However, commonly used libraries for SQL query building in C# include Dapper and Entity Framework.