http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660@Rob: I'm looking forward to your take on database migrations. I think most shops out (mine included) have a pretty half assed approach! I'm basing mine off numbered SQL change scripts, and a nant script that updates the databases. It works for us, but is nowhere near polished and it would be awesome if there was a community shared solution. Will it be usable by projects not using SubSonic? http://ayende.com/2906/microsoft-subsonic-and-open-source#comment10http://ayende.com/2906/microsoft-subsonic-and-open-source#comment10Sat, 27 Oct 2007 09:38:41 GMTThanks for the writeup Oren :). In terms of Migrations I'd love to share the code on it. It's not the easiest thing in the world to do but I think I have a neat way of making it happen. I haven't checked in the final bits but users of NHib can are absolutely welcome. In terms of the ORM bits- there are so many players coming on, most notable is LinqToSql. To me it's a lot less about how you get the data and a lot more about what you're gonna do when you get off work that night :). We all win with tools that shave time. http://ayende.com/2906/microsoft-subsonic-and-open-source#comment9http://ayende.com/2906/microsoft-subsonic-and-open-source#comment9Sat, 27 Oct 2007 00:06:51 GMT@Josh: Marc André Cournoyer already built migrations for castle. It is now at: http://code.google.com/p/migratordotnet/ I think the competition for NHibernate is more the entity framework. Subsonic though could make a wrapper of it and be more like what Castle ActiveRecord is to NHibernate. http://ayende.com/2906/microsoft-subsonic-and-open-source#comment8http://ayende.com/2906/microsoft-subsonic-and-open-source#comment8Fri, 26 Oct 2007 21:30:29 GMTJosh, I think we did at some time, not sure about its status. https://svn.castleproject.org/svn/castle/trunk/Experiments/Generator/Generators/Migration http://ayende.com/2906/microsoft-subsonic-and-open-source#comment7http://ayende.com/2906/microsoft-subsonic-and-open-source#comment7Fri, 26 Oct 2007 21:23:23 GMTSubsonic is a mixture of things. It has code gen and ORM. You can whip up a [not-really] MVC-ish website really quick. Lately, he's been working on a db:migrate feature for it, which will just rock. love to see something like that in castle. http://ayende.com/2906/microsoft-subsonic-and-open-source#comment6http://ayende.com/2906/microsoft-subsonic-and-open-source#comment6Fri, 26 Oct 2007 21:13:48 GMTShawn, You are probably correct, come to think about it. The difference, as far as I am concern, is that SubSonic has its own identity, quite apart from MS. IronXyz doesn't really have an identity of their own, they are just languages. http://ayende.com/2906/microsoft-subsonic-and-open-source#comment5http://ayende.com/2906/microsoft-subsonic-and-open-source#comment5Fri, 26 Oct 2007 20:42:53 GMTI'm not sure of the specifics, or even if I am correct, but I think that both the IronPython and IronRuby guys were hired under similar circumstances. http://ayende.com/2906/microsoft-subsonic-and-open-source#comment3http://ayende.com/2906/microsoft-subsonic-and-open-source#comment3Fri, 26 Oct 2007 20:33:44 GMTI'm not sure of the specifics, or even if I am correct, but I think that both the IronPython and IronRuby guys were hired under similar circumstances. http://ayende.com/2906/microsoft-subsonic-and-open-source#comment4http://ayende.com/2906/microsoft-subsonic-and-open-source#comment4Fri, 26 Oct 2007 20:33:44 GMTJonathan, SubSonic is an action pack, it include web tools, simple OR/M, etc. I actually have very little experience with it, so I can't really tell. I don't think that this is close to NH's in features. http://ayende.com/2906/microsoft-subsonic-and-open-source#comment2http://ayende.com/2906/microsoft-subsonic-and-open-source#comment2Fri, 26 Oct 2007 20:31:46 GMTSo, is this an intent to replace NHibernate? I understand that this is not a ORM, am I wrong? http://ayende.com/2906/microsoft-subsonic-and-open-source#comment1http://ayende.com/2906/microsoft-subsonic-and-open-source#comment1Fri, 26 Oct 2007 20:08:23 GMT