Thank you for your reply. I found that information already. I also tried that
already. But I then would have to add Entities manually, right? Or did I miss a
step? This makes it very "not handsome" to use because during development
process the views are changing a lot. Is there any other solution? Like marking
columns in the database with #PK_GEN# or something similar?
BR
C
http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/
--
Mgr. Jiří Činčura
Independent IT Specialist
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
845a8f621f6d43b09e7c5f8288e69d35@S05-MBX01-01.S05.local
Von: Christoph Gasser
Gesendet: Samstag, 31. Jänner 2015 12:47
An: 'firebird-net-provider@lists.sourceforge.net'
Betreff: Firebird EF6 DDEX adding Views
I'm using VS 2012, Firebird 2.5, EF6. When trying to add a View to my model in
the designer I get the message:
"The table/view 'Firebird.Firebird.V_MYVIEW' does not have a primary key
defined and no valid primary key could be inferred. This table/view has been
excluded. To use the entity, you will need to review your schema, add the
correct keys, and uncomment it."
That's because EF need a PK for every table / view. When using MSSQL there is
an approach using ISNULL in the view to be able to add the view to the model.
But ISNULL is not supported in Firebird.
The underlying table of the view has PK which is also marked as #PK_GEN# . And
I'm able to add this table to my model.
So my question is: Does anyone know how to add a view to a EF6 model in
designer?
BR
C
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
