Devart Forums

skingaby

Thank you!

skingaby

Further testing has me confused. It looks like ED is preserving the manual change, but I will re-iterate that ED should populate the MaxLength in the Conceptual Model. Thanks.

skingaby

I just tested something else. I had manually set the MaxLength on one of the fields in the Conceptual Model:

Code: Select all

After opening this in your Entity Developer, the MaxLength property was erased.

It would be nice if Entity Developer set this property for me, but it is a much more serious bug that it erases it after I manually set it.

skingaby

Do you have any plans to parse the MaxLength from the Store model into the MaxLength property on the Conceptual Model? This seems to be a missing piece in the rendered XML.

I have other 3rd party tools that read the Conceptual Model and pick up the MaxLength property to define column validators, but they are not getting any lengths because these are not emitted in your tool.

skingaby

The new version preserves the Ideablade tags!!! Thank you! The tag is still being dropped which means I cannot just use the EDML / EDMX interchangably, which I would like to do. I shall look forward to that feature in a future release. Thanks for all you do!

skingaby

Change the proc into a Before Insert trigger on the table. Then edit the EDMX/EDML file (Entity Framework Model) and add the StoreGeneratedPattern="Identity" attribute to the key field in that table's definition, for example:

We have a table named DEAL. The trigger looks like this:

Code: Select all

CREATE OR REPLACE TRIGGER GCSD9.DEAL_BI_GETSEQ
  BEFORE INSERT ON GCSD9.DEAL FOR EACH ROW
  WHEN (NEW.DEAL_ID IS NULL)
BEGIN SELECT DEAL_ID_SEQ.NEXTVAL INTO :NEW.DEAL_ID FROM DUAL; END;

and the EDMX file is modified like this:

Code: Select all

There is no GUI for the StoreGeneratedPattern attribute, you have to edit the XML. With this attribute set, the EF will automatically reload the newly populated key after persisting the entity.

skingaby

I tried reversing the direction of that parameter and it still doesn't work. I cannot seem to fake it out any way I try. I am anxiously awaiting the next release as there are several features that I am looking forward to.

skingaby

I have a Proc:

Code: Select all

PROCEDURE Get_Confirm_Document(
      DealID IN deal.DEAL_ID%TYPE,
      r_cursor OUT sys_refcursor 
   ) 
   IS

I added it to the EF Model as a Function, and it generated this code:

Code: Select all

public global::System.Data.Objects.ObjectResult GetConfirmDocument(global::System.Nullable dEALID, global::System.Data.Objects.ObjectParameter r_CURSOR)
        {
            global::System.Data.Objects.ObjectParameter dEALIDParameter;
            if (dEALID.HasValue)
            {
                dEALIDParameter = new global::System.Data.Objects.ObjectParameter("DEALID", dEALID);
            }
            else
            {
                dEALIDParameter = new global::System.Data.Objects.ObjectParameter("DEALID", typeof(long));
            }
            return base.ExecuteFunction("GetConfirmDocument", dEALIDParameter, r_CURSOR);
        }

And I created a Unit Test to execute the proc and return the results.

Code: Select all

[TestMethod]
        public void MainPdfProcTest()
        {
            var context = new ServerModelEF.GcsModelEntities();
            var result = context.GetConfirmDocument((long?)7623, null);
            Assert.IsNotNull(result);
        }

What should the GetConfirmDocument() call pass in as the second parameter? It doesn't like the null. I get an error: System.InvalidOperationException: The parameter at index 1 in the parameters array is null.

Thanks.

skingaby

When the EDML file is saved, the only difference in the structure seems to be that this tag is missing:

...

Because this tag is missing, the EDML cannot be opened as an EDMX in the Entity Developer.

Two questions:
1) Do you have any plans to change your tool to work directly off the EDMX file?
2) Can you either a) leave the tag in the XML; or b) add it back in so that the EDML/X file can be opened in either DevArt Entity Designer or the MS Entity Designer?

Also, there is more going on here. The DevArt Entity Designer needs to preserve ALL the XML that has been added to the model, regardless of which tool added the XML.
I am using the IdeaBlade DevForce product to extend my Entity Framework layer. This tool, like yours, decorates the EDMX XML with its own tags and attributes. Your
designer needs to preserve their tags when it writes back the XML, please.

Here is my current model editing process for working with the Oracle-Devart-EntityFramework-Devforce stack:
1) Including an Entity Framework EDMX model in my ServerModelEF project.
2) Excluding, but having, a DevArt Entity Designer EDML model in that same ServerModelEF project.
3) Having a DevForce model in the ServerModel (not ServerModelEF) project.
4) The DevForce model is connected to the EDMX model.
5) When I need to edit the EF model, I copy the XML from the EDMX file to the EDML file, then I edit it in DevArt ED, then, when that is saved, I copy the XML back to the EDMX file EXCEPT I do not copy back the ... tag contents at the bottom as the EDML is missing the tag that the Entity Framework EDMX needs.
(Yes, this is tedious, but it seems to keep things straight.)
6) When the EDMX file is saved, DevForce notices and regenerates its generated code.

skingaby

Is there a way to update the Entity Model from the database so it can add the new column I added to my table? Thanks, Simon.

skingaby

The Post you referenced in your link is about the connection string, which the MS Entity Framework supports and you will support in the next version.

I am referring to the database Schema property, which is shown here:

That schema name "GCSD9" changes to GCSQ9 for QA, GCSM9 for Staging and GCSP9 for Production. That setting needs to be pulled out of the app.config file if at all possible.
Thanks,
Simon

skingaby

Can you figure out a way to move the Oracle Schema name out of the EDML file and into the App.Config. We have 4 different schema names for Dev, Test, Maint and Prod. The way the Entity Developer works now, it looks like I will have to do a find and replace in the XML source before I promote to testing? Thanks, Simon

skingaby

I am using the latest (2.0.21) version of the Oracle Entity Developer. Where did the Generate button go? I can't see the generated files at all and my test project is complaining that: Test method TestProject2.UnitTest1.TestMethod1 threw exception: System.Data.MetadataException: The specified metadata path is not valid. A valid path must be either an existing directory, an existing file with extension '.csdl', '.ssdl', or '.msl', or a URI that identifies an embedded resource.
Thanks.

skingaby

Do you have plans to support moving the connection String out of the generated code module and into the app.config file? I need to be able to point to Dev, QA and Prod without recompiling the entire solution.
Thanks,
Simon

skingaby

I posted a lengthy workaround for using the Devforce Object Mapper with the Devart Entity Developer on their forum: Devforce Support.
However, the problem remains that whenever they write out the edmx/edml file, they do not include the edmx: prefix in the , and tags. These tags are not prefixed in the Microsoft ADO Entity Designer either.
I would like to see: either a) Your Entity Developer is able to read both formats, or b) Your Entity Developer writes the tags without the prefix, the same as the Microsoft tool does.
Thanks,
Simon

Devart Forums

Search found 33 matches

MaxLength missing in the Conceptual Model

How to Execute Ref Cursor Proc in Oracle via EF

<Diagrams> Tag is Missing

I just added a column, how do I refresh the Entity Model?

Not the Connection String, the Schema

Oracle Schema needs to be in Config

Where did the generate button go?

Connection String in app.config

Workaround found, but still have a problem