SDO_dotNET 1.2.0

private static void TestMySql() { /****************************************************************** * MySQL *******************************************************************/

string server = "localhost";
string database = "DEMODB";
string username = "root";
string password = "";

string connectionString = @"Data Source=" + server + "; Database=" + database + "; User ID=" + username + "; Password=" + password + ";";

//SDO db_conn = new SDO(connectionString);
SDO db_conn = new SDO(new MySqlConnection(connectionString));

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

string sql;
sql = "SELECT name, surname, email FROM users " +
	  "ORDER BY name;";
DataTable dtUsers = db_conn.SelectTable(sql);

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

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

}

private static void TestSqlServer() { /****************************************************************** * Sql Server *******************************************************************/

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 + ";Connect Timeout=60";

//SDO db_conn = new SDO(connectionString);
SDO db_conn = new SDO(new SqlConnection(connectionString));

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

string sql = "SELECT TOP 10 ID, Message FROM Log4NetLog 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());
}

}

private static void TestSQLite() { /****************************************************************** * SQLite *******************************************************************/

string database = @"C:\Users\Utente\mydb.sqlite";

string connectionString = @"Data Source=" + database + "; Version=3; New=True; Compress=True;"; // local
SDO db_conn = new SDO(connectionString);

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

string sql = "SELECT firstname, surname FROM users ORDER BY firstname;";
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("Name: " + dr["firstname"].ToString().Trim() + " " + dr["surname"].ToString().Trim());
}

}