http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Ayende, Thanks for the answer, that makes sense :) http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment5http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment5Thu, 22 Jul 2010 08:14:22 GMTNieve, Because presumably the artist information comes from a source that have the id, and I don't want to lose that. Artist may also have the same name, so I use the id to distinguish them. And data integrity, in the sense that you use that term in relational databases isn't that meaningful in a NoSQL store, because that is a different world. And no, you can't do the NH trick with Raven, because Raven explicitly doesn't do relations. http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment4http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment4Thu, 22 Jul 2010 08:00:55 GMTAyende, I suppose having an index on artists only having albums serves only to give an example, but in that case why have an Id per artist? Wouldn't it be easier just to save the name? And if the Id just guarantees data integrity, what would be the best way to save both properties? Is it loading the Artist or Genre just before Creating/Editing the Album since connecting to the db is not too expensive? Are you intending to have at some point the possibility to pass only the Id to the Genre or Artist property and Raven will do the rest, that is populate the other properties (in this case the Name), the way it works in NH? Or am I missing the whole point? http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment3http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment3Sun, 18 Jul 2010 18:13:26 GMTJay, It is in a post coming up soon. http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment2http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment2Tue, 01 Jun 2010 19:47:28 GMTCan you provide an example of the kind of code you would use to propagate a change to an artist across all albums? http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment1http://ayende.com/4531/porting-mvc-music-store-to-raven-storemanagercontroller-part-2#comment1Tue, 01 Jun 2010 13:19:15 GMT