/// <param name="queryOrderBySettingCollection">query OrderBy setting</param> /// <returns>IQueryable<...> of Common</returns> internal IQueryable <Elmah.DataSourceEntities.ELMAH_Error.Default> _GetQueryOfDefaultByIdentifier( Framework.Queries.QuerySystemGuidEqualsCriteria errorId , Framework.Queries.QueryOrderBySettingCollection queryOrderBySettingCollection ) { var _ResultFromDataSource = ( from t in this.LinqContext.ELMAH_Error join ElmahApplication in this.LinqContext.ElmahApplication on t.Application equals ElmahApplication.Application join ElmahHost in this.LinqContext.ElmahHost on t.Host equals ElmahHost.Host join ElmahSource in this.LinqContext.ElmahSource on t.Source equals ElmahSource.Source join ElmahStatusCode in this.LinqContext.ElmahStatusCode on t.StatusCode equals ElmahStatusCode.StatusCode join ElmahType in this.LinqContext.ElmahType on t.Type equals ElmahType.Type join ElmahUser in this.LinqContext.ElmahUser on t.User equals ElmahUser.User where ( ( (errorId.IsToCompare == false || errorId.IsToCompare && t.ErrorId == errorId.ValueToCompare) ) ) select new Elmah.DataSourceEntities.ELMAH_Error.Default { ElmahApplication_Name = ElmahApplication.Application, ErrorId = t.ErrorId, ElmahHost_Name = ElmahHost.Host, ElmahSource_Name = ElmahSource.Source, ElmahStatusCode_Name = ElmahStatusCode.Name, ElmahType_Name = ElmahType.Type, ElmahUser_Name = ElmahUser.User, Application = t.Application, Host = t.Host, Type = t.Type, Source = t.Source, Message = t.Message, User = t.User, StatusCode = t.StatusCode, TimeUtc = t.TimeUtc, Sequence = t.Sequence, AllXml = t.AllXml } into vD2 select vD2 ); var _retval = _ResultFromDataSource; if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0) { return(_retval); } return(_retval.OrderBy(queryOrderBySettingCollection.GetOrderByExpression())); }
/// <param name="queryOrderBySettingCollection">query OrderBy setting</param> /// <returns>IQueryable<...> of Common</returns> internal IQueryable <Elmah.DataSourceEntities.ELMAH_Error> _GetQueryOfEntityByIdentifier( Framework.Queries.QuerySystemGuidEqualsCriteria errorId , Framework.Queries.QueryOrderBySettingCollection queryOrderBySettingCollection ) { var _ResultFromDataSource = ( from t in this.LinqContext.ELMAH_Error where ( ( (errorId.IsToCompare == false || errorId.IsToCompare && t.ErrorId == errorId.ValueToCompare) ) ) select new Elmah.DataSourceEntities.ELMAH_Error { ErrorId = t.ErrorId, Application = t.Application, Host = t.Host, Type = t.Type, Source = t.Source, Message = t.Message, User = t.User, StatusCode = t.StatusCode, TimeUtc = t.TimeUtc, Sequence = t.Sequence, AllXml = t.AllXml } into x select x ); var _retval = _ResultFromDataSource; if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0) { return(_retval); } return(_retval.OrderBy(queryOrderBySettingCollection.GetOrderByExpression())); }
public async Task <Framework.Models.DataAccessLayerMessageOfBoolean> ExistsOfDefaultByIdentifier( Framework.Queries.QuerySystemGuidEqualsCriteria errorId , int currentIndex = -1 , int pageSize = -1 , Framework.Queries.QueryOrderBySettingCollection queryOrderBySettingCollection = null ) { const string logMessageKey = "ExistsOfDefaultByIdentifier"; IQueryable <Elmah.DataSourceEntities.ELMAH_Error.Default> _Query = _GetQueryOfDefaultByIdentifier( errorId , queryOrderBySettingCollection ); return(await Elmah.EntityFrameworkDAL.IQueryableHelper.GetExistsMessageAsync(_Query, currentIndex, pageSize, logMessageKey)); }
public async Task <Elmah.DataSourceEntities.DataAccessLayerMessageOfEntityCollectionELMAH_Error> GetCollectionOfEntityByIdentifier( Framework.Queries.QuerySystemGuidEqualsCriteria errorId , int currentIndex = -1 , int pageSize = -1 , Framework.Queries.QueryOrderBySettingCollection queryOrderBySettingCollection = null ) { const string logMessageKey = "GetCollectionOfEntityByIdentifier"; IQueryable <Elmah.DataSourceEntities.ELMAH_Error> _Query = _GetQueryOfEntityByIdentifier( errorId , queryOrderBySettingCollection ); return(await Elmah.EntityFrameworkDAL.IQueryableHelper.GetCollectionMessageAsync < Elmah.DataSourceEntities.DataAccessLayerMessageOfEntityCollectionELMAH_Error, List <Elmah.DataSourceEntities.ELMAH_Error>, Elmah.DataSourceEntities.ELMAH_Error>(_Query, currentIndex, pageSize, logMessageKey)); }