SqlServerDB_dotNET 1.0.0

SqlServerDB .NET

The SqlServerDB_dotNET Class Library is a high level wrapper around the SQLServer.

The library is currently compiled at .Net 4.0 so it should work with any application running .Net 4.0 and above.

Install-Package SqlServerDB_dotNET -Version 1.0.0
dotnet add package SqlServerDB_dotNET --version 1.0.0
<PackageReference Include="SqlServerDB_dotNET" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SqlServerDB_dotNET --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

The SqlServerDB_dotNET Class Library is a high level wrapper around the SqlServer.

Example:
using SqlServerDB;

string server = @"INSTANCE\SQLEXPRESS";
string database = "DEMODB";
string username = "sa";
string password = "";

string connectionString = @"Data Source="+ server + ";Initial Catalog="+ database + "; Trusted_Connection=True;User ID="+ username + ";Password="+ password + "";
DBConnection db_conn = new DBConnection(connectionString);

Console.WriteLine("isConnected: " + db_conn.isConnected());
if (db_conn == null || !db_conn.isConnected())
{
Console.WriteLine("Connessione non valida.");
return;
}

string sql = "SELECT ID, Message FROM Logs ORDER BY IDLic;";
DataTable dtLogs = db_conn.SelectTable(sql);

if (dtLogs == null || dtLogs.Rows.Count == 0)
return;

// Loop with the foreach keyword.
foreach (DataRow dr in dtLogs.Rows)
{
Console.WriteLine("Message: " + dr["Message"].ToString().Trim());
}

The SqlServerDB_dotNET Class Library is a high level wrapper around the SqlServer.

Example:
using SqlServerDB;

string server = @"INSTANCE\SQLEXPRESS";
string database = "DEMODB";
string username = "sa";
string password = "";

string connectionString = @"Data Source="+ server + ";Initial Catalog="+ database + "; Trusted_Connection=True;User ID="+ username + ";Password="+ password + "";
DBConnection db_conn = new DBConnection(connectionString);

Console.WriteLine("isConnected: " + db_conn.isConnected());
if (db_conn == null || !db_conn.isConnected())
{
Console.WriteLine("Connessione non valida.");
return;
}

string sql = "SELECT ID, Message FROM Logs ORDER BY IDLic;";
DataTable dtLogs = db_conn.SelectTable(sql);

if (dtLogs == null || dtLogs.Rows.Count == 0)
return;

// Loop with the foreach keyword.
foreach (DataRow dr in dtLogs.Rows)
{
Console.WriteLine("Message: " + dr["Message"].ToString().Trim());
}

Release Notes

Extensions on the SqlServerDB .NetFramework.

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
1.0.0 126 12/8/2018