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