1. 自定义非受管实体类
namespace IOT{public class CustomerProjection{
public int ID = 0;
public string Name = "";
public CustomerProjection(int id, string name){ID = id;
Name = name;
}}
}
2. 在实体类属性添加对自定义非受管实体类的引入
[Imprt(typeof(IOT.CustomerProjection), "CustomerProjection")][ActiveRecord("Customers")]
public class Customer : ActiveRecordBase<Customer>
{
[PrimaryKey(PrimaryKeyType.Assigned)]
public string CustomerID
{
get { return customerID; }
set { customerID = value; }
}
.....
}
3. 在代码中用检索字段生成自定义非受管实体类
protected void Page Load(object sender, EventArgs e){
IActiveRecordQuery query = new HqlBasedQuery(typeof (Customer),
@"select new CustomerProjection(c.CustomerID, c.CompanyName)
from Customer c join c.Orders o where c.Country = 'USA'
group by c.CustomerID, c.CompanyName, c.City, c.Region
");GridView1.DataSource = ActiveRecordMediator.ExecuteQuery(query);
GridView1.DataBind();
}
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。