Devart Forums

Adding a element and using the Devart.Data.Oracle.Entity.dll seem to have fixed the problem.

Hello,

I have a console application I'm trying to deploy and I'm getting the exception below. It works fine on my development machine.

System.ArgumentException: The specified store provider cannot be found in the configuration, or is not valid. ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Here is my app.config file:







What do I need to do to resolve this? I already have the dll's below in the installation folder:

Devart.Data.dll
Devart.Data.Linq.dll
Devart.Data.Oracle.dll
Devart.Data.Oracle.Linq

- Taylor

When I try to add my stored procedure to the model in Entity Developer I get an error that says, "Can't add the method." There is no additional information provided. Any ideas what I should do next?

Would like to see these answers in the posting so others can see the solution (like me) who has the same question.

1) Question 1

Is it possible to use multiple output parameters in a stored procedure with Entity Framework? If so, is there an example somewhere I can review?

I have a stored procedure that has the following parameters:

user_id IN VARCHAR2
some_id OUT NUMBER
other_id OUT NUMBER
success OUT NUMBER

2) Question 2

I've also noticed that my entities class does not contain the method I've mapped via "Function Import" unless I declare a return type of entity. If I declare a void/bool, etc. return type there is no method on the entities class.

Please advise.

Thank you,
Taylor

Is there an example of how to use out parameters with EF?

I had edited an association to be OneToOne rather than OneToMany and this is when I saw the exception. The association should be a valid OneToOne but when I add the table in design view it creates the OneToMany association. Any ideas what needs to change with the tables in order to get this to be OneToOne?

I'm very new to DevArt dotConnect and LINQ to SQL and I'm getting the exception below which is a little cryptic. Any ideas how to solve this?

System.InvalidOperationException was unhandled
Message="The number of ThisKey columns is different from the number of OtherKey columns for the association property 'Foo' in the type 'Bar'."
Source="Devart.Data.Linq"
StackTrace:
at Devart.Data.Linq.Mapping.t..ctor(q A_0, AssociationAttribute A_1)
at Devart.Data.Linq.Mapping.q.n()
at Devart.Data.Linq.Provider.Query.ai.a(bk A_0, MetaDataMember A_1)
at Devart.Data.Linq.Provider.Query.ai.a(SqlExpression 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.ai.b(SqlExpression 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.ai.a(ag A_0, IList`1 A_1)
at Devart.Data.Linq.Provider.Query.ai.a(MetaType A_0, ITable A_1, IList`1 A_2)
at Devart.Data.Linq.Provider.Query.ai.a(au A_0)
at Devart.Data.Linq.q.a(au A_0, List`1 A_1)
at Devart.Data.Linq.q.a(MetaDataMember A_0, au A_1, List`1 A_2)
at Devart.Data.Linq.Provider.SelectionBuilder.a(bk A_0)
at Devart.Data.Linq.Provider.SelectionBuilder.a(SqlExpression A_0)
at Devart.Data.Linq.Provider.SelectionBuilder.BuildSelection(SqlExpression selection)
at Devart.Data.Linq.Provider.j.a(n A_0, SqlExpression A_1)
at Devart.Data.Linq.Provider.j.a(Type A_0, SqlExpression A_1, n A_2, Type A_3, Type A_4)
at Devart.Data.Linq.Provider.DataProvider.b.a(List`1 A_0, n A_1, SqlNode A_2)
at Devart.Data.Linq.Provider.DataProvider.b..ctor(a A_0, n A_1)
at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.i(Expression A_0)
at Devart.Data.Linq.DataQuery`1.i()