public void GetSchemaTable() { SqlConnection cn = new SqlConnection(CONNECTION_STRING); SqlCommand cm = cn.CreateCommand(); DataTable dtSchema = null; cm.CommandText = "SELECT * FROM MultiDataTypes"; cn.Open(); using (cm) { using (Csla.Data.SafeDataReader dr = new Csla.Data.SafeDataReader(cm.ExecuteReader())) { dtSchema = dr.GetSchemaTable(); dr.Close(); } } cn.Close(); Assert.AreEqual("BIGINTFIELD", dtSchema.Rows[0][0]); Assert.AreEqual(typeof(System.Int64), dtSchema.Rows[0][12]); Assert.AreEqual(typeof(System.Byte[]), dtSchema.Rows[1][12]); //Console.WriteLine(); //foreach (DataColumn c in dtSchema.Columns) //{ // Console.WriteLine(c.ColumnName); //} //Console.WriteLine(); //for (int i = 0; i < dtSchema.Rows.Count; i++) //{ // Console.WriteLine(dtSchema.Rows[i][0]); //} //Console.WriteLine(); //for (int i = 0; i < dtSchema.Rows.Count; i++) //{ // Console.WriteLine(dtSchema.Rows[i][12]); //} }
public void GetSchemaTable() { SqlConnection cn = new SqlConnection(CONNECTION_STRING); SqlCommand cm = cn.CreateCommand(); DataTable dtSchema = null; cm.CommandText = "SELECT * FROM MultiDataTypes"; cn.Open(); using (cm) { using (Csla.Data.SafeDataReader dr = new Csla.Data.SafeDataReader(cm.ExecuteReader())) { dtSchema = dr.GetSchemaTable(); dr.Close(); } } cn.Close(); Assert.AreEqual("BIGINTFIELD", dtSchema.Rows[0][0]); Assert.AreEqual(typeof(System.Int64), dtSchema.Rows[0][12]); Assert.AreEqual(typeof(System.Byte[]), dtSchema.Rows[1][12]); }
public void GetSchemaTable() { SqlConnection cn = new SqlConnection(CONNECTION_STRING); SqlCommand cm = cn.CreateCommand(); DataTable dtSchema = null; cm.CommandText = "SELECT * FROM MultiDataTypes"; cn.Open(); using (cm) { using (Csla.Data.SafeDataReader dr = new Csla.Data.SafeDataReader(cm.ExecuteReader())) { dtSchema = dr.GetSchemaTable(); dr.Close(); } } cn.Close(); Assert.AreEqual("BIGINTFIELD", dtSchema.Rows[0][0]); Assert.AreEqual(typeof(System.Int64), dtSchema.Rows[0][12]); Assert.AreEqual(typeof(System.Byte[]), dtSchema.Rows[1][12]); //Console.WriteLine(); //foreach (DataColumn c in dtSchema.Columns) //{ // Console.WriteLine(c.ColumnName); //} //Console.WriteLine(); //for (int i = 0; i < dtSchema.Rows.Count; i++) //{ // Console.WriteLine(dtSchema.Rows[i][0]); //} //Console.WriteLine(); //for (int i = 0; i < dtSchema.Rows.Count; i++) //{ // Console.WriteLine(dtSchema.Rows[i][12]); //} }