c# - Cascading with Castle ActiveRecord HasAndBelongsToMany's -


I have trouble does not get a lot of wide using Castle ActiveRecord / NHibernate removed through a HasAndBelongsToMany relationship.

I have a lot of tags and they are connected to a table called PhotoHasTag, which has only one photo ID and tag ID. When I delete a photo, I want to remove all related phototag tags and delete any orphan tag as well.

Now I have my Photo class setup like this: 

  [ActiveRecord (table = "photo")] Public class photo {[PrimaryKey (column = "PHOTOID" , Generator = Castle.ActiveRecord.PrimaryKeyType.Identity)] Public Virtual Integer ID {Get; Set; } [HasAndBelongsToMany (Table = "PhotoHasTag", ColumnKey = "PHOTOID", ColumnRef = "tagId", Lazy = true, Cascade = ManyRelationCascadeEnum.AllDeleteOrphan)] public virtual IList & LT; Tag & gt; Tags {get; Set; }}

and my tag class is setup very similarly: 

  [ActiveRecord (table = "tag")] public class photos {primary key (Column = "tag id", generator = castle.active record. Premium type type identity)] public virtual id id {receive; Set; } [HasAndBelongsToMany (Table = "PhotoHasTag", ColumnKey = "tagId", ColumnRef = "PHOTOID", Lazy = true)] public IList & LT; Photo & gt; Receive photos { Set; }}

I will try to remove is an error I finally SQL Server picture: 

  conflicted with a delete statement reference obstacle "PhotoHasTag_FK1 ".

I can move around in SQL Server by setting the Delete Rule cascade key, but then only PhotoHasTag be removed as they database if any orphaned Tags Will still stop

I'm considering taking care of a catalyst writing left more tags but I can be very happy if there is a way to setup my ActiveRecord mapping then delete the cascades below is.

Thanks in advance, I have stuck on it forever so I would appreciate any and all help 

  [HasAndBelongsToMany (table = "PhotoHasTag", Cascade = ManyRelationCascadeEnum.AllDeleteOrphan, ColumnKey = "tagId", ColumnRef = "PHOTOID", Lazy:> you so Can specify the cascade behavior in characteristics such as = true)] Public IList & lt; Photo & gt; Receive photos { Set; }

The document is probably more useful.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more