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();
}
}
public void Func1()
{
try
{
SqlDataBaseConnector con1 = new SqlDataBaseConnector();
var st1 = con1.ConnectToFile(
@"C:\DatabaseComparer-Asp-ASP.NET-Core-2.0-\TestDatabases\sakila.mdf");
var l11 = con1.GetTablesList();
l11.Sort();
SQLiteDatabaseConnector con2 = new SQLiteDatabaseConnector();
var st2 = con2.ConnectToFile(
@"C:\DatabaseComparer-Asp-ASP.NET-Core-2.0-\TestDatabases\sakila.db");
var l21 = con2.GetTablesList();
l21.Sort();
List <dynamic> list = new List <dynamic>();
for (int j = 0; j < l11.Count; j++)
{
con1.SelectedColumns.Clear();
con2.SelectedColumns.Clear();
var l12 = con1.GetTableInfo(l11[j]);
foreach (var item in con1.TableColumns)
{
con1.SelectedColumns.Add(item);
}
con1.SelectedTable = l11[j];
var l1 = con1.Read(con1.BuildSelectQuery(), con1.FullStringArraySelector);
string[] selected = new string[l1.Count];
for (int i = 0; i < l1.Count; i++)
{
selected[i] = i.ToString();
}
var l3 = String.Join("", con1.BuildInsert(l1, selected));
list.Add(new { Name = $"{l11[j]}", Data = l3 });
}
Console.WriteLine(1);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
