Stack Trace:
at Devart.Data.PostgreSql.PgSqlDataReader.(Int32 , String )
at Devart.Data.PostgreSql.PgSqlDataReader.GetValue(Int32 i)
at Devart.Common.DbDataReaderBase.IsDBNull(Int32 ordinal)
at lambda_method(Closure , DbDataReader )
at Microsoft.EntityFrameworkCore.Storage.Internal.TypedRelationalValueBufferFactory.Create(DbDataReader dataReader)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_TrackEntities>d__17`2.MoveNext()
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Gt.Gateway.GageGateway.GetPaged(Int32 offset, Int32 pageSize, TargetDatabase target, SecurityToken securityToken) in C:\Repository\GtNext\Source\Base\Next\GtGateway\Repos\GageGateway.cs:line 723
Code:
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;
}