/// <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; }