EF Core 3 With Pomelo MySQL Provider Does Not Scaffold Views

[hakankurcenlivivense]

According to the following link, EF Core 3 supports reverse engineering views:
https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-3.0/

And according to these links, there isn't yet a MySQL provider for EF Core 3:
dotnet/efcore#17556
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core.html

So, I used the Pomelo provider version 3.0.0-rc1.final to scaffold:

Scaffold-DbContext "server=server;user=user;password=password;database=database" "Pomelo.EntityFrameworkCore.MySql" -OutputDir EF -f

But scaffolding did not create the views. Are you also experiencing this issue or is this something related to my configuration?

[baronics]

Just tried Pomelo provider version 3.0.0-rc1.final to scaffold my simple MySQL 8.0.17 database with 9 tables using .NET Core 3.0, VS2019 16.3.3 and it worked without any issues. I used the same Scaffold-DbContext command from the above comment. However, I have no views in my DB.

[MKI-Miro]

seem like my project is using mysql.data client even if i dont have reference to it anymore

at System.Data.Common.DbDataReader.GetFieldValue[T](Int32 ordinal) at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue[T](Int32 ordinal) in C:\projects\mysqlconnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlDataReader.cs:line 303 at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.QueryingEnumerable1.Enumerator.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

[baronics]

My test project:
<Project Sdk="Microsoft.NET.Sdk"> <PropertyGroup> <OutputType>Exe</OutputType> <TargetFramework>netcoreapp3.0</TargetFramework> </PropertyGroup> <ItemGroup> <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="3.0.0"> <PrivateAssets>all</PrivateAssets> <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets> </PackageReference> <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="3.0.0"> <PrivateAssets>all</PrivateAssets> <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets> </PackageReference> <PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="3.0.0-rc1.final" /> </ItemGroup> </Project>

[bgrainger]

seem like my project is using mysql.data client even if i dont have reference to it anymore

at System.Data.Common.DbDataReader.GetFieldValue[T](Int32 ordinal) at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue[T](Int32 ordinal) in C:\projects\ mysqlconnector \src\ MySqlConnector \MySql.Data.MySqlClient\MySqlDataReader.cs:line 303 at

No, you are using the underlying MySqlConnector library.

[yukozh]

https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/blob/master/src/EFCore.MySql/Scaffolding/Internal/MySqlDatabaseModelFactory.cs#L167-L174

Pomelo is using the information_schema to get the tables info, in this way, only real existed tables could be scaffolded, so the view is not working currently. And when I implement the scaffolding for Pomelo, the no key tables were not supported. Pomelo is a third party provider, it means some features are not aligned to the announcement which published by Microsoft. But we are going to align the features soon.

[MKI-Miro]

I dont have any view, I only have tables

[lauxjpn]

@hakankurcenlivivense Pomelo does support views in general. It seems though, that this has not yet been implemented for scaffolding an existing database, as the following SQL is used to query the tables only but not the views:

Pomelo.EntityFrameworkCore.MySql/src/EFCore.MySql/Scaffolding/Internal/MySqlDatabaseModelFactory.cs

Line 81 in 49cac2e

private const string GetTablesQuery = @"SHOW FULL TABLES WHERE TABLE_TYPE = 'BASE TABLE'";

I will implement this for 3.0.0-rc2 or do you want to do it @yukozh?

[lauxjpn]

@MKI-Miro, @baronics
Is your discussion actually related to the topic? If you are discussing a separate issue, please open a new one. Or are you discussing #866?

[MKI-Miro]

I am sory I thought I reply to #866

[lauxjpn]

@MKI-Miro No worries. I copied your discussion over to #866 as best as I could and will hide it in this issues here.

[lauxjpn]

Scaffolding views from existing databases has been added now with #896.