private static void TestWcfConnection(string connectionString)
{
var connection = new WcfConnection
{
ConnectionString = connectionString,
IntegratedSecurity = true
};
var command = connection.CreateCommand();
command.CommandText = "GetData";
var wcfCommandParameters = command.Parameters.OfType <WcfCommandParameter>();
//wcfCommandParameters.Single(p => p.ParameterName == "reportDate").Value = new DateTime(2014, 8, 8);
//wcfCommandParameters.Single(p => p.ParameterName == "majorScenarioTriggerLevel").Value = 10;
//wcfCommandParameters.Single(p => p.ParameterName == "minorScenarioTriggerLevel").Value = 85;
var reader = command.ExecuteReader(CommandBehavior.SchemaOnly);
Console.WriteLine("Found " + reader.FieldCount + " fields");
for (var i = 0; i < reader.FieldCount; i++)
{
Console.WriteLine("\t" + reader.GetName(i) + " => " + reader.GetFieldType(i).Name);
}
while (reader.Read())
{
Console.WriteLine("line!");
}
}
