public void DataService_UpdateContentType_Updates_Record_On_Valid_ContentType()
        {
            //Arrange
            int rowCount = DataUtil.GetRecordCount(DataTestHelper.ConnectionString,
                                                   ContentDataTestHelper.ContentTypesTableName);
            DataUtil.AddDatabaseObject(virtualScriptFilePath, upateContentType);

            ContentType contentType = ContentTestHelper.CreateValidContentType();
            contentType.ContentTypeId = Constants.CONTENTTYPE_UpdateContentTypeId;
            contentType.ContentType = Constants.CONTENTTYPE_UpdateContentType;

            DataService ds = new DataService();

            //Act
            ds.UpdateContentType(contentType);

            //Assert
            using (SqlConnection connection = new SqlConnection(DataTestHelper.ConnectionString))
            {
                connection.Open();
                DatabaseAssert.RecordCountIsEqual(connection, ContentDataTestHelper.ContentTypesTableName, rowCount);

                //Check Values are updated
                IDataReader dataReader = DataUtil.GetRecordsByField(connection,
                                                                    ContentDataTestHelper.ContentTypesTableName,
                                                                    keyField,
                                                                    Constants.CONTENTTYPE_UpdateContentTypeId.ToString());
                while (dataReader.Read())
                {
                    DatabaseAssert.ReaderColumnIsEqual(dataReader, "ContentType",
                                                       Constants.CONTENTTYPE_UpdateContentType);
                }

                dataReader.Close();
            }
        }