JetEntityFrameworkProvider
JetEntityFrameworkProvider copied to clipboard
bubibubi
DbFirst not generating models for all tables
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.
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.
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