public void ExecuteQuery_ByTextAndType() { // arrange string sql = "UPDATE fw.dbo.DIMENSION SET ATTR_DESCRIPTION = ATTR_DESCRIPTION WHERE ATTR_NAME = 'UTGDA'"; string database = "CLARITY"; int expected = 1; GHCDataAccessLayer dataAccess = GHCDataAccessLayerFactory.GetDataAccessLayer(DataProviderType.Sql, database); // act int actual = dataAccess.ExecuteQuery(sql, CommandType.Text); // assert Assert.AreEqual(actual, expected, "Unexpected count of affected records"); }
public int TestQueryResultCount() { string sql = "quotingengine.dbo.TEST_PROC"; SqlParameter[] sqlParams = { new SqlParameter("@NAME", SqlDbType.VarChar) { Value = "Josh" }, new SqlParameter("@IMPORT_DATE", SqlDbType.DateTime) { Value = DateTime.Now } }; return(dataLayer.ExecuteQuery(sql, CommandType.StoredProcedure, 0, sqlParams)); }
public void ExecuteQuery_ByTextAndParams() { // arrange string sql = "UPDATE fw.dbo.DIMENSION SET ATTR_DESCRIPTION = ATTR_DESCRIPTION WHERE ATTR_NAME = @Name"; string database = "CLARITY"; int expected = 1; SqlParameter[] sqlParams = { new SqlParameter("@Name", SqlDbType.VarChar) { Value = "UTGDA" } }; GHCDataAccessLayer dataAccess = GHCDataAccessLayerFactory.GetDataAccessLayer(DataProviderType.Sql, database); // act int actual = dataAccess.ExecuteQuery(sql, sqlParams); // assert Assert.AreEqual(actual, expected, "Unexpected count of affected records"); }