search

bubibubi / JetEntityFrameworkProvider

Microsoft Access (Jet) Entity Framework provider
89 stars 26 forks source link

Error when importing queries from my database #26

Closed powellbird closed 6 years ago

powellbird commented 6 years ago

It is an excellent library, I only have one question, in my access database I have defined views which I use for more rapids instead of defining the query, but it generates an error when processing the model since the views have no primary key and it does not matter to the model.

could you help me with this problem please, thank you

this is the error

Severity Code Description Project File Line Suppression Status Warning Error 6013: The table or view 'Jet.Jet.Consulta1' has not defined a primary key and it is not possible to infer any valid primary key. This table or view has been excluded. To use the entity, you will need to review the schema, add the correct keys and remove your comments. dbfirs_sample d: \ documents \ visual studio 2015 \ Projects \ dbfirs_sample \ dbfirs_sample \ Model1.edmx 1

bubibubi commented 6 years ago

This error is raised by EF and it is independent on the provider. I think that there is not a solution but I don't know because I'm not a DB First fan. You can try to ask on Stack Overflow.