/// <summary>Extension method which produces a projection to NWService.Dtos.DtoClasses.Order which instances are projected from the
/// results of the specified baseQuery using QuerySpec, which returns NWService.Dal.EntityClasses.OrderEntity instances, the root entity of the derived element returned by this query.</summary>
/// <param name="baseQuery">The base query to project the derived element instances from.</param>
/// <param name="qf">The query factory used to create baseQuery.</param>
/// <returns>DynamicQuery to retrieve NWService.Dtos.DtoClasses.Order instances</returns>
public static DynamicQuery <NWService.Dtos.DtoClasses.Order> ProjectToOrder(this EntityQuery <NWService.Dal.EntityClasses.OrderEntity> baseQuery, NWService.Dal.FactoryClasses.QueryFactory qf)
{
return(qf.Create()
.From(baseQuery.Select(Projection.Full).As("__BQ"))
.Select(() => new NWService.Dtos.DtoClasses.Order()
{
CustomerId = OrderFields.CustomerId.Source("__BQ").ToValue <System.String>(),
EmployeeId = OrderFields.EmployeeId.Source("__BQ").ToValue <Nullable <System.Int32> >(),
Freight = OrderFields.Freight.Source("__BQ").ToValue <Nullable <System.Decimal> >(),
OrderDate = OrderFields.OrderDate.Source("__BQ").ToValue <Nullable <System.DateTime> >(),
OrderDetails = (List <NWService.Dtos.DtoClasses.OrderTypes.OrderDetail>)qf.OrderDetail.TargetAs("__L1_0")
.CorrelatedOver(OrderFields.OrderId.Source("__BQ").Equal(OrderDetailFields.OrderId.Source("__L1_0")))
.Select(() => new NWService.Dtos.DtoClasses.OrderTypes.OrderDetail()
{
Discount = OrderDetailFields.Discount.Source("__L1_0").ToValue <System.Single>(),
ProductId = OrderDetailFields.ProductId.Source("__L1_0").ToValue <System.Int32>(),
Quantity = OrderDetailFields.Quantity.Source("__L1_0").ToValue <System.Int16>(),
UnitPrice = OrderDetailFields.UnitPrice.Source("__L1_0").ToValue <System.Decimal>(),
}).ToResultset(),
OrderId = OrderFields.OrderId.Source("__BQ").ToValue <System.Int32>(),
RequiredDate = OrderFields.RequiredDate.Source("__BQ").ToValue <Nullable <System.DateTime> >(),
ShipAddress = OrderFields.ShipAddress.Source("__BQ").ToValue <System.String>(),
ShipCity = OrderFields.ShipCity.Source("__BQ").ToValue <System.String>(),
ShipCountry = OrderFields.ShipCountry.Source("__BQ").ToValue <System.String>(),
ShipName = OrderFields.ShipName.Source("__BQ").ToValue <System.String>(),
ShippedDate = OrderFields.ShippedDate.Source("__BQ").ToValue <Nullable <System.DateTime> >(),
ShipPostalCode = OrderFields.ShipPostalCode.Source("__BQ").ToValue <System.String>(),
ShipRegion = OrderFields.ShipRegion.Source("__BQ").ToValue <System.String>(),
ShipVia = OrderFields.ShipVia.Source("__BQ").ToValue <Nullable <System.Int32> >(),
// __LLBLGENPRO_USER_CODE_REGION_START ProjectionRegionQS_Order
// __LLBLGENPRO_USER_CODE_REGION_END
}));
}
/// <summary>Extension method which produces a projection to NWService.Dtos.DtoClasses.OrderDetail which instances are projected from the
/// results of the specified baseQuery using QuerySpec, which returns NWService.Dal.EntityClasses.OrderDetailEntity instances, the root entity of the derived element returned by this query.</summary>
/// <param name="baseQuery">The base query to project the derived element instances from.</param>
/// <param name="qf">The query factory used to create baseQuery.</param>
/// <returns>DynamicQuery to retrieve NWService.Dtos.DtoClasses.OrderDetail instances</returns>
public static DynamicQuery <NWService.Dtos.DtoClasses.OrderDetail> ProjectToOrderDetail(this EntityQuery <NWService.Dal.EntityClasses.OrderDetailEntity> baseQuery, NWService.Dal.FactoryClasses.QueryFactory qf)
{
System.Linq.Expressions.Expression <Func <NWService.Dtos.DtoClasses.OrderDetail> > projectionAdjustments = null;
GetAdjustmentsForProjectToOrderDetailQs(ref projectionAdjustments);
return(qf.Create()
.From(baseQuery.Select(Projection.Full).As("__BQ"))
.Select(LinqUtils.MergeProjectionAdjustmentsIntoProjection(() => new NWService.Dtos.DtoClasses.OrderDetail()
{
Discount = OrderDetailFields.Discount.Source("__BQ").ToValue <System.Single>(),
OrderId = OrderDetailFields.OrderId.Source("__BQ").ToValue <System.Int32>(),
ProductId = OrderDetailFields.ProductId.Source("__BQ").ToValue <System.Int32>(),
Quantity = OrderDetailFields.Quantity.Source("__BQ").ToValue <System.Int16>(),
UnitPrice = OrderDetailFields.UnitPrice.Source("__BQ").ToValue <System.Decimal>(),
// __LLBLGENPRO_USER_CODE_REGION_START ProjectionRegionQS_OrderDetail
// __LLBLGENPRO_USER_CODE_REGION_END
}, projectionAdjustments, false)));
}
/// <summary>Extension method which produces a projection to NWService.Dtos.DtoClasses.OrderDetail which instances are projected from the
/// results of the specified baseQuery using QuerySpec, which returns NWService.Dal.EntityClasses.OrderDetailEntity instances, the root entity of the derived element returned by this query.</summary>
/// <param name="baseQuery">The base query to project the derived element instances from.</param>
/// <param name="qf">The query factory used to create baseQuery.</param>
/// <returns>DynamicQuery to retrieve NWService.Dtos.DtoClasses.OrderDetail instances</returns>
public static DynamicQuery <NWService.Dtos.DtoClasses.OrderDetail> ProjectToOrderDetail(this EntityQuery <NWService.Dal.EntityClasses.OrderDetailEntity> baseQuery, NWService.Dal.FactoryClasses.QueryFactory qf)
{
return(qf.Create()
.From(baseQuery.Select(Projection.Full).As("__BQ"))
.Select(() => new NWService.Dtos.DtoClasses.OrderDetail()
{
Discount = OrderDetailFields.Discount.Source("__BQ").ToValue <System.Single>(),
OrderId = OrderDetailFields.OrderId.Source("__BQ").ToValue <System.Int32>(),
ProductId = OrderDetailFields.ProductId.Source("__BQ").ToValue <System.Int32>(),
Quantity = OrderDetailFields.Quantity.Source("__BQ").ToValue <System.Int16>(),
UnitPrice = OrderDetailFields.UnitPrice.Source("__BQ").ToValue <System.Decimal>(),
// __LLBLGENPRO_USER_CODE_REGION_START ProjectionRegionQS_OrderDetail
// __LLBLGENPRO_USER_CODE_REGION_END
}));
}
/// <summary>Extension method which produces a projection to NWService.Dtos.DtoClasses.Customer which instances are projected from the
/// results of the specified baseQuery using QuerySpec, which returns NWService.Dal.EntityClasses.CustomerEntity instances, the root entity of the derived element returned by this query.</summary>
/// <param name="baseQuery">The base query to project the derived element instances from.</param>
/// <param name="qf">The query factory used to create baseQuery.</param>
/// <returns>DynamicQuery to retrieve NWService.Dtos.DtoClasses.Customer instances</returns>
public static DynamicQuery <NWService.Dtos.DtoClasses.Customer> ProjectToCustomer(this EntityQuery <NWService.Dal.EntityClasses.CustomerEntity> baseQuery, NWService.Dal.FactoryClasses.QueryFactory qf)
{
return(qf.Create()
.From(baseQuery.Select(Projection.Full).As("__BQ"))
.Select(() => new NWService.Dtos.DtoClasses.Customer()
{
Address = CustomerFields.Address.Source("__BQ").ToValue <System.String>(),
City = CustomerFields.City.Source("__BQ").ToValue <System.String>(),
CompanyName = CustomerFields.CompanyName.Source("__BQ").ToValue <System.String>(),
ContactName = CustomerFields.ContactName.Source("__BQ").ToValue <System.String>(),
ContactTitle = CustomerFields.ContactTitle.Source("__BQ").ToValue <System.String>(),
Country = CustomerFields.Country.Source("__BQ").ToValue <System.String>(),
CustomerId = CustomerFields.CustomerId.Source("__BQ").ToValue <System.String>(),
Fax = CustomerFields.Fax.Source("__BQ").ToValue <System.String>(),
Phone = CustomerFields.Phone.Source("__BQ").ToValue <System.String>(),
PostalCode = CustomerFields.PostalCode.Source("__BQ").ToValue <System.String>(),
Region = CustomerFields.Region.Source("__BQ").ToValue <System.String>(),
// __LLBLGENPRO_USER_CODE_REGION_START ProjectionRegionQS_Customer
// __LLBLGENPRO_USER_CODE_REGION_END
}));
}
/// <summary>Extension method which produces a projection to NWService.Dtos.DtoClasses.Customer which instances are projected from the
/// results of the specified baseQuery using QuerySpec, which returns NWService.Dal.EntityClasses.CustomerEntity instances, the root entity of the derived element returned by this query.</summary>
/// <param name="baseQuery">The base query to project the derived element instances from.</param>
/// <param name="qf">The query factory used to create baseQuery.</param>
/// <returns>DynamicQuery to retrieve NWService.Dtos.DtoClasses.Customer instances</returns>
public static DynamicQuery <NWService.Dtos.DtoClasses.Customer> ProjectToCustomer(this EntityQuery <NWService.Dal.EntityClasses.CustomerEntity> baseQuery, NWService.Dal.FactoryClasses.QueryFactory qf)
{
System.Linq.Expressions.Expression <Func <NWService.Dtos.DtoClasses.Customer> > projectionAdjustments = null;
GetAdjustmentsForProjectToCustomerQs(ref projectionAdjustments);
return(qf.Create()
.From(baseQuery.Select(Projection.Full).As("__BQ"))
.Select(LinqUtils.MergeProjectionAdjustmentsIntoProjection(() => new NWService.Dtos.DtoClasses.Customer()
{
Address = CustomerFields.Address.Source("__BQ").ToValue <System.String>(),
City = CustomerFields.City.Source("__BQ").ToValue <System.String>(),
CompanyName = CustomerFields.CompanyName.Source("__BQ").ToValue <System.String>(),
ContactName = CustomerFields.ContactName.Source("__BQ").ToValue <System.String>(),
ContactTitle = CustomerFields.ContactTitle.Source("__BQ").ToValue <System.String>(),
Country = CustomerFields.Country.Source("__BQ").ToValue <System.String>(),
CustomerId = CustomerFields.CustomerId.Source("__BQ").ToValue <System.String>(),
Fax = CustomerFields.Fax.Source("__BQ").ToValue <System.String>(),
Phone = CustomerFields.Phone.Source("__BQ").ToValue <System.String>(),
PostalCode = CustomerFields.PostalCode.Source("__BQ").ToValue <System.String>(),
Region = CustomerFields.Region.Source("__BQ").ToValue <System.String>(),
// __LLBLGENPRO_USER_CODE_REGION_START ProjectionRegionQS_Customer
// __LLBLGENPRO_USER_CODE_REGION_END
}, projectionAdjustments, false)));
}
