|
SQL Artisan多表查询和统计(5) /// </summary>
[TableMap("",TableType.View)]
public class ProductsView:Products,HFSoft.Data.ITableView
{
#region ITableView 成员
public virtual Table GetTable()
{
return DBMapping.Products.INNER(DBMapping.Categories, DBMapping.Categories.CategoryID)
& DBMapping.Products.INNER(DBMapping.Suppliers, DBMapping.Suppliers.SupplierID);
}
#endregion
private string mCategoryName;
[ViewColumn("CategoryName")]
public string CategoryName
{
get
{
return mCategoryName;
}
set
{
mCategoryName = value;
}
}
private string mCompanyName;
| 
