public void SQLConnectionTest()
{
try
{
Database db = new SqlDataBaseConnector();
if (db.ConnectToFile(@"D:\GitHub\Database_Comaparer\DatabaseComparer-Asp-ASP.NET-Core-2.0-\TestDatabases\sakila.mdf"))
{
var l2 = db.GetTablesList();
Assert.IsNotNull(l2);
DataTable dtMaths = new DataTable("Maths");
dtMaths.Columns.Add("StudID", typeof(int));
dtMaths.Columns.Add("StudName", typeof(string));
Func <IDataRecord, string[]> select = delegate(IDataRecord s)
{
return(new string[] { s[0].ToString(), s[1].ToString() });
};
var l3 = db.GetTableInfo(l2[3]);
Assert.IsNotNull(l3);
sw = new Stopwatch();
sw.Start();
var l4 = db.Read("Select * from " + l2[17], select);
sw.Stop();
var time = sw.Elapsed;
Assert.IsNotNull(l4);
db.CloseConnection();
}
}
catch (Exception e)
{
Console.WriteLine(e);
Assert.Fail();
}
}
public void RemoteSQLServerConnectionTest()
{
try
{
SqlDataBaseConnector db = new SqlDataBaseConnector();
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("port", "1433");
param.Add("ip", "192.168.0.100");
param.Add("user", "Vasyl");
param.Add("pass", "12345");
var a = db.RemoteConnection(param);
var l1 = db.GetDatabasesList();
var l2 = db.GetTablesList(l1[3]);
Assert.IsNotNull(l2);
Func <IDataRecord, string[]> select = delegate(IDataRecord s)
{
return(new string[] { s[0].ToString(), s[1].ToString() });
};
var l3 = db.GetTableInfo(l2[0]);
Assert.IsNotNull(l3);
sw = new Stopwatch();
sw.Start();
var l4 = db.Read("Select * from " + l2[0], select);
sw.Stop();
var time = sw.Elapsed;
Assert.IsNotNull(l4);
db.CloseConnection();
}
catch (Exception e)
{
Console.WriteLine(e);
Assert.Fail();
}
}
