Example #1
0
 public void GetFieldTypesFromView()
 {
     var ana = new SqlAnalyzer(connStr);
     var fields = ana.GetFieldTypes("ID_NUMView");
     Assert.AreEqual("([Age,int NULL],[FirstName,nvarchar(50) NULL],[ID_NUM,int NOT NULL],[LastName,nvarchar(50) NULL],[PersonId,int NOT NULL])",
         fields.Print());
 }
Example #2
0
 public void GetFieldTypes()
 {
     var ana = new SqlAnalyzer(Config.TestDBConnectionString);
     var fields = ana.GetFieldTypes("Person");
     Assert.AreEqual("([Age,int NULL],[FirstName,nvarchar(50) NULL],[LastName,nvarchar(50) NULL],[PersonId,int NOT NULL])",
         fields.Print());
 }