Projects - Raja Venkatesh

Projects

By downloading the tools below you accept to use ClickOnce applications developed by Raja Venkatesh.

That means, although you are free to use, you require to accept online updates if available.

In case your computer does not have internet access beyond accepted period, the application may stop working. Please do not forget to give your feedback.

DatatoolLInQ Visualizer-VS2008LInQ Visualizer-VS2010 Any DB Connection Visualizer

Download	Release	Version	Description
Install	26-Oct-2010	2.5.1.0	1. Support for generic LInQ added. 2. Generate EDMX for your database (Any database) added. 3. Native query parameters stabilized. 4. Properties for results/connection added. 5. Verify button brings only connectable data providers. User could select appropriate provider to connect which ever has better performance.
	29-Jun-2010	2.1.0.4	1. Background prefetch error while loading Views for non SQL servers resolved. 2. Error while mulitiple SQL seperated with ";" (semicolon) resolved. 3. Added option to view multiple result tables via tables in combo box. 4. Added option to show number or rows, columns.
	26-Jun-2010	2.1	1. No COM dependency in creating connection strings. 2. Option to save connection string for reuse. 3. F5 key support to execute selected SQL. 4. Intellisense for table and view names. 5. Option to export result data as Excel. You may save result XML as XLSX after opening in MS Excel directly. 6. Support query parameter editing. 7. Added LInQ generation option but incomplete. 8. Double click on each cell of result data to view details where you could (1) Copy a cell value and (2) View cell value using different windows UI controls.
	03-Sep-2009	1.2	1. GetProviders() ==> Lists all providers in your local PC Note: My ISP has to support frontpage extensions only after which Application Identity error (while clicking Help) can be addressed.
	08-May-2009	1.1	1. Permission issues solved. 2. Query processing time issue solved. 3. Logging / Trace feature added.
	03-May-2009	1.0	Data Tool - To query data from any datasource //~Connect to any database/datasource as far as you have connection string~// Sample usage: 1. getschema() 2. getschema("Tables"), getschema("Views") 3. select * from mytable 4. call mystoredprocedure("param1", "param2")

Download	Release	Version	Description
Download for VS2008 How to use?	03-Sep-2009	1.0	RV's LInQ to Entity debug Visualizer for Visual Studio 2008 1. Download the DLL into "C:\Program Files\Microsoft Visual Studio 9.0\Common7\Packages\Debugger\Visualizers" or equivalent in your PC. 2. Create edmx file in your VS solution for any database you use. [For Db2 use client provider version 9.7 and above] 3. In debug mode, execute a LInQ query in IDE. Post execution hover over the resultant object to find the down arrow near magnifier glass to see "RV's LInQ to Entity Visualizer". You have to click "Execute" button in appearing window to see results. You have to close the result window to see the query execution log. 4. The first time clicking "Execute" button may take little more time than normal (5-20 seconds). Please be patient.

Download	Release	Version	Description
Download for VS2010 How to use?	27-Aug-2010	3.2.0.1	1. WPF version seamlessly syncs with Visual Studio 2010. Click here for non WPF version in case you require. 2. Manage (Add/Edit/Remove) query parameters. Parameter types depend on datasource - datatypes. This is optional to select. 3. If native SQL is modified, Lamda expression stays original. You must click "Save SQL" in order to execute modified SQL. 4. Adjust the size of Expression, Native SQL, Parameter area, Execution log, and Connection property using splitter. 5. If your Visual Studio 2010 hangs, use this single thread version (3.2.0.2) . Note: WPF property grid taken from www.codeplex.com [WPG C# code modified to handle error caused while fetching server info when DB connection is in closed state]
	26-Jun-2010	2.1.5	1. Export to Excel bug resolved. 2. Support for Unicode in Export to Excel. 3. Query result displays number of rows and columns.
	25-May-2010	2.1.4	1. Crash due to unavailability of .NET 3.5 SP1 due to direct installation of .NET 4.0 solved. 2. Option to export viewed query result to Excel/XML added.
	08-May-2010	2.1.3	RV's LInQ to Entity debug Visualizer for Visual Studio 2010 * A similar version compared to earlier one. Next version to have 1. Option to support parameters in SQL. 2. Have "RV's SQL to LInQ query" visualizer. This option will help you visualize your native SQL (of any datasource) as LInQ query. Under testing for various datasources.

Download	Release	Version	Description
Download How to use?	09-Apr-2011	1.0	RV's Any DB Connection Visualizer 1. Download the ZIP and extract the two files into "C:\Program Files\Microsoft Visual Studio 9.0\Common7\Packages\Debugger\Visualizers" or equivalent in your PC. 2. Use any ADO connection object and initialize it. 3. In debug mode, step over your ADO connection object. Hover over the connection object to find the down arrow near magnifier glass to see "RV's DB Connection Visualizer".