Devart Entity Model Template generate data types incorrectly
Devart Entity Model Template generate data types incorrectly
The VS 2010 Devart Entity Model Template and Entity Developer (EDML) generate the CSDL and the SSDL incorrectly from my Database View. It set all the fields in the view to Entity Keys and make them non-nullable. My Database view join 3 tables that have primarly keys, and some some nullable fields in the table. When I generate an EDMX using the ADO.NET Entity Model and dotConnect for Progres Provider it seem to be generated correctly.
I am using dotConnect for Progres 4.95.180.0
Thanks,
Charlie J.
I am using dotConnect for Progres 4.95.180.0
Thanks,
Charlie J.
I was having a problem setting it the model as well, because the Store had it as non-nullable and and changing the Model gives a fragmented mapping error because we are mapping nullable field to a non-nullable store.
I don't have an actual script for the tables and view I can send you, but just create some tables with non-nullable and nullable fields and use it in the view. The ADO.NET Entity will infer them correctly in the EDMX, but using the Devart Model will set every field as the Entity Key which have to be non-nullable in the EDML.
Thanks,
Charlie J.
I don't have an actual script for the tables and view I can send you, but just create some tables with non-nullable and nullable fields and use it in the view. The ADO.NET Entity will infer them correctly in the EDMX, but using the Devart Model will set every field as the Entity Key which have to be non-nullable in the EDML.
Thanks,
Charlie J.
I have performed a test using the latest 5.70.180 build of dotConnect for Oracle and the view containing a join of two tables with nulable and non-nullable columns was added with the correct key by both Entity Developer and the EDM wizard.
Hope you will be able to find a script of the view the problem is reproducible on.
Hope you will be able to find a script of the view the problem is reproducible on.
I have made a test using a view built over the join of two views (also with JOIN). The EDM wizard have not added this view at all, Entity Developer added the view (but the key was generated a bit incorrectly).
Could you please post here or send us (support * devart.com, subject "EF: Join View") the DDL script of the view causing the problem?
Could you please post here or send us (support * devart.com, subject "EF: Join View") the DDL script of the view causing the problem?
We cannot query PostgreSQL metadata for hierarchies of the views.
I have tried to add a view built over join of two views.
EDM Wizard added it as XML comments into .edmx, beacuse it wasn't able to build Entity Key.
Entity Developer (Devart Entity model) has created an entity, but set only one column (not all as in your case) as Entity Key.
I have tried to add a view built over join of two views.
EDM Wizard added it as XML comments into .edmx, beacuse it wasn't able to build Entity Key.
Entity Developer (Devart Entity model) has created an entity, but set only one column (not all as in your case) as Entity Key.