Hello,
I use the following query:
(from objCase in dataContext.Cases
from objCaseType in dataContext.CaseTypes
where objCase.CuId == CustomerId
&& objCase.CtId == objCaseType.Id
select new Case {Description = objCaseType.Descr, Id = objCase.Id, Scope = objCaseType.Scope}).
ToList();
Case object is an Entity but with 2 more unbinded properties, Description and Scope where i need to project the relevant values from the joined CaseType Entity. When i run the query i get an InvalidOperationException with these details:
at Devart.Data.Oracle.Linq.Provider.a.a(String A_0, Boolean A_1)
at Devart.Data.Oracle.Linq.Provider.OracleDataSourceInfo.a.a(String A_0)
at Devart.Data.Linq.Provider.DataSourceInfo.TypeSystemProvider.GetProviderType(String typeName)
at Devart.Data.Linq.Provider.Query.SqlFactory.Default(MetaDataMember member)
at Devart.Data.Linq.Provider.Query.ao.a(f A_0, MetaType A_1, List`1& A_2, List`1& A_3, SqlExpression& A_4, IList`1 A_5)
at Devart.Data.Linq.Provider.Query.ao.b(f A_0, MetaType A_1, List`1& A_2, List`1& A_3, SqlExpression& A_4, IList`1 A_5)
at Devart.Data.Linq.Provider.Query.ao.a(f A_0, IList`1 A_1)
at Devart.Data.Linq.Provider.Query.ao.a(MetaType A_0, ITable A_1, IList`1 A_2)
at Devart.Data.Linq.Provider.Query.bk.a(ITable A_0)
at Devart.Data.Linq.Provider.Query.bk.a(ConstantExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.a(Expression A_0, Expression A_1, Expression A_2)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.a(Expression A_0, LambdaExpression A_1)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.d(Expression A_0, Expression A_1)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.i(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.h(Expression A_0)
at Devart.Data.Linq.DataQuery`1.i()
InvalidOperationException
I projected to a new custom Entity CaseView which is not binded to the database and in this i need to project 5 properties from Case & CaseType entities.
I used the query:
cases = (from objCase in dataContext.Cases
from objCaseType in dataContext.CaseTypes
where objCase.CuId == CustomerId
&& objCase.CtId == objCaseType.Id
select
new CaseView
{
ParentId = objCase.ParId,
Status = objCase.Status,
Description = objCaseType.Descr,
Id = objCase.Id,
Scope = objCaseType.Scope
}).
ToList();
and i get a :
"Invalid datatype: "
at Devart.Data.Oracle.Linq.Provider.a.a(String A_0, Boolean A_1)
at Devart.Data.Oracle.Linq.Provider.OracleDataSourceInfo.a.a(String A_0)
at Devart.Data.Linq.Provider.DataSourceInfo.TypeSystemProvider.GetProviderType(String typeName)
at Devart.Data.Linq.Provider.Query.SqlFactory.Default(MetaDataMember member)
at Devart.Data.Linq.Provider.Query.ao.a(f A_0, MetaType A_1, List`1& A_2, List`1& A_3, SqlExpression& A_4, IList`1 A_5)
at Devart.Data.Linq.Provider.Query.ao.b(f A_0, MetaType A_1, List`1& A_2, List`1& A_3, SqlExpression& A_4, IList`1 A_5)
at Devart.Data.Linq.Provider.Query.ao.a(f A_0, IList`1 A_1)
at Devart.Data.Linq.Provider.Query.ao.a(MetaType A_0, ITable A_1, IList`1 A_2)
at Devart.Data.Linq.Provider.Query.bk.a(ITable A_0)
at Devart.Data.Linq.Provider.Query.bk.a(ConstantExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.a(Expression A_0, Expression A_1, Expression A_2)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.a(Expression A_0, LambdaExpression A_1)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.d(Expression A_0, Expression A_1)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.i(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.h(Expression A_0)
at Devart.Data.Linq.DataQuery`1.i()
I used the query:
cases = (from objCase in dataContext.Cases
from objCaseType in dataContext.CaseTypes
where objCase.CuId == CustomerId
&& objCase.CtId == objCaseType.Id
select
new CaseView
{
ParentId = objCase.ParId,
Status = objCase.Status,
Description = objCaseType.Descr,
Id = objCase.Id,
Scope = objCaseType.Scope
}).
ToList();
and i get a :
"Invalid datatype: "
at Devart.Data.Oracle.Linq.Provider.a.a(String A_0, Boolean A_1)
at Devart.Data.Oracle.Linq.Provider.OracleDataSourceInfo.a.a(String A_0)
at Devart.Data.Linq.Provider.DataSourceInfo.TypeSystemProvider.GetProviderType(String typeName)
at Devart.Data.Linq.Provider.Query.SqlFactory.Default(MetaDataMember member)
at Devart.Data.Linq.Provider.Query.ao.a(f A_0, MetaType A_1, List`1& A_2, List`1& A_3, SqlExpression& A_4, IList`1 A_5)
at Devart.Data.Linq.Provider.Query.ao.b(f A_0, MetaType A_1, List`1& A_2, List`1& A_3, SqlExpression& A_4, IList`1 A_5)
at Devart.Data.Linq.Provider.Query.ao.a(f A_0, IList`1 A_1)
at Devart.Data.Linq.Provider.Query.ao.a(MetaType A_0, ITable A_1, IList`1 A_2)
at Devart.Data.Linq.Provider.Query.bk.a(ITable A_0)
at Devart.Data.Linq.Provider.Query.bk.a(ConstantExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.a(Expression A_0, Expression A_1, Expression A_2)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.a(Expression A_0, LambdaExpression A_1)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.d(Expression A_0, Expression A_1)
at Devart.Data.Linq.Provider.Query.bk.b(MethodCallExpression A_0)
at Devart.Data.Linq.Provider.Query.bk.j(Expression A_0)
at Devart.Data.Linq.Provider.Query.bk.i(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.h(Expression A_0)
at Devart.Data.Linq.DataQuery`1.i()