Set of tools which will improve your productivity when working with database to completely new levels. Allow to easily browse and update data directly from visual studio. It is also integrated with data generator and missing foreign key analyzer.
Set of tools which will improve your productivity when working with database to completely new levels. Allow to easily browse and update data directly from visual studio. It is also integrated with data generator.
More information with examples on www.Netverest.com
There is almost nothing to configure only connection string, for more advanced scenarios with entity framework mappings please check out Getting Started page
Below you can find only few of over 80 available features!
All of them are FREE! If those tools are helpful for you then donate this product and get rid of adds, so I will be able to develop new features faster.
Query/Update/Sort/Filter/Group data directly from Visual Studio
Database search & insight
Enums support & inline update
Use cases
How often do you perform 'SELECT *' or 'COUNT()' on a table? Now it is much faster then ever, both queries are executed in the same time all you need to do is enter table name, you also don't need to switch to sql server management studio, it is possible directly from Visual Studio.
Are you tired of writting long queries with multiple joins? You can click on foreign key icon and join will be performed for you, it can not be easier!
Your entity framework class is mapped to different table name? Nothing easier you can search by class or table name.
Your database is missing foreign keys? Just run missing key analyzer and create them.
Do you want to know something more about your database? You can easily check which table is the biggest, has the most columns, indexes, foreign keys etc. All of this gives you amazing insight into your database structure
If you are debugging and you need to check data stored for variable? You don't need to copy Id value to SSMS, you can get select statement with where condition on primary key column with one click.
Your tables contain columns like 'StatusId' which are mapped to enums in entity framework? Thanks to our entity framework class mappers you will see also enum value in your results, no more wondering what this number means.
If You need to test performance of your app or databse? Just download Data Generator and create millions of records in minutes!
If in code there is a magic number from table like 'Statuses' and you are not sure what it means? Just type ctrl+D+S on this type and you will get all values from this table without leaving visual studio.
You can check definition of database view or stored proccedure directly from code! Without switching to SSMS
What's your role?
Senior back-end developer or junior tester - It doesn't matter, it makes data querying always much easier and faster.
Team Lead or Project Manager - Help your team be more productive by providing them with those tools.
Developer - You don't have to switch to SSMS for every query. It is most of the time much faster to do this directly from Visual Studio.
Tester - You don't need to know SQL commands for inserting data or performing queries, you can easily create lots of data with Data Generator to start performance testing or use our tools to easily query databse.
New in project - Using missing indexes information you can shine :) in your new job.
Are you responsible for systems integrations and you don't know your client database schema? Use Database Insights to get better picture of new database.
If you don't feel comfortable when working with SQL? Because:
You have just started your journey with programming
You prefer front-end development
You have worked with different database
Then those tools are for you because you don't need to remember full syntax of SQL:
If you want to sort results by column - Just click on header
-If you want to group data - Just click on header when pressing 'Alt' key
-If you want to filter data - Just type what you need, you don't need to remember about keywords such as 'LIKE' or 'IS NOT NULL' etc.
This is newer version of older version of NetverestTools, however I've lost my email and I can't update my previous account.
Change Log
Version 2.0 - 01.06.2020
Changed config file - BREAKING CHANGE(previous config will be deleted and won't work)
Added support for multiple databases and servers !!
DataGenerator(beta version) integrated into extension
'Select' works by naming convention, if EfContext not loaded
Added cache for databases - improves loading performance
Added 'Navigation' feature
Added conditional delete
Added batch update
Added 'MostOftenUsedFile' feature
Added Index indicator on SelectView results grid and Index info on SelectView
Trigger information on SelectView
Option to select PK descending by default
More commands attached to CTRL+D+S shortcut(other commands still works, but you can use this one shortcut for more operations):
Procedure definition if table not found
Select with where condition when debugging
Redesigned Configuration window - simplified and more user friendly
New VS menu with commands(few of them moved from context menu)
More things are loaded async
Background refresh of databases
Improvements to SelectView searching and filtering
Extension moved from old visual studio Package base class to AsyncPackage(required in newer versions of VS2019)
User Experience improvements:
DbInfoView - Enter on any row opens SelectView
SelectView - Auto focus on colum filter, to easily search for column when opening view.
SelectView - Added key navigation on column filters like up/down arrows, tab, enter
Performance improvements in almost all areas:
Loading extension
Db Search
Select View - improved rendering
Navigation endings
General improvents and bug fixes
Version 1.3.2.0 - 02.04.2019
Added support for VS 2019
Version 1.3.1.0 - 31.03.2019
Suggested tables(tables which might be related with other table, but fk is missing)
Related tables search
Query generation improvements
Version 1.3.0.0 - 03.01.2019
Added preview support for EF CORE!
Added database size info
Added connection string support from appsettings.json
Version 1.2.1.0 - 01.11.2018
Added 'Generate properties' feature
Version 1.2.0.0 - 12.10.2018
Progress and error info for 'Refresh counts'
Added 'Foreign Key preview' feature
Performance improvements
Version 1.1.1.0 - 05.08.2018
Added handling for 'Unmodeled' visual studio projects
Added navigation to database view from other views like: select, definition, delete
Added 'AutoExecute' on 'Clear Filters' button click
Version 1.1.0.2 - 31.07.2018
Column size on database info view is fixed now
Added tooltips for environment buttons
(BUG) Fixed culture related issue with range filtering on number columns
Version 1.1.0.1 - 30.07.2018
Better exception handling for AggregateException
Version 1.1.0.0 - 29.07.2018
Added colors for keywords in definitions of database view and stored procedure(registered user)
Added Table & Index estimated size and read/write useage
Added warning for manually edited queries
Telemetry - more info on error like: Operating system, App version...
(BUG)Fixed always disabled 'Use Count' option on configuration window
(BUG)Fixed crash of VS on 'Delete' action(rare cases)
(BUG)Fixed issue with visible temp tables in database info view
