CODEWITHSUNDEEP
mysqlsql-servervisual-studiovisual-studio-2010entity-framework
John B
John B

Reputation: 20380

Can you query SQL Server directly from the Entity Framework Designer?

When you're inside Visual Studio you can use the Server Explorer to add a Data Connection. Once you've added the data connection you can browse the schema, execute queries, etc.

Another developer mentioned that EF might have this functionality. With the EF designer, you would already have a connection setup and even have the list of tables mapped as well. It would be great to right click on a model in the designer and view the data, or execute queries.

This would allow a user to open a solution and instantly (well almost) view the data being used, whereas right now you would need to add the connection to the Server Explorer (again).

Does anything like this exist, either in Visual Studio, NuGet Package, Service Pack, Tools Update, or even an extension?

Upvotes: 1

Views: 113

Answers (1)

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364279

Not in Visual Studio but as separate tool called LINQPad.

Edit:

If you create EDMX model through the Wizard it will create connection for you in Server explorer but this connection is VS feature. It has nothing to do with Entity designer which works just with connection string.

Upvotes: 2

Related Questions