DataVista

DataVista is a .NET library for:

• Database interactions - System.Data.SqlClient (ADO.NET)
• System management utilities - System.Management (WMI)
• WPF

NuGet package

• nuget.org/packages/DataVista

Prerequisites

• .NET 8.0
• System.Data.SqlClient
• System.Management

Quick Start

1. Add the NuGet package to your project

Install NuGet client tools

2. Setting up the App.config file (for database interactions)

Add an application configuration file to a C# project

Configure this string for what suits your needs.

<?xml  version="1.0"  encoding="utf-8" ?>
<configuration>
 <configSections>
 </configSections>
 <connectionStrings>
 <add  name="MyConnectionString"
  connectionString="Data Source=MyServerName;
 Initial Catalog=MyDataBaseName;
 Integrated Security=True;
 Persist Security Info=False;
 Pooling=True;
 MultipleActiveResultSets=True;
 TrustServerCertificate=True"/>
 </connectionStrings>
</configuration>

This step is optional because you could always use DataVista.Connection.CreateConnectionString().

Or you could use the SqlConnectionStringBuilder Class.

3. Add the namespace using statement to your .cs file.

Namespace

graph LR;
	Core --> ExceptionHandler.cs
	Core --> ExtensionMethods.cs
	Core --> MemoryUtil.cs
	
	DVC.dll --C library--- MemoryUtil.cs
	
	Database --> Operation.cs
	Database --> DataConverter.cs
	Database --> Connection.cs
 
	SQL[(Database)] -.-> Connection.cs	
 
	SystemTools --> Framerate.cs
	SystemTools --> Hardware.cs
	SystemTools --> WinPath.cs
	SystemTools --> WinProcess.cs

4. To use methods from DataVista.External, add the DLL file(s) (optional)

Step 1

Go into your solution explorer and select "Show All Files" or open the folder local to your solution.

Step 2

Add the DLL file(s) manually, directly to the /bin/Debug/ and */bin/Release/ folders.

OR

Add the DLL anywhere in the project. Open up the DLL file properties and set the "Copy to Output Directory" property to "Copy always" or "Copy if newer".

Note

Make sure to keep the DLL file(s) up to date.

Docs

• Example application
• Code example
• Class diagrams

Important

Connection(SqlConnection sqlConnection) constructor will read the connectionString from your App.config file.