Click here to Skip to main content
15,860,844 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted
Updated 8-Mar-17 23:34pm

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900