This question is locked. New answers and comments are not allowed.
Hi there;
After upgrading from 2010.1.527.2 to the versions currently available (2010.3 1110 or 2010.3 1125), the following query is generating an exception:
public static List<Merchant> SearchByName(String nameToSearch, Int32 index, Int32 max, Int32 statusID, FetchPlan fp, out Int32 virtCount)
{
IObjectScope scope = ScopeUtility.GetScope();
var list = from c in scope.Extent<Merchant>()
where (c.Name.ToUpper().Contains(nameToSearch.ToUpper()) || nameToSearch == String.Empty)
orderby c.Name
select c;
Exception Details: System.InvalidOperationException: JdbcType
Source Error:
Line 169: }
Line 170:
Line 171: virtCount = list.Count();
Line 172: return list.Skip(index).Take(max).ToList();
Line 173: }
Stack Trace:
[InvalidOperationException: JdbcType]
Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQueryImpl(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single) +1472
Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single) +107
[InvalidOperationException: An exception occured during the execution of '
Extent<XX.Data.Merchant>.Where(c => (c.Name.ToUpper().Contains(value(XX.BLL.MerchantUtility+<>c__DisplayClass4).nameToSearch.ToUpper()) || (value(XX.BLL.MerchantUtility+<>c__DisplayClass4).nameToSearch = String.Empty))).OrderBy(c => c.Name)'. See InnerException for more details.
]
Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single) +468
Telerik.OpenAccess.Query.ExpressionExecution.PerformQueryCount(Piece`1 piece) +98
Telerik.OpenAccess.Query.ExpressionExecution.PerformQuerySingle(Piece`1 piece, Expression expression) +445
Telerik.OpenAccess.Query.Piece`1.System.Linq.IQueryProvider.Execute(Expression expr) +78
System.Linq.Queryable.Count(IQueryable`1 source) +310
XX.BLL.MerchantUtility.SearchByName(String nameToSearch, Int32 index, Int32 max, Int32 statusID, FetchPlan fp, Int32& virtCount)
XX.Controls.Merchant_List.BindRep()
XX.Controls.Merchant_List.BindData()
XX.Controls.Merchant_Manager.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive() +66
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
After upgrading from 2010.1.527.2 to the versions currently available (2010.3 1110 or 2010.3 1125), the following query is generating an exception:
public static List<Merchant> SearchByName(String nameToSearch, Int32 index, Int32 max, Int32 statusID, FetchPlan fp, out Int32 virtCount)
{
IObjectScope scope = ScopeUtility.GetScope();
var list = from c in scope.Extent<Merchant>()
where (c.Name.ToUpper().Contains(nameToSearch.ToUpper()) || nameToSearch == String.Empty)
orderby c.Name
select c;
Exception Details: System.InvalidOperationException: JdbcType
Source Error:
Line 169: }
Line 170:
Line 171: virtCount = list.Count();
Line 172: return list.Skip(index).Take(max).ToList();
Line 173: }
Stack Trace:
[InvalidOperationException: JdbcType]
Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQueryImpl(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single) +1472
Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single) +107
[InvalidOperationException: An exception occured during the execution of '
Extent<XX.Data.Merchant>.Where(c => (c.Name.ToUpper().Contains(value(XX.BLL.MerchantUtility+<>c__DisplayClass4).nameToSearch.ToUpper()) || (value(XX.BLL.MerchantUtility+<>c__DisplayClass4).nameToSearch = String.Empty))).OrderBy(c => c.Name)'. See InnerException for more details.
]
Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single) +468
Telerik.OpenAccess.Query.ExpressionExecution.PerformQueryCount(Piece`1 piece) +98
Telerik.OpenAccess.Query.ExpressionExecution.PerformQuerySingle(Piece`1 piece, Expression expression) +445
Telerik.OpenAccess.Query.Piece`1.System.Linq.IQueryProvider.Execute(Expression expr) +78
System.Linq.Queryable.Count(IQueryable`1 source) +310
XX.BLL.MerchantUtility.SearchByName(String nameToSearch, Int32 index, Int32 max, Int32 statusID, FetchPlan fp, Int32& virtCount)
XX.Controls.Merchant_List.BindRep()
XX.Controls.Merchant_List.BindData()
XX.Controls.Merchant_Manager.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive() +66
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191