Devart Forums

AndreyR wrote:This problem is caused by Entity Framework code.
You can find the reason in the note to this article:

For a function import to return an EntityType, the columns returned by the corresponding stored procedure must exactly match the scalar properties of the returned EntityType.

The solution is to leave underscores in the model or to create correct aliases in the procedure code.

Thanks for the response. I assume you are dependant on EF then and can't incorporate something your side that can rectify this?

Thanks again

I have a stored procedure such as the following:

PROCEDURE JustTesting(curParam OUT SYS_REFCURSOR) AS
BEGIN
OPEN curParam FOR
SELECT *
FROM MyTable;
END JustTesting;

I have followed the instructions as outlined here: http://www.devart.com/dotconnect/oracle ... rsors.html

I have used the ADO.NET POCO Entity Generator to provide the model and context templates and generated the relevant classes.

The context now contains the following method relating to my function:

public ObjectResult JustTesting()
{
return base.ExecuteFunction("JustTesting");
}

Calling this method raises an error such as: "The data reader is incompatible with the specified MyModel.JustTestingResult'. A member of the type, 'MyTestId', does not have a corresponding column in the data reader with the same name."

Now, the reason for this is that the column in the database is named "My_Test_Id" not MyTestId. So, I can rename this in the JustTestingResult complex type (and this will work), but then why should my conceptual model have to be tightly coupled with the physical model? So, the question is, how do I map between MyTestId and My_Test_Id?

Thanks

Is it possible to have the entity classes that are generated output in another project? Or even better, is there a T4 template that I can include in another project that will generate the relevant classes from a model that is defined in a different project?

Thanks

Hi,

I am trying to do some code-first development with the Entity Framework using the dotconnect for Oracle provider. However, I am getting the error "DatabaseExists is not supported by the provider". I am assuming this, as the error suggests, isn't implemented by the provider. Is there plans to do so?

Thanks