XPO学习日志

 

1.XPO四大基类

创建实体类时有四大基类, 不同基类自动生成的字段不同. 乐观锁可以用来判断数据是否是最新的,  非物理删除可以实现类似作废的功能. 表示字段就是自增ID.

---

 

2.XPO数据过滤  ,此过滤为数据库查询过滤, 服务端过滤

CriteriaOperator派生类

       1.BInaryOperator 两个值进行比较

//Name=John
CriteriaOperator bo1=new BinaryOperator("Name","John");

//Name>=32
CriteriaOperator bo2=new BinaryOperator("Age",32,BinaryOperatorType.GreaterOrEqual);

//bo1&&bo2
CriteriaOperator bo3=new BinaryOperator(bo1,bo2,BinaryOperatorType.BitwiseAnd);
xpCollection2.Criteria=bo1;

 

        2.BetweenOperator  两个值之间的数据

//10 <= Age <=30
CriteriaOperator bo = new BetweenOperator("Age",10,30);
xpCollection2.Criteria=bo;

 

       3.InOperator 包含某集合的类

//Name in {"John","Sam"}
CriteriaOperator io= New InOperator("Name",new string[]{"John","Sam"};
xpCollection2.Criteria=io;

      4.ContainsOperator   当两个实体类是一对多,或者多对多的关系,对多的一端字段或者属性的筛选

//Customer where Customer.Order.Price > 50
CriteriaOperator co= new ContainsOperator("Orders",new BinaryOperator("Price",50,BinaryOperatorType,GreaterOrEqual));
xpCollection2.Criteria=co;

      5.NotOperator    表示相反关系 

//Name in {"John","Sam"}
CriteriaOperator io= new InOperator("Nmae",new string[]{"John","Sam"});

//Name Not in {"John","Sam"}
CriteriaOperator no = new NotOperator(io);
xpCollection2.Criteria=no;

      6.NullOperator   查询某