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

CapsLock, NumLock, Insert, how to show keyboard status on screen when keyboard has no LED

linux keyboard

When keyboard has no LED, for Linux machine, is there an easy way to do this? By Command Line, Python, Perl or Ruby, to show when keyboard has CapLock, NumLock activated?

Using different Web.config in development and production environment

asp.net visual-studio configuration web-config

I need to use different database connection string and SMTP server address in my ASP.NET application depending on it is run in development or production environment.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.