public void ExecuteDataReader_ByTextAndType() { // arrange string sql = "SELECT TOP 1 * FROM clarity.dbo.PATIENT"; string database = "CLARITY"; GHCDataAccessLayer dataAccess = GHCDataAccessLayerFactory.GetDataAccessLayer(DataProviderType.Sql, database); // act DbDataReader dr = (DbDataReader)dataAccess.ExecuteDataReader(sql, CommandType.Text); // assert Assert.IsTrue(dr.HasRows, "0 rows returned, 1 expected"); }
public void ExecuteDataReader_ByTextAndParams() { // arrange string sql = "SELECT TOP 1 * FROM clarity.dbo.PATIENT WHERE City = @City"; string database = "CLARITY"; SqlParameter[] sqlParams = { new SqlParameter("@City", SqlDbType.VarChar) { Value = "MADISON" } }; GHCDataAccessLayer dataAccess = GHCDataAccessLayerFactory.GetDataAccessLayer(DataProviderType.Sql, database); // act DbDataReader dr = (DbDataReader)dataAccess.ExecuteDataReader(sql, sqlParams); // assert Assert.IsTrue(dr.HasRows, "0 rows returned, 1 expected"); }