Devart Forums

Gruffta

Maybe a bit late but I had the same issue today.

I have 2 contexts both using migrations, when running update-database for the first time on the second context you will get this error as it retries to create the __MigrationsHistory table when it should just insert the context data as a row if this exists.

As the table contains a context type field and and records are retrieved from this table passing the context type in I would say this is probably a bug and you should check for existence of the migrations history table in the schema first.

To workaround this issue you can just run the migration command with the -Script setting and remove the create statement for the migrations history table.

Thanks
Gareth

Gruffta

I have found part of the issue in my case.
I have VARCHAR2 columns in my select query and had not set

Code: Select all

OracleEntityProviderConfig.Instance.CodeFirstOptions.UseNonLobStrings = true;

this caused to_clob to be used instead of to_char when creating the null typed definitions.

When is added the above code the query threw another error this seems to be related to the order of your includes, I had to place the include that had a date column after the include that didn't have any date columns.

After that it all worked, seems brittle though.

Hope it helps.
Gareth

Gruffta

Has there been any progress on this? I to am experiencing the same issue on Oracle 12c.
If you still need a sample project I'd be happy to send one.

Thanks
Gareth

Gruffta

HI.

We have an issue with the devart components, where, if you are running within visual studio and the application breaks into the debugger when you resume the inactive sessions in oracle will not be reused and a new session is created until the server runs out of resources.

If no breakpoint/error is hit you will see the session going from active->inactive->active.

Thanks

Gareth

Gruffta

me to, wf4 support would be great

Gruffta

As for the first issue a workaround is to add this to your partial objectcontext class

Code: Select all

 base.CreateQuery(
                    "select value DistributorFx.Model.Module.AutomatedOrders.Entity.Store.get_vat_rate(@company, @item_code, @vat_code, @vat_location) from {1}",
                    new[]
                        {
                            new ObjectParameter("COMPANY", company),
                            new ObjectParameter("ITEM_CODE", itemCode),
                            new ObjectParameter("VAT_CODE", vatCode),
                            new ObjectParameter("VAT_LOCATION", vatLocation)
                        }).FirstOrDefault();

again this doesn't seem very natural

Gruffta

I have found the cause of the last posts issue, the entity developer program is performing the casing,plurization rules and creating a complex type with a property VatLocation then when you execute the function its returning vat_location and causing the error to be thrown, changing the csdl for this field to vat_location fixed this problem but doesn't seem natural when you can do this in Linqconnect with no issues whatsoever.

Gruffta

Also when calling a stored procedure with 3 input parameters and a output parameter of sys_refcursor, Im also experiencing an issue

Code: Select all

The data reader is incompatible with the specified 'DistributorFx.Model.Module.LightningSource.Entity.GetOriginalOrderDetailResult'. A member of the type, 'NextLineNo', does not have a corresponding column in the data reader with the same name.
   at System.Data.Query.InternalTrees.ColumnMapFactory.GetMemberOrdinalFromReader(DbDataReader storeDataReader, EdmMember member, EdmType currentType, Dictionary`2 renameList)
   at System.Data.Query.InternalTrees.ColumnMapFactory.GetColumnMapsForType(DbDataReader storeDataReader, EdmType edmType, Dictionary`2 renameList)
   at System.Data.Query.InternalTrees.ColumnMapFactory.CreateColumnMapFromReaderAndType(DbDataReader storeDataReader, EdmType edmType, EntitySet entitySet, Dictionary`2 renameList)
   at System.Data.Query.InternalTrees.ColumnMapFactory.CreateFunctionImportStructuralTypeColumnMap(DbDataReader storeDataReader, FunctionImportMapping mapping, EntitySet entitySet, StructuralType baseStructuralType)
   at System.Data.EntityClient.EntityCommandDefinition.FunctionColumnMapGenerator.System.Data.EntityClient.EntityCommandDefinition.IColumnMapGenerator.CreateColumnMap(DbDataReader reader)
   at System.Data.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, EntitySet entitySet, EdmType edmType, MergeOption mergeOption)
   at System.Data.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters)
   at System.Data.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters)
   at DistributorFx.Model.Module.LightningSource.Entity.LightningSourceProcessingModelEntities.GetOriginalOrderDetail(Nullable`1 COMPANY, Nullable`1 BRANCH, Nullable`1 ORDER_NUMBER)

Gruffta

I also get the exception

Code: Select all

System.Data.EntityCommandExecutionException: The data reader returned by the store data provider does not have enough columns for the query requested.

when calling the generated code method on the ObjectContext

Code: Select all

using (var model = new AutomatedOrderProcessingModelEntities())
		    {
		        model.GetVatRate(3, "4130791400352", "Z", 4);
		    }

Gruffta

I'm trying to use the entity developer to add a function that returns a number and keep getting the exception

Code: Select all

System.Data.EntityCommandExecutionException: The data reader returned by the store data provider does not have enough columns for the query requested

at System.Data.EntityClient.EntityCommandDefinition.ConstantColumnMapGenerator.System.Data.EntityClient.EntityCommandDefinition.IColumnMapGenerator.CreateColumnMap(DbDataReader reader)
at System.Data.EntityClient.EntityCommandDefinition.CreateColumnMap(DbDataReader storeDataReader)
at System.Data.Objects.ObjectContext.CreateFunctionObjectResult(EntityCommand entityCommand, EntitySet entitySet, EdmType edmType, MergeOption mergeOption)
at System.Data.Objects.ObjectContext.ExecuteFunction(String functionName, MergeOption mergeOption, ObjectParameter[] parameters)
at System.Data.Objects.ObjectContext.ExecuteFunction(String functionName, ObjectParameter[] parameters)

Im attempting to call the function using the ObjectContext ExecuteFunction
like so

Code: Select all

ObjectParameter[] parameters = {
                                                   new ObjectParameter("COMPANY", 3),
                                                   new ObjectParameter("ITEM_CODE", "4130791400352"),
                                                   new ObjectParameter("VAT_CODE", "Z"),
                                                   new ObjectParameter("VAT_LOCATION", 4)
                                               };
                decimal result;

                result = model.ExecuteFunction("GetVatRate", parameters).FirstOrDefault();

I've also tried doing it this way:

Code: Select all

var query =
                    new ObjectQuery(
                        "DfxtestModel.Store.GET_VAT_RATE(@COMPANY, @ITEM_CODE, @VAT_CODE, @VAT_LOCATION)", model);
                query.Parameters.Add(new ObjectParameter("COMPANY", 3));
                query.Parameters.Add(new ObjectParameter("ITEM_CODE", "4130791400352"));
                query.Parameters.Add(new ObjectParameter("VAT_CODE", "Z"));
                query.Parameters.Add(new ObjectParameter("VAT_LOCATION", 4));

                result = query.FirstOrDefault();

which results in the following exception:

Code: Select all


Function metadata used in DbFunctionExpression must allow composition. Non-composable functions or functions that include command text are not allowed in expressions. Such functions can only be executed independently.

at System.Data.Common.CommandTrees.ExpressionBuilder.Internal.ArgumentValidation.ValidateFunction(EdmFunction function, IEnumerable`1 arguments, ref DbExpressionList validArgs)
at System.Data.Common.CommandTrees.ExpressionBuilder.DbExpressionBuilder.InvokeFunction(EdmFunction function, IEnumerable`1 arguments)
at System.Data.Common.CommandTrees.ExpressionBuilder.DbExpressionBuilder.Invoke(EdmFunction function, IEnumerable`1 arguments)
at System.Data.Common.EntitySql.SemanticAnalyzer.CreateModelFunctionCallExpression(MethodExpr methodExpr, MetadataFunctionGroup metadataFunctionGroup, SemanticResolver sr)
at System.Data.Common.EntitySql.SemanticAnalyzer.ConvertModelFunctionCall(MetadataFunctionGroup metadataFunctionGroup, MethodExpr methodExpr, SemanticResolver sr)
at System.Data.Common.EntitySql.SemanticAnalyzer.ConvertMethodExpr(MethodExpr methodExpr, Boolean includeInlineFunctions, SemanticResolver sr)
at System.Data.Common.EntitySql.SemanticAnalyzer.ConvertMethodExpr(Node expr, SemanticResolver sr)
at System.Data.Common.EntitySql.SemanticAnalyzer.Convert(Node astExpr, SemanticResolver sr)
at System.Data.Common.EntitySql.SemanticAnalyzer.ConvertValueExpression(Node astExpr, SemanticResolver sr)
at System.Data.Common.EntitySql.SemanticAnalyzer.ConvertQueryStatementToDbExpression(Statement astStatement, SemanticResolver sr)
at System.Data.Common.EntitySql.SemanticAnalyzer.AnalyzeQueryCommand(Node astExpr)
at System.Data.Common.EntitySql.CqlQuery.b__8(SemanticAnalyzer analyzer, Node astExpr)
at System.Data.Common.EntitySql.CqlQuery.AnalyzeSemanticsCommon(Node astExpr, Perspective perspective, ParserOptions parserOptions, IEnumerable`1 parameters, IEnumerable`1 variables, Func`3 analysisFunction)
at System.Data.Common.EntitySql.CqlQuery.AnalyzeQueryExpressionSemantics(Node astQueryCommand, Perspective perspective, ParserOptions parserOptions, IEnumerable`1 parameters, IEnumerable`1 variables)
at System.Data.Common.EntitySql.CqlQuery.c__DisplayClass4.b__3(Node astCommand, ParserOptions validatedParserOptions)
at System.Data.Common.EntitySql.CqlQuery.CompileCommon(String commandText, Perspective perspective, ParserOptions parserOptions, Func`3 compilationFunction)
at System.Data.Common.EntitySql.CqlQuery.CompileQueryCommandLambda(String queryCommandText, Perspective perspective, ParserOptions parserOptions, IEnumerable`1 parameters, IEnumerable`1 variables)
at System.Data.Objects.EntitySqlQueryState.Parse()
at System.Data.Objects.ELinq.ExpressionConverter.TranslateInlineQueryOfT(ObjectQuery inlineQuery)
at System.Data.Objects.ELinq.ExpressionConverter.ConstantTranslator.TypedTranslate(ExpressionConverter parent, ConstantExpression linq)
at System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)
at System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)
at System.Data.Objects.ELinq.ExpressionConverter.TranslateSet(Expression linq)
at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.UnarySequenceMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)
at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.SequenceMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, SequenceMethod sequenceMethod)
at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)
at System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)
at System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)
at System.Data.Objects.ELinq.ExpressionConverter.Convert()
at System.Data.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at System.Linq.Enumerable.FirstOrDefault(IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.b__1(IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle(IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression)
at System.Linq.Queryable.FirstOrDefault(IQueryable`1 source)

Code: Select all

Am I doing something wrong or is this just not supported?? I was under the impression it was under EF4

Gruffta

Ignore this, was me being stupid should have defined a one to many relationship with publisher detail enquiry set as the parent table.

Sorry about that.

Devart Forums

Search found 11 matches

Re: Code First Migrations: MoveTableOperation is not supported.

Re: Union query throws error : Failed in 796 ms with error: ORA-01790: expression must have same datatype as corresponding e

Re: Union query throws error : Failed in 796 ms with error: ORA-01790: expression must have same datatype as corresponding e

Connection Pooling Issue

Entity Framework - Function Imports

Bug in Entity Developer - Linq to SQL