Devart Forums

Code: Select all

        public new List<Gage> GetPaged ( int offset, int pageSize, TargetDatabase target, SecurityToken securityToken )
        {
            List<Gage> res = null;

            LogProvider.Logger.LogInfo ( "GageGateway.GetPaged enter" );

            try
            {
                using ( var context = Gt.Model.GtContextFactory.Create ( target ) )
                {
                    

                    if ( pageSize <= 0 )
                        pageSize = SqlConstants.DefaultPageSize;

                    res =
                        ( from c in
                                context.Gages.
                                Include ( "Status" ).
                                Include ( "Supplier" ).
                                Include ( "Template" )
                            select c ).OrderBy ( g => g.Gage_ID ).Skip ( offset ).Take ( pageSize ).ToList ();
                }

            }
            catch ( Exception ex )
            {
                LogProvider.Logger.LogException ( "GageGateway.GetPaged exception", ex );
                throw ex;
            }

            LogProvider.Logger.LogInfo ( "GageGateway.GetPaged exit" );

            return res;
        }

Code: Select all

SELECT "COUNT"(*)
FROM (
    SELECT DISTINCT g."Manufacturer"
    FROM "MYSCHEMA"."MyItems" g
    WHERE g."Manufacturer" IS NOT NULL AND (Trim(g."Manufacturer") <> '')
) AS t

Code: Select all

   at   .    (   )
   at   .()
   at Devart.Data.PostgreSql.PgSqlCommand.InternalPrepare(Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at   .     ​  ​     (CommandBehavior )
   at  .ExecuteDbDataReader(CommandBehavior )
   at   .ExecuteDbDataReader(CommandBehavior )
   at  .Execute(IRelationalConnection , DbCommandMethod , IReadOnlyDictionary`2 )
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
   at Microsoft.EntityFrameworkCore.Query.QueryMethodProvider.GetResult[TResult](IEnumerable`1 valueBuffers, Boolean throwOnNullResult)
   at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ResultEnumerable`1.GetEnumerator()
   at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass15_1`1.<CompileQueryCore>b__0(QueryContext qc)

Code: Select all

            try
            {
                using ( var context = new MyContext ( connStr ) )
                {
                    count = context.MyItems.Where ( g => g.Manufacturer != null && g.Manufacturer.Trim () != String.Empty ).Select ( g => g.Manufacturer ).Distinct ().Count ();
                }

            }
            catch ( Exception ex )
            {
                throw ex;
            }