WildFire 1.0.0
See the version list below for details.
dotnet add package WildFire --version 1.0.0
NuGet\Install-Package WildFire -Version 1.0.0
<PackageReference Include="WildFire" Version="1.0.0" />
paket add WildFire --version 1.0.0
#r "nuget: WildFire, 1.0.0"
// Install WildFire as a Cake Addin
#addin nuget:?package=WildFire&version=1.0.0
// Install WildFire as a Cake Tool
#tool nuget:?package=WildFire&version=1.0.0
A .Net Library for reusable code for data access from database , collections, and other utility classes.
var queryBuilder = new QueryBuilder();
//Add table from there you want to select.
var table = new FromTable("Table1", "t1");
// Perform a join
table.JoinOn("Table2", "t2", "Column1", "Column2", JoinType.Inner);
//add table
queryBuilder.AddFromTable(table.TableString);
//Create Where clauses using predicates query builder provides you methods to add predicate
//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.
//add predicate and specify the operation type supports and or and not
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);
queryBuilder.AddPredicate(dateExpressions2, OperationType.Or);
queryBuilder.GenerateQuery();
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net45 is compatible. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
This package has no dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.