search

bubibubi / JetEntityFrameworkProvider

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

DbFirst not generating models for all tables #15

Open davidda opened 7 years ago

davidda commented 7 years ago

DbFirst model generation only was able to generate models for about 20% of my db objects. The rest of the tables and views were simply missing from the model, although I had checked them in the generation wizard.

I attached a sample file of two tables where that issue occurs.

TEST1.zip

bubibubi commented 7 years ago

There was a bug in not nullable columns retrieve. In your sample there is a table that does not have primary key so EF can't manage it. The other table should work fine in next release.

bubibubi commented 7 years ago

About views I think that SQL Server has the same issue. You need to have views with primary key and I think that Microsoft Access can't (or, at least, it doesn't return the information to OleDB about primary Keys defined on the views). Does SQL Server works with views without primary Keys (for example on a select with a group by)?

PS: Please check Preview on nuget to download the latest version