Skip to content

Instantly share code, notes, and snippets.

@FransBouma
Created September 10, 2015 10:32
Show Gist options
  • Save FransBouma/1fad1700cb6d7b50e4c8 to your computer and use it in GitHub Desktop.
Save FransBouma/1fad1700cb6d7b50e4c8 to your computer and use it in GitHub Desktop.
Auto-generated Linq queries from derived model definition on entity model.
//------------------------------------------------------------------------------
// <auto-generated>This code was generated by LLBLGen Pro v5.0.</auto-generated>
//------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Dtos.DtoClasses;
using Northwind.Adapter.Linq;
using SD.LLBLGen.Pro.ORMSupportClasses;
namespace Dtos.Queries
{
/// <summary>Static class which contains methods for fetching instances of Dtos.DtoClasses.OrderCustomerMtoM</summary>
public static partial class OrderCustomerMtoMQueries
{
/// <summary>Fetches all instances of Dtos.DtoClasses.OrderCustomerMtoM, using the IDataAccessAdapter instance specified.</summary>
/// <param name="adapter">The IDataAccessAdapter instance to use</param>
/// <returns>IQueryable containing Dtos.DtoClasses.OrderCustomerMtoM instances</returns>
public static IQueryable<Dtos.DtoClasses.OrderCustomerMtoM> FetchAll(IDataAccessAdapter adapter)
{
return Fetch(adapter, null);
}
/// <summary>Fetches all instances of Dtos.DtoClasses.OrderCustomerMtoM which match the where clause specified, using the IDataAccessAdapter instance specified.</summary>
/// <param name="adapter">The IDataAccessAdapter instance to use</param>
/// <param name="baseQueryWhereClause">The where clause expression to apply to the base query on the entity model. Can be null.</param>
/// <returns>IQueryable containing Dtos.DtoClasses.OrderCustomerMtoM instances</returns>
public static IQueryable<Dtos.DtoClasses.OrderCustomerMtoM> Fetch(IDataAccessAdapter adapter, System.Linq.Expressions.Expression<Func<Northwind.Adapter.EntityClasses.OrderEntity, bool>> baseQueryWhereClause)
{
var metaData = new LinqMetaData(adapter);
IQueryable<Northwind.Adapter.EntityClasses.OrderEntity> q = metaData.Order;
if(baseQueryWhereClause != null)
{
q = q.Where(baseQueryWhereClause);
}
return Fetch(q);
}
/// <summary>Fetches all instances of Dtos.DtoClasses.OrderCustomerMtoM projected from the results of the specified baseQuery</summary>
/// <returns>IQueryable containing Dtos.DtoClasses.OrderCustomerMtoM instances</returns>
public static IQueryable<Dtos.DtoClasses.OrderCustomerMtoM> Fetch(IQueryable<Northwind.Adapter.EntityClasses.OrderEntity> baseQuery)
{
return baseQuery.Select(p__0 => new Dtos.DtoClasses.OrderCustomerMtoM()
{
Customer = new Dtos.DtoClasses.OrderCustomerMtoMTypes.Customer()
{
CompanyName = p__0.Customer.CompanyName,
Employees = p__0.Customer.Employees.Select(p__1 => new Dtos.DtoClasses.OrderCustomerMtoMTypes.CustomerTypes.Employee()
{
FirstName = p__1.FirstName,
LastName = p__1.LastName,
}).ToList(),
},
OrderDate = p__0.OrderDate,
OrderId = p__0.OrderId,
});
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment