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
