public static void TestGetReaderProperty() { try { myConnection.Open(); SqlCommand cmd = new SqlCommand("select * from sys.tables"); cmd.Connection = myConnection; var reader = cmd.ExecuteReader(); var helper = new SqlDataHelper(reader); foreach (var prop in myConnection.GetType().GetProperties()) { Console.WriteLine(helper.GetReaderProperty(prop.Name)); } } catch (Exception e) { Console.WriteLine(e.ToString()); } finally { myConnection.Close(); } Console.ReadLine(); }
static void Main(string[] args) { myConnection.Open(); SqlDataReader myReader = null; var query = "SELECT * " + "FROM TABLE_BUG"; SqlCommand myCommand = new SqlCommand(query, myConnection); myReader = myCommand.ExecuteReader(); helper = new SqlDataHelper(myReader); var result = helper.Fetch(20); helper.GetReaderProperty("Fetched"); Console.ReadLine(); }
public static void TestGetReaderProperty() { try { myConnection.Open(); SqlCommand cmd = new SqlCommand("select * from sys.tables"); cmd.Connection = myConnection; var reader = cmd.ExecuteReader(); var helper = new SqlDataHelper(reader); foreach (var prop in myConnection.GetType().GetProperties()) Console.WriteLine(helper.GetReaderProperty( prop.Name)); } catch (Exception e) { Console.WriteLine(e.ToString()); } finally { myConnection.Close(); } Console.ReadLine(); }
static void Main(string[] args) { myConnection.Open(); SqlDataReader myReader = null; var helper = new SqlDataHelper(); var state = helper.GetConnectionProperty(myConnection, "State"); var query = "SELECT * " + "FROM TABLE_BUG"; SqlCommand myCommand = new SqlCommand(query, myConnection); myReader = myCommand.ExecuteReader(); helper = new SqlDataHelper(myReader); var result = helper.Fetch(20); helper.GetReaderProperty("Fetched"); Console.ReadLine(); }