/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildLog> _GetQueryOfEntityOfByFKOnly(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildLog
join Build_B1_1 in this.LinqContext.Build on t.BuildId equals Build_B1_1.Id
join Solution_S1_1 in this.LinqContext.Solution on Build_B1_1.SolutionId equals Solution_S1_1.Id
join BuildEventCode_B2_1 in this.LinqContext.BuildEventCode on t.BuildEventCodeId equals BuildEventCode_B2_1.Id
where
(
(
(criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && Build_B1_1.Id == criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
&&
(criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && Solution_S1_1.Id == criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
&&
(criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && BuildEventCode_B2_1.Id == criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
)
)
select new MSBuildLogsExtended.DataSourceEntities.BuildLog { Id = t.Id, BuildId = t.BuildId, BuildEventCodeId = t.BuildEventCodeId, Message = t.Message, EventTime = t.EventTime } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildLog> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Framework.NameValuePair> _GetQueryOfNameValuePairOfAll(
Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildLog
join Build_B1_1 in this.LinqContext.Build on t.BuildId equals Build_B1_1.Id
join Solution_S1_1 in this.LinqContext.Solution on Build_B1_1.SolutionId equals Solution_S1_1.Id
join BuildEventCode_B2_1 in this.LinqContext.BuildEventCode on t.BuildEventCodeId equals BuildEventCode_B2_1.Id
let _Value = t.Id.ToString()
select new Framework.NameValuePair { Name = t.Message, Value = _Value } into vD0
select vD0
);
var _retval = _ResultFromDataSource;
IQueryable<Framework.NameValuePair> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Framework.RssItem> _GetQueryOfRssItemOfAll(
Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildLog
join Build_B1_1 in this.LinqContext.Build on t.BuildId equals Build_B1_1.Id
join Solution_S1_1 in this.LinqContext.Solution on Build_B1_1.SolutionId equals Solution_S1_1.Id
join BuildEventCode_B2_1 in this.LinqContext.BuildEventCode on t.BuildEventCodeId equals BuildEventCode_B2_1.Id
let _IdentifierInString = t.Id.ToString()
select new Framework.RssItem { Title = t.Message, Description = t.Message, PubDate = t.EventTime, IdentifierInString = _IdentifierInString } into vD1
select vD1
);
var _retval = _ResultFromDataSource;
IQueryable<Framework.RssItem> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.Solution> _GetQueryOfEntityOfAll(
Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Solution
select new MSBuildLogsExtended.DataSourceEntities.Solution { Id = t.Id, ExternalParentId = t.ExternalParentId, Name = t.Name, Description = t.Description } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<MSBuildLogsExtended.DataSourceEntities.Solution> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildLog> _GetQueryOfEntityOfAll(
Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildLog
join Build_B1_1 in this.LinqContext.Build on t.BuildId equals Build_B1_1.Id
join Solution_S1_1 in this.LinqContext.Solution on Build_B1_1.SolutionId equals Solution_S1_1.Id
join BuildEventCode_B2_1 in this.LinqContext.BuildEventCode on t.BuildEventCodeId equals BuildEventCode_B2_1.Id
select new MSBuildLogsExtended.DataSourceEntities.BuildLog { Id = t.Id, BuildId = t.BuildId, BuildEventCodeId = t.BuildEventCodeId, Message = t.Message, EventTime = t.EventTime } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildLog> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildLog.KeyInformation> _GetQueryOfKeyInformationOfByIdentifier(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildLog
join Build_B1_1 in this.LinqContext.Build on t.BuildId equals Build_B1_1.Id
join Solution_S1_1 in this.LinqContext.Solution on Build_B1_1.SolutionId equals Solution_S1_1.Id
join BuildEventCode_B2_1 in this.LinqContext.BuildEventCode on t.BuildEventCodeId equals BuildEventCode_B2_1.Id
where
(
(
(criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare == false || criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare && t.Id == criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.ValueToCompare)
)
)
select new MSBuildLogsExtended.DataSourceEntities.BuildLog.KeyInformation { Id = t.Id } into vD4
select vD4
);
var _retval = _ResultFromDataSource;
IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildLog.KeyInformation> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Log4Net.DataSourceEntities.Log> _GetQueryOfEntityOfByIdentifier(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Log
where
(
(
(criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare == false || criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare && t.Id == criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.ValueToCompare)
)
)
select new Log4Net.DataSourceEntities.Log { Id = t.Id, Date = t.Date, Thread = t.Thread, Level = t.Level, Logger = t.Logger, Message = t.Message, Exception = t.Exception } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<Log4Net.DataSourceEntities.Log> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.Build.Default> _GetQueryOfDefaultOfByIdentifier(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Build
join Solution_S1_1 in this.LinqContext.Solution on t.SolutionId equals Solution_S1_1.Id
where
(
(
(criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare == false || criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare && t.Id == criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.ValueToCompare)
)
)
select new MSBuildLogsExtended.DataSourceEntities.Build.Default { Id = t.Id, SolutionId = t.SolutionId, Name = t.Name, Description = t.Description, BuildStartTime = t.BuildStartTime, Solution_S1_1_Name = Solution_S1_1.Name } into vD2
select vD2
);
var _retval = _ResultFromDataSource;
IQueryable<MSBuildLogsExtended.DataSourceEntities.Build.Default> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Framework.NameValuePair> _GetQueryOfNameValuePairOfAll(
Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Solution
let _Value = t.Id.ToString()
select new Framework.NameValuePair { Name = t.Name, Value = _Value } into vD0
select vD0
);
var _retval = _ResultFromDataSource;
IQueryable<Framework.NameValuePair> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Framework.NameValuePair> _GetQueryOfNameValuePairOfByFKOnly(
Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Build
join Solution_S1_1 in this.LinqContext.Solution on t.SolutionId equals Solution_S1_1.Id
where
(
(
(criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && Solution_S1_1.Id == criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
)
)
let _Value = t.Id.ToString()
select new Framework.NameValuePair { Name = t.Name, Value = _Value } into vD0
select vD0
);
var _retval = _ResultFromDataSource;
IQueryable<Framework.NameValuePair> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.Build> _GetQueryOfEntityOfCommon(
Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfNameOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfDescriptionOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemDateTimeRangeCriteria criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Build
join Solution_S1_1 in this.LinqContext.Solution on t.SolutionId equals Solution_S1_1.Id
where
(
(
(criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon.IsToCompare && Solution_S1_1.Id == criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon.ValueToCompare)
&&
(criteriaOfNameOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfNameOftOfCommonOfCommonOfCommon.IsToCompare && t.Name.Contains(criteriaOfNameOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfDescriptionOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfDescriptionOftOfCommonOfCommonOfCommon.IsToCompare && t.Description.Contains(criteriaOfDescriptionOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon.IsToCompare && (criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon.IsToCompareLowerBound == false || criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon.IsToCompareLowerBound && t.BuildStartTime > criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon.LowerBound) && (criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon.IsToCompareUpperBound == false || criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon.IsToCompareUpperBound && t.BuildStartTime <= criteriaOfBuildStartTimeOftOfCommonOfCommonOfCommon.UpperBound))
)
)
select new MSBuildLogsExtended.DataSourceEntities.Build { Id = t.Id, SolutionId = t.SolutionId, Name = t.Name, Description = t.Description, BuildStartTime = t.BuildStartTime } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<MSBuildLogsExtended.DataSourceEntities.Build> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Log4Net.DataSourceEntities.Log> _GetQueryOfEntityOfAll(
Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Log
select new Log4Net.DataSourceEntities.Log { Id = t.Id, Date = t.Date, Thread = t.Thread, Level = t.Level, Logger = t.Logger, Message = t.Message, Exception = t.Exception } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<Log4Net.DataSourceEntities.Log> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Log4Net.DataSourceEntities.Log> _GetQueryOfEntityOfCommon(
Framework.EntityContracts.QuerySystemDateTimeRangeCriteria criteriaOfDateOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfThreadOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfLevelOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfLoggerOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfMessageOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfExceptionOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Log
where
(
(
(criteriaOfDateOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfDateOftOfCommonOfCommonOfCommon.IsToCompare && (criteriaOfDateOftOfCommonOfCommonOfCommon.IsToCompareLowerBound == false || criteriaOfDateOftOfCommonOfCommonOfCommon.IsToCompareLowerBound && t.Date > criteriaOfDateOftOfCommonOfCommonOfCommon.LowerBound) && (criteriaOfDateOftOfCommonOfCommonOfCommon.IsToCompareUpperBound == false || criteriaOfDateOftOfCommonOfCommonOfCommon.IsToCompareUpperBound && t.Date <= criteriaOfDateOftOfCommonOfCommonOfCommon.UpperBound))
&&
(criteriaOfThreadOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfThreadOftOfCommonOfCommonOfCommon.IsToCompare && t.Thread.Contains(criteriaOfThreadOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfLevelOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfLevelOftOfCommonOfCommonOfCommon.IsToCompare && t.Level.Contains(criteriaOfLevelOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfLoggerOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfLoggerOftOfCommonOfCommonOfCommon.IsToCompare && t.Logger.Contains(criteriaOfLoggerOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfMessageOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfMessageOftOfCommonOfCommonOfCommon.IsToCompare && t.Message.Contains(criteriaOfMessageOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfExceptionOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfExceptionOftOfCommonOfCommonOfCommon.IsToCompare && t.Exception.Contains(criteriaOfExceptionOftOfCommonOfCommonOfCommon.ValueToBeContained))
)
)
select new Log4Net.DataSourceEntities.Log { Id = t.Id, Date = t.Date, Thread = t.Thread, Level = t.Level, Logger = t.Logger, Message = t.Message, Exception = t.Exception } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<Log4Net.DataSourceEntities.Log> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Log4Net.DataSourceEntities.Log.KeyInformation> _GetQueryOfKeyInformationOfByIdentifier(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Log
where
(
(
(criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare == false || criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare && t.Id == criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.ValueToCompare)
)
)
select new Log4Net.DataSourceEntities.Log.KeyInformation { Id = t.Id } into vD1
select vD1
);
var _retval = _ResultFromDataSource;
IQueryable<Log4Net.DataSourceEntities.Log.KeyInformation> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Framework.RssItem> _GetQueryOfRssItemOfByFKOnly(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildLog
join Build_B1_1 in this.LinqContext.Build on t.BuildId equals Build_B1_1.Id
join Solution_S1_1 in this.LinqContext.Solution on Build_B1_1.SolutionId equals Solution_S1_1.Id
join BuildEventCode_B2_1 in this.LinqContext.BuildEventCode on t.BuildEventCodeId equals BuildEventCode_B2_1.Id
where
(
(
(criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && Build_B1_1.Id == criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
&&
(criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && Solution_S1_1.Id == criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
&&
(criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && BuildEventCode_B2_1.Id == criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
)
)
let _IdentifierInString = t.Id.ToString()
select new Framework.RssItem { Title = t.Message, Description = t.Message, PubDate = t.EventTime, IdentifierInString = _IdentifierInString } into vD1
select vD1
);
var _retval = _ResultFromDataSource;
IQueryable<Framework.RssItem> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<Framework.RssItem> _GetQueryOfRssItemOfAll(
Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Solution
let _IdentifierInString = t.Id.ToString()
select new Framework.RssItem { Title = t.Name, Description = t.ExternalParentId, IdentifierInString = _IdentifierInString } into vD1
select vD1
);
var _retval = _ResultFromDataSource;
IQueryable<Framework.RssItem> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IEnumerable<MSBuildLogsExtended.DataSourceEntities.BuildLog.DefaultGroupedDataView> _GetQueryOfDefaultGroupedDataViewOfByFKOnly(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildLog
join Build_B1_1 in this.LinqContext.Build on t.BuildId equals Build_B1_1.Id
join Solution_S1_1 in this.LinqContext.Solution on Build_B1_1.SolutionId equals Solution_S1_1.Id
join BuildEventCode_B2_1 in this.LinqContext.BuildEventCode on t.BuildEventCodeId equals BuildEventCode_B2_1.Id
where
(
(
(criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && Build_B1_1.Id == criteriaOfIdOfBuild_B1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
&&
(criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && Solution_S1_1.Id == criteriaOfIdOfSolution_S1_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
&&
(criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare == false || criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.IsToCompare && BuildEventCode_B2_1.Id == criteriaOfIdOfBuildEventCode_B2_1OfByFKOnlyOfByFKOnlyOfByFKOnly.ValueToCompare)
)
)
group t by new { BuildId = t.BuildId, BuildEventCodeId = t.BuildEventCodeId, Solution_S1_1Id = Solution_S1_1.Id, Name = string.Format("{0} - {1} - {2}", Build_B1_1.Name, Solution_S1_1.ExternalParentId, BuildEventCode_B2_1.EventCode) } into tG
let _CountPerFK = tG.Count()
select new MSBuildLogsExtended.DataSourceEntities.BuildLog.DefaultGroupedDataView { BuildId = tG.Key.BuildId, BuildEventCodeId = tG.Key.BuildEventCodeId, Solution_S1_1Id = tG.Key.Solution_S1_1Id, CountPerFK = _CountPerFK, Name = tG.Key.Name } into vD3
select vD3
);
var _retval = _ResultFromDataSource;
IEnumerable<MSBuildLogsExtended.DataSourceEntities.BuildLog.DefaultGroupedDataView> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.Solution> _GetQueryOfEntityOfCommon(
Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfExternalParentIdOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfNameOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfDescriptionOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.Solution
where
(
(
(criteriaOfExternalParentIdOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfExternalParentIdOftOfCommonOfCommonOfCommon.IsToCompare && t.ExternalParentId.Contains(criteriaOfExternalParentIdOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfNameOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfNameOftOfCommonOfCommonOfCommon.IsToCompare && t.Name.Contains(criteriaOfNameOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfDescriptionOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfDescriptionOftOfCommonOfCommonOfCommon.IsToCompare && t.Description.Contains(criteriaOfDescriptionOftOfCommonOfCommonOfCommon.ValueToBeContained))
)
)
select new MSBuildLogsExtended.DataSourceEntities.Solution { Id = t.Id, ExternalParentId = t.ExternalParentId, Name = t.Name, Description = t.Description } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<MSBuildLogsExtended.DataSourceEntities.Solution> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildLog.Default> _GetQueryOfDefaultOfCommon(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOfBuild_B1_1OfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfBuildEventCode_B2_1OfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfMessageOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QuerySystemDateTimeRangeCriteria criteriaOfEventTimeOftOfCommonOfCommonOfCommon
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildLog
join Build_B1_1 in this.LinqContext.Build on t.BuildId equals Build_B1_1.Id
join Solution_S1_1 in this.LinqContext.Solution on Build_B1_1.SolutionId equals Solution_S1_1.Id
join BuildEventCode_B2_1 in this.LinqContext.BuildEventCode on t.BuildEventCodeId equals BuildEventCode_B2_1.Id
where
(
(
(criteriaOfIdOfBuild_B1_1OfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfIdOfBuild_B1_1OfCommonOfCommonOfCommon.IsToCompare && Build_B1_1.Id == criteriaOfIdOfBuild_B1_1OfCommonOfCommonOfCommon.ValueToCompare)
&&
(criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon.IsToCompare && Solution_S1_1.Id == criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon.ValueToCompare)
&&
(criteriaOfIdOfBuildEventCode_B2_1OfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfIdOfBuildEventCode_B2_1OfCommonOfCommonOfCommon.IsToCompare && BuildEventCode_B2_1.Id == criteriaOfIdOfBuildEventCode_B2_1OfCommonOfCommonOfCommon.ValueToCompare)
&&
(criteriaOfMessageOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfMessageOftOfCommonOfCommonOfCommon.IsToCompare && t.Message.Contains(criteriaOfMessageOftOfCommonOfCommonOfCommon.ValueToBeContained))
&&
(criteriaOfEventTimeOftOfCommonOfCommonOfCommon.IsToCompare == false || criteriaOfEventTimeOftOfCommonOfCommonOfCommon.IsToCompare && (criteriaOfEventTimeOftOfCommonOfCommonOfCommon.IsToCompareLowerBound == false || criteriaOfEventTimeOftOfCommonOfCommonOfCommon.IsToCompareLowerBound && t.EventTime > criteriaOfEventTimeOftOfCommonOfCommonOfCommon.LowerBound) && (criteriaOfEventTimeOftOfCommonOfCommonOfCommon.IsToCompareUpperBound == false || criteriaOfEventTimeOftOfCommonOfCommonOfCommon.IsToCompareUpperBound && t.EventTime <= criteriaOfEventTimeOftOfCommonOfCommonOfCommon.UpperBound))
)
)
select new MSBuildLogsExtended.DataSourceEntities.BuildLog.Default { Id = t.Id, BuildId = t.BuildId, BuildEventCodeId = t.BuildEventCodeId, Message = t.Message, EventTime = t.EventTime, Build_B1_1_Name = Build_B1_1.Name, Solution_S1_1_Name = Solution_S1_1.Name, Solution_S1_1Id = Solution_S1_1.Id, BuildEventCode_B2_1_Name = BuildEventCode_B2_1.EventCode } into vD2
select vD2
);
var _retval = _ResultFromDataSource;
IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildLog.Default> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
/// <summary>
/// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/>
/// The key query criteria of this set of query is: Common.
/// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime
/// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria:
/// *internal _GetQueryOfEntityOf...(...) gives the Linq Query
/// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0
/// public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false
/// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null
/// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null
/// </summary>
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param>
/// <returns>IQueryable<...> of Common</returns>
internal IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildEventCode> _GetQueryOfEntityOfByIdentifier(
Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
var _ResultFromDataSource =
(
from t in this.LinqContext.BuildEventCode
where
(
(
(criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare == false || criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.IsToCompare && t.Id == criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier.ValueToCompare)
)
)
select new MSBuildLogsExtended.DataSourceEntities.BuildEventCode { Id = t.Id, EventCode = t.EventCode, Description = t.Description } into x
select x
);
var _retval = _ResultFromDataSource.Distinct();
IQueryable<MSBuildLogsExtended.DataSourceEntities.BuildEventCode> _retval1;
if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0)
{
_retval1 = _retval;
}
else
{
_retval1 = _retval.AsQueryable().OrderBy(queryOrderBySettingCollection.GetOrderByExpression());
}
return _retval1;
}
