public void LoadSp_Northwind() { var spa = new SPLoader(Settings.Default.Northwind); var procs = spa.GetProcedures(); Assert.IsTrue(procs.Any()); }
public void LoadSp_Adventure() { var spa = new SPLoader(Settings.Default.AdventureWorks); var procs = spa.GetProcedures(); Assert.IsTrue(procs.Any()); }
public void LoadParams_individual_Adventure() { var spa = new SPLoader(Settings.Default.AdventureWorks); var procs = spa.GetProcedures().ToList(); foreach (var p in procs) { var result = spa.GetParameters(p); Assert.IsTrue(result != null); }; }
public void GetParams_individual_Northwind() { var spa = new SPLoader(Settings.Default.Northwind); var procs = spa.GetProcedures().ToList(); foreach(var p in procs) { var result = spa.GetParameters(p); Assert.IsTrue(result != null); }; }
public void LoadOutputStructure_Adventure() { var spa = new SPLoader(Settings.Default.AdventureWorks); var proc = spa.GetProcedures().Where(λ => λ.Name == "uspGetBillOfMaterials").Single(); //spa.LoadParameters(proc); //var cmd = new SqlCommand("uspGetBillOfMaterials"); //cmd.CommandType = System.Data.CommandType.StoredProcedure; var paramList = new Dictionary<string, string>(); paramList.Add("@StartProductID", "893"); paramList.Add("@CheckDate", "4/18/2004"); //cmd.Parameters.Add(new SqlParameter("@StartProductID", 893)); //cmd.Parameters.Add(new SqlParameter("@CheckDate", new DateTime(2004, 4, 18))); //spa.LoadOutputSchema(proc, paramDefs , paramValues); //TODO: MOCK OBJECT //Assert.IsTrue(proc.OutputData != null); //Assert.IsTrue(proc.OutputData.FirstOrDefault() != null); //Assert.IsTrue(proc.OutputData.First().Columns.Count() == 8); }