http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660@Dave, Maybe you should check out the Nitpicker Corner at the end of the post... http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment10http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment10Tue, 09 Jun 2009 22:05:26 GMTWho knew NH could double-up as a poetry generator?! http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment9http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment9Tue, 09 Jun 2009 14:16:06 GMTHahahahaha, nice! http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment8http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment8Tue, 09 Jun 2009 12:38:05 GMTSorry, make that 'never a good solution.' http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment7http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment7Tue, 09 Jun 2009 07:29:30 GMTSecurity by obscurity is ever a good solution. And in this case it would only make your work harder when the shit hit the fence. SQL Performance analyze would become a real bitch. Preventing people to run queries is a solution. That's where our nhibernate repository comes in. It's basically a facade around the ISession interface, but it prevents submitting a raw query. Only nhibernate objects or an ICriteria/IQuery instance is allowed. Code should be as self describing as possible. http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment6http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment6Tue, 09 Jun 2009 07:28:22 GMTHahahaha. That's awesome. http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment5http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment5Mon, 08 Jun 2009 19:14:46 GMTNo no no, this just won't work. You are bound to have collisions here. You should use this function to avoid collisions: public string GetName(string prefix, uint code) { StringBuilder result = new StringBuilder(prefix); while (code > words.Length) { result.Append("_"); result.Append(words[code % words.Length); code /= words.Length; } result.Append("_"); result.Append(words[code % words.Length]); } http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment4http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment4Mon, 08 Jun 2009 18:54:30 GMT3rd requirement, the names of tables must be the names of entities in the system: foreach (var clazz in configuration.ClassMappings) clazz.Table.Name = getRandomFromExistingTableNames(); http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment3http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment3Mon, 08 Jun 2009 18:54:27 GMTAyende, this great technique should make it into next edition of 'Teach Yourself Application Architecture in a Weekend' http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment2http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment2Mon, 08 Jun 2009 18:40:06 GMTI once suggested to my DBA team that all table names should be First Names of People, like 'Steve' and 'Lisa' because then you can write SQL like "Insert into <marginally". The ones that laughed were the good ones. >http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment1http://ayende.com/4051/nhibernate-get-thou-out-of-my-database-2nd-edition#comment1Mon, 08 Jun 2009 17:40:01 GMT