There is two database name inside sql text entity framework

Question

I have only 1 Model and database in the solution. When I try the execute simple query like

var list=Db.table.ToList();

Give an error like

table 'dbname.dbname.table' doesn't exist

Why not dbname.table but dbname.dbname.table? I have using mysql 8.0.22 and compatible ef

Have you set the schema to dbname somewhere in your entity model builder? Schema in .net is not the same as schema in MySql. In .net, postgres and mssql it is meant as a sort of namespace. In MySql a schema often refers to the db name. So it is not the same. — Silvermind
– Silvermind, Commented Nov 3, 2020 at 10:15
Does this answer your question? Table 'DBNAME.dbo.TableNAME' doesn't exist Entity Framework 6 with MySQL — Morteza Asadi
– Morteza Asadi, Commented Nov 3, 2020 at 10:29
@MuratSaygılı I'll repeat my question :) : Have you set a schema somewhere in your modelbuilder? — Silvermind
– Silvermind, Commented Nov 3, 2020 at 11:56

Murat Saygılı · Accepted Answer · 2020-11-17 13:14:54Z

0

Install MySQL Server 8.0.16
Install Complete MySQL Connector.Net x86 8.0.16
Install this custom repacked VSIX MySQL Visual Studio
If after installing MySQL Visual Studio Plugin it shows warning that failed to execute comamnd devenv /updateconfiguration, then manually execute that command in Developer Command Prompt for Visual Studio 20xx with run as administrator.
Run this command Install-Package EntityFramework in Visual Studio Nuget package manager console
Manage Nuget Packages > Search Mysql > install Mysql.Data v8.0.16
Manage Nuget Packages > Search Mysql > install Mysql.Data.Entity v6.10.8
Manage Nuget Packages > Search Mysql.Data.EntityFramework > install Mysql.Data.EntityFramework v8.0.16

answered Nov 17, 2020 at 13:14

Murat Saygılı

219 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1