void ILoadDataService.BuildDataDemo()
{
//string adwCnxString = @"Data Source=NICOW8\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";
//IDataManager dmSQL = EntityManager.FromConnectionString(adwCnxString, DBMS.SQLServer2005);
//IEntityManager emSql = dmSQL as IEntityManager;
//dmSQL.LoadAssociated<SalesReason, SalesOrderHeaderSalesReason>();
//foreach (SalesReason salesReason in emSql.GetAllInstances<SalesReason>())
//{
// //salesReason.data.SetAdded();
// foreach (SalesOrderHeaderSalesReason sohsr in salesReason.GetRelationsInstances<SalesOrderHeader, SalesOrderHeaderSalesReason>())
// {
// sohsr.data.SetAdded();
// }
//}
//IDataManager dm = EntityManager.FromDataSetAndBaseService(emSql.Data, ServiceName.ADWDB);
//dm.SaveTransactional();
IDataManager dm = EntityManager.FromDataBaseService(ServiceName.ADWDB);
var relations = new List <IRoleRelationQuery>();
relations.Add(new RoleRelationQuery <Category, CategorySubcategory>());
relations.Add(new RoleRelationQuery <Subcategory, ProductSubcategory>());
relations.Add(new RoleRelationQuery <Product, ProductProductPhoto>());
dm.LoadEntitiesGraph <Category>(relations);
relations = new List <IRoleRelationQuery>();
relations.Add(new RoleRelationQuery <Employee, EmployeeManager>());
relations.Add(new RoleRelationQuery <Employee, EmployeeContact>());
dm.LoadEntitiesGraph <Employee>(relations);
relations = new List <IRoleRelationQuery>();
relations.Add(new RoleRelationQuery <SalesPerson, ContactSalesPerson>());
//relations.Add(new RoleRelationQuery<SalesPerson, SalesOrderHeaderSalesPerson>());
//relations.Add(new RoleRelationQuery<SalesOrderHeader, SalesOrderHeaderSalesReason>());
dm.LoadEntitiesGraphFields <SalesPerson>(EntityLoadOption.AllFields, relations);
dm.LoadEntities <Department>();
IFileService fs = ExecutingContext.GetService <IFileService>(ServiceName.ADWFileService);
var data = DataSetHelper.BinarySave(dm.Data);
fs.Write("DataDemo2", data);
}
