public void TestQueryWithCommandCreators() { IDbCommandCreatorFactory ccf = new IDbCommandCreatorFactory(adoTemplate.DbProvider, CommandType.Text, "select TestObjectNo, Age, Name from TestObjects", null); IDbCommandCreator cc = ccf.NewDbCommandCreator(null); IList <TestObject> testObjects = adoTemplate.QueryWithCommandCreator(cc, new TestObjectResultSetExtractor <List <TestObject> >()); Assert.IsNotNull(testObjects); Assert.AreEqual(2, testObjects.Count); foreach (TestObject o in testObjects) { Console.WriteLine(o); } }
protected virtual IDictionary QueryByNamedParam(IDictionary inParams) { ValidateNamedParameters(inParams); return(AdoTemplate.QueryWithCommandCreator(NewCommandCreator(inParams), resultProcessors)); }
protected virtual IDictionary Query(params object[] inParameterValues) { ValidateParameters(inParameterValues); return(AdoTemplate.QueryWithCommandCreator(NewCommandCreatorWithParamValues(inParameterValues), resultProcessors)); }