WildFire 1.0.11

var queryBuilder = new QueryBuilder();
   var t0 = new Table()
           {
               TableName = "Table0",
               TableAlias = "t0"
           };       
var t1 = new Table()
           {
               TableName = "Table1",
               Column1Name = "Column1",
               Column2Name = "Column2",
               JoinType = JoinType.Inner,
               TableAlias = "t2"
           };
////Create table from first table
           //var tables = new List<Table>();
           //tables.Add(t1);
           //// Perform a join
           //t0.JoinOn(tables);
           queryBuilder.AddTable(t0);
           ////there are two ways you can add predicate  either by string or predicate object
           var textMatchExpression = new Predicate("t1.[Column3] like 'Joe'");
           ////AddPredicate also takes just string if you have only one where condition.
           queryBuilder.AddPredicate(textMatchExpression, OperationType.And);
           var datesExpressions1 = new List<string>();
           datesExpressions1.Add("f.[Column5] >= '2015-09-01'");
           datesExpressions1.Add("f.[Column6] <= '2015-12-31'");
           var dateExpressions2 = new List<string>();
           dateExpressions2.Add("f.[Column7] >= '2015-10-01'");
           dateExpressions2.Add("f.[Column8] >= '2015-12-31'");
           //add groups of predicates
           queryBuilder.AddPredicate(datesExpressions1, OperationType.And, OperationType.Or);
           queryBuilder.AddPredicate(dateExpressions2, OperationType.And, OperationType.Empty);
           //Order by
           queryBuilder.Query.OrderBy("Column1", true);
           //Fetch overloaded with offset and number of rows.
           queryBuilder.Query.FetchNext("2","20");
           queryBuilder.GenerateQuery();

Install-Package WildFire -Version 1.0.11
dotnet add package WildFire --version 1.0.11
<PackageReference Include="WildFire" Version="1.0.11" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add WildFire --version 1.0.11
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

1.0.2 Updated logic for groups and subgroups in predicates.
1.0.3 Added support for order by and Fetch Next also now queryBuilder.Query object gives query string.(Breaking change)
1.0.4 Multiple tables will not have repeated table names.
1.0.5 Breaking change :- Fixed a major bug now you dont have to addfrom table anymore you could just add tables in the list and join on any one table also table is a object.
1.0.6 Updated description.
1.0.7 Updated dlls.
1.0.8 Fixed bug of not selecting the columns and not getting comma.
Now Order by is enum ASC DESC
Fixed bug ZERO predicates was throwing null reference exception.
1.0.9 Bug fixed code is unreachable.
1.0.10 Fixed the spacing predicates and and removing the last predicate if you are passing list of predicates or may predicates.
1.0.11

Dependencies

This package has no dependencies.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.11 464 9/22/2015
1.0.10 313 9/22/2015
1.0.9 323 9/22/2015
1.0.8 329 9/22/2015
1.0.7 320 9/22/2015
1.0.6 325 9/21/2015
1.0.5 326 9/21/2015
1.0.4 329 9/21/2015
1.0.3 349 9/18/2015
1.0.2 319 9/18/2015
1.0.1 317 9/17/2015
1.0.0 318 9/17/2015