I want to add an "Entity Data Model" in data sources in a new project.
When I click "add new data source" the Data Source Configuration Wizard window will pop-up and will let me choose a data source type, the problem is the "Entity Data Model" is not in the list, only the database, service, project, and sharepoint is in the list.
What should I do?
What I have tried:
I tried nothing cause i dont know what to do.
解决方案Entity Data Model is not a Data Source in that respect.
If I get what you mean (and please correct me if I'm wrong) you first need to add an empty data model to your solution.
On the project, add new item, select data then choose the data model type. I use T-SQL (MSSQL) so I find "Linq to SQL Classes" easiest to use.
I also integrate a MySQL database. I use the EF 5.x DBContect Generator. It's buggy as all hell but gets the job done. You will need to have already installed the MySQL connectors and add the Entity Frameworks via NuGet.
Using the Linq to SQL is easy, in Server Explorer, create a db connection. Explore the database via the Server Explorer, select any tables, views, procs you want and drag-drop them onto your blank dbml. It'll work out all the classes and releationships for you.
The EF approach allows to to code first and produce a database and vise-versa