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?

Answers


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.


Need Your Help

Is it possible to connect an Access form to a SQL Server view

sql-server ms-access

I'm migrating an Access DB to SQL Server and everything is slowly coming along but Im not sure how to connect the Access forms to the SQL Server views.

Back to top link on mobile site doesn't work on android

jquery android html mobile jquery-mobile

I have an interesting question. I'm building a web site geared towards mobile devices (please not this is not a question regarding mobile web apps, it's a plain HTML / CSS / javascript website).