private static void PerformPing() { Console.WriteLine("In PerformPing() method."); using (Client service = new Client()) { AssemblyName exe = Assembly.GetExecutingAssembly().GetName(); Console.WriteLine(exe.Name + ", Version=" + exe.Version); Console.WriteLine("Endpoint Name: " + service.EndpointName); Console.WriteLine("Endpoint Address: " + service.EndpointAddress); Console.WriteLine("Ping:"); try { AgentPingResponse response = service.Ping(); if (response != null) { Console.WriteLine(" Timestamp: " + response.Timestamp.ToString()); Console.WriteLine(" Server Instance: " + response.ServerInstance); Console.WriteLine(" Version: " + response.Version); Console.WriteLine(" Edition: " + response.Edition); Console.WriteLine(" Database: " + response.Database); Console.WriteLine(" User: "******" <no data returned>"); } } catch (Exception ex) { Console.WriteLine("Ping failed." + Environment.NewLine + ex.ToString()); } } }
private void DoPing(Client client) { AgentPingResponse resp = client.Ping(); DatabaseConnection db = new DatabaseConnection(AppSettings.GetString("AgentTemplateDbConnectionString")); Assert.AreEqual(resp.Database, db["Database"]); }
public void PingTest_InputDBConnectionString_IsDBConnectionCorrect() { Service x = new Service(); AgentPingResponse resp = x.Ping(); DatabaseConnection db = new DatabaseConnection(AppSettings.GetString("AgentTemplateDbConnectionString")); Assert.AreEqual(resp.Database, db["Database"]); }
private AgentPingResponse DoPing() { using (DatabaseRequest db = new DatabaseRequest(_Db, "PingGetDatabaseInfo")) { using (SqlDataReader reader = db.ExecuteSingleReader()) { AgentPingResponse response = new AgentPingResponse(); reader.Read(); if (!reader.IsDBNull(0)) { response.Timestamp = reader.GetDateTime(0); } if (!reader.IsDBNull(1)) { response.ServerInstance = reader.GetString(1); } if (!reader.IsDBNull(2)) { response.Version = reader.GetString(2); } if (!reader.IsDBNull(3)) { response.Edition = reader.GetString(3); } if (!reader.IsDBNull(4)) { response.Database = reader.GetString(4); } if (!reader.IsDBNull(5)) { response.User = reader.GetString(5); } return(response); } } }