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; } }