static void Connect()
{
var sqlRest = new SqlRest();
var result = sqlRest.Connect();
Console.WriteLine("Message: " + result.Message);
}
static void Ping()
{
var sqlRest = new SqlRest();
var result = sqlRest.Ping();
Console.WriteLine(result);
}
static void Query()
{
var sqlRest = new SqlRest();
var query = new QueryRequest
{
Query = "SELECT TOP 3 * FROM Flights.dbo.Airlines"
};
var results = sqlRest.Query(query).Result;
WriteResults(results);
}
static void Procedure()
{
var sqlRest = new SqlRest();
var req = new ProcedureRequest
{
Name = "Flights.dbo.AirportsByAirline",
Parameters = JObject.FromObject(new { airlineId = 109 }),
ExecuteOnly = false
};
var results = sqlRest.Procedure(req).Result;
WriteResults(results);
}
