Ecosyste.ms: Packages
An open API service providing package, version and dependency metadata of many open source software ecosystems and registries.
nuget.org : wildfire
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();
Registry
- Homepage
- JSON
purl: pkg:nuget/wildfire
Keywords: Dynamic, Query, SQL, Collections.
License: MIT
Latest release: over 8 years ago
First release: over 8 years ago
Downloads: 19,623 total
Stars: 0 on GitHub
Forks: 2 on GitHub
See more repository details: repos.ecosyste.ms
Last synced: 1 day ago