如何编写与以下SQL等效的微风谓词 [英] How do I write a breeze Predicate equivalent to the following SQL

问题描述

SELECT 
    * 
FROM
    Table
WHERE 
  FirstName = 'Wilson' 
  AND (START_DATE = '1/1/2014' OR START_DATE > '1/2/2014')

推荐答案

假定您具有控制器，并且具有：

Assume you have controller and it has:

     [HttpGet]
     public IQueryable<Tables> GetTables()
     {
         return _contextProvider.Context.Set<Tables>();
     }

创建谓词：

var p1 = new breeze.Predicate.create("FirstName ", "==", "Wilson");
var p2 = new breeze.Predicate.create("START_DATE ", "==", "1/1/2014");
var p3 = new breeze.Predicate.create("START_DATE ", ">", "1/1/2014");
var orPred = new breeze.Predicate.or(p2, p3);
var andPred = Predicate.and(p1, orPred );
// You should parse "1/1/2014" to DateTime type first

The查询将是：

var query= new breeze.EntityQuery().from("GetTables").where(andPred);

这篇关于如何编写与以下SQL等效的微风谓词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！